Re: Increasing the size limits implications
We have a requirement to store blob data . Sent from my iPhone > On Apr 30, 2019, at 9:16 AM, Jon Haddad 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 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-unsubscr...@cassandra.apache.org > For additional commands, e-mail: user-h...@cassandra.apache.org > - To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands, e-mail: user-h...@cassandra.apache.org
Re: Increasing the size limits implications
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 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-unsubscr...@cassandra.apache.org For additional commands, e-mail: user-h...@cassandra.apache.org
Re: Increasing the size limits implications
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 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
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