cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From shahab <shahab.mok...@gmail.com>
Subject Re: Increasing size of "Batch of prepared statements"
Date Thu, 23 Oct 2014 07:59:53 GMT
Thanks Jens for the comments.

As I am trying "cassandra stress tool", does it mean that the tool is
executing batch of "Insert" statements (probably hundreds, or thousands)
 to the cassandra (for the sake of stressing Cassnadra ?

best,
/Shahab

On Wed, Oct 22, 2014 at 8:14 PM, Jens Rantil <jens.rantil@tink.se> wrote:

> Shabab,
>
> Apologize for the late answer.
>
> On Mon, Oct 6, 2014 at 2:38 PM, shahab <shahab.mokari@gmail.com> wrote:
>
>> But do you mean that inserting columns with large size (let's say a text
>> with 20-30 K) is potentially problematic in Cassandra?
>
>
> AFAIK, the size _warning_ you are getting relates to the size of the batch
> of prepared statements (INSERT INTO mykeyspace.mytable VALUES (?,?,?,?)).
> That is, it has nothing to do with the actual content of your row. 20-30 K
> shouldn't be a problem. But it's considered good practise to split larger
> files (maybe > 5 MB into chunks) since it makes operations easier to your
> cluster more likely to spread more evenly across cluster.
>
>
>> What shall i do if I want columns with large size?
>
>
> Just don't insert to many rows in a single batch and you should be fine.
> Like Shane's JIRA ticket said, the warning is to let you know you are not
> following best practice when adding too many rows in a single batch. It can
> create bottlenecks in a single Cassandra node.
>
> Cheers,
> Jens
>
> --
> Jens Rantil
> Backend engineer
> Tink AB
>
> Email: jens.rantil@tink.se
> Phone: +46 708 84 18 32
> Web: www.tink.se
>
> Facebook <https://www.facebook.com/#!/tink.se> Linkedin
> <http://www.linkedin.com/company/2735919?trk=vsrp_companies_res_photo&trkInfo=VSRPsearchId%3A1057023381369207406670%2CVSRPtargetId%3A2735919%2CVSRPcmpt%3Aprimary>
>  Twitter <https://twitter.com/tink>
>

Mime
View raw message