You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Bobbie Haynes <ha...@gmail.com> on 2019/04/29 17:17:58 UTC
Increasing the size limits implications
Hi,
I'm inserting into cassandra in batches(With each containing single
PK ).But my batch is failing and throwing exceptions.
I want to know if we increase batch_size_warn_threshold_in_kb to 200KB
and batch_size_fail_threshold_in_kb
to 300KB. What could be potential issues i could be facing
Thanks,
Bobbie
Re: Increasing the size limits implications
Posted by Nitan Kainth <ni...@gmail.com>.
Increasing batch size could potentially lead to longer GC pauses.
Try to break you batch size. 300kb is a decent limit for most use cases.
Regards,
Nitan
Cell: 510 449 9629
> On Apr 29, 2019, at 12:17 PM, Bobbie Haynes <ha...@gmail.com> wrote:
>
> Hi,
> I'm inserting into cassandra in batches(With each containing single PK ).But my batch is failing and throwing exceptions.
> I want to know if we increase batch_size_warn_threshold_in_kb to 200KB and batch_size_fail_threshold_in_kb to 300KB. What could be potential issues i could be facing
>
> Thanks,
> Bobbie
Re: Increasing the size limits implications
Posted by Bobbie Haynes <ha...@gmail.com>.
We have a requirement to store blob data .
Sent from my iPhone
> On Apr 30, 2019, at 9:16 AM, Jon Haddad <jo...@jonhaddad.com> wrote:
>
> Just curious - why are you using such large batches? Most of the time
> when someone asks this question, it's because they're using batches as
> they would in an RDBMS, because larger transactions improve
> performance. That doesn't apply with Cassandra.
>
> Batches are OK at keeping multiple tables in sync, that's about it.
>
> Jon
>
>> On Mon, Apr 29, 2019 at 10:18 AM Bobbie Haynes <ha...@gmail.com> wrote:
>>
>> Hi,
>> I'm inserting into cassandra in batches(With each containing single PK ).But my batch is failing and throwing exceptions.
>> I want to know if we increase batch_size_warn_threshold_in_kb to 200KB and batch_size_fail_threshold_in_kb to 300KB. What could be potential issues i could be facing
>>
>> Thanks,
>> Bobbie
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
> For additional commands, e-mail: user-help@cassandra.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org
Re: Increasing the size limits implications
Posted by Jon Haddad <jo...@jonhaddad.com>.
Just curious - why are you using such large batches? Most of the time
when someone asks this question, it's because they're using batches as
they would in an RDBMS, because larger transactions improve
performance. That doesn't apply with Cassandra.
Batches are OK at keeping multiple tables in sync, that's about it.
Jon
On Mon, Apr 29, 2019 at 10:18 AM Bobbie Haynes <ha...@gmail.com> wrote:
>
> Hi,
> I'm inserting into cassandra in batches(With each containing single PK ).But my batch is failing and throwing exceptions.
> I want to know if we increase batch_size_warn_threshold_in_kb to 200KB and batch_size_fail_threshold_in_kb to 300KB. What could be potential issues i could be facing
>
> Thanks,
> Bobbie
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org