[
https://issues.apache.org/jira/browse/CASSANDRA-4545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13459174#comment-13459174
]
Aleksey Yeschenko commented on CASSANDRA-4545:
----------------------------------------------
I've done some simple benchmarking using cassandra-stress Inserter and modified
Inserter that uses atomic_batch_mutate instead of batch_mutate. I used a
three-node cluster, wiped and restarted every machine between test runs.
cassandra-stres was being run from a fourth machine.
Every batch only contains mutations to one partition key. I'll have to modify
Stress more to include mutations of different rows in a batch. The difference
will be larger there (regular mutations will be sent to different machines in
parallel, but the whole serialized batch itself will still be sent in one
piece, and we'll be waiting for at least one response (CL.ONE) before
distributing regular mutations). So take the following numbers as the least
possible difference between batch_mutate and atomic_batch_mutate or
atomic_batch_mutate best case scenario.
-n 1000 -c 1
== batch mutate
1000,100,100,0.008556,0
== atomic batch mutate
1000,100,100,0.024504,3
-n 1000 -c 10
== batch mutate
1000,100,100,0.010149,0
== atomic batch mutate
1000,100,100,0.032331,1
-n 1000 -c 100
== batch mutate
1000,100,100,0.038674,2
== atomic batch mutate
1000,100,100,0.041967,2
-n 1000 -c 1000
== batch mutate
1000,100,100,0.088965,4
== atomic batch mutate
1000,100,100,0.136551,6
-n 1000 -c 10000
== batch mutate
547,54,54,0.6684040219378428,11
1000,45,45,0.5687505518763797,18
== atomic batch mutate
546,54,54,0.7630347985347985,11
924,37,37,0.768542328042328,21
1000,7,7,1.5153157894736842,24
-n 50 -c 100000
== batch mutate
8,0,0,8.057,23
33,2,2,14.80572,33
50,1,1,18.833529411764705,35
== atomic batch mutate
10,1,1,6.5336,20
30,2,2,14.04065,30
40,1,1,27.3045,40
50,1,1,31.8171,46
> add cql support for batchlog
> ----------------------------
>
> Key: CASSANDRA-4545
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4545
> Project: Cassandra
> Issue Type: Sub-task
> Reporter: Jonathan Ellis
> Assignee: Aleksey Yeschenko
>
> Need to expose the equivalent of atomic_batch_mutate (CASSANDRA-4542) to CQL3.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
