Skip to content

Instantly share code, notes, and snippets.

@dimmu

dimmu/scyladb vs cassandra benchmark (single node, containerized)

Created March 8, 2017 13:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dimmu/6b08906d2f0c208444705f6b34c31561 to your computer and use it in GitHub Desktop.
Save dimmu/6b08906d2f0c208444705f6b34c31561 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
scyladb vs cassandra benchmark (single node, containerized)
SCYLA WRITES:
id, type, total ops, op/s, pk/s, row/s, mean, med, .95, .99, .999, max, time, stderr, errors, gc: #, max ms, sum ms, sdv ms, mb
4 threadCount, WRITE, 328557, 10880, 10880, 10880, 0.4, 0.3, 0.6, 0.9, 5.0, 50.0, 30.2, 0.01557, 0, 0, 0, 0, 0, 0
4 threadCount, total, 328557, 10880, 10880, 10880, 0.4, 0.3, 0.6, 0.9, 5.0, 50.0, 30.2, 0.01557, 0, 0, 0, 0, 0, 0
8 threadCount, WRITE, 461923, 15278, 15278, 15278, 0.5, 0.4, 1.0, 1.4, 4.6, 74.6, 30.2, 0.02429, 0, 0, 0, 0, 0, 0
8 threadCount, total, 461923, 15278, 15278, 15278, 0.5, 0.4, 1.0, 1.4, 4.6, 74.6, 30.2, 0.02429, 0, 0, 0, 0, 0, 0
16 threadCount, WRITE, 648995, 21530, 21530, 21530, 0.7, 0.7, 1.3, 1.9, 5.9, 75.3, 30.1, 0.01175, 0, 0, 0, 0, 0, 0
16 threadCount, total, 648995, 21530, 21530, 21530, 0.7, 0.7, 1.3, 1.9, 5.9, 75.3, 30.1, 0.01175, 0, 0, 0, 0, 0, 0
24 threadCount, WRITE, 790948, 26247, 26247, 26247, 0.9, 0.8, 1.6, 2.3, 4.1, 23.0, 30.1, 0.00591, 0, 0, 0, 0, 0, 0
24 threadCount, total, 790948, 26247, 26247, 26247, 0.9, 0.8, 1.6, 2.3, 4.1, 23.0, 30.1, 0.00591, 0, 0, 0, 0, 0, 0
36 threadCount, WRITE, 926559, 30703, 30703, 30703, 1.2, 1.0, 2.5, 3.8, 6.6, 25.4, 30.2, 0.00546, 0, 0, 0, 0, 0, 0
36 threadCount, total, 926559, 30703, 30703, 30703, 1.2, 1.0, 2.5, 3.8, 6.6, 25.4, 30.2, 0.00546, 0, 0, 0, 0, 0, 0
54 threadCount, WRITE, 1069439, 35388, 35388, 35388, 1.5, 1.2, 3.4, 5.2, 8.7, 48.6, 30.2, 0.00695, 0, 0, 0, 0, 0, 0
54 threadCount, total, 1069439, 35388, 35388, 35388, 1.5, 1.2, 3.4, 5.2, 8.7, 48.6, 30.2, 0.00695, 0, 0, 0, 0, 0, 0
81 threadCount, WRITE, 1242011, 40976, 40976, 40976, 2.0, 1.6, 4.4, 6.7, 11.4, 55.2, 30.3, 0.01121, 0, 0, 0, 0, 0, 0
81 threadCount, total, 1242011, 40976, 40976, 40976, 2.0, 1.6, 4.4, 6.7, 11.4, 55.2, 30.3, 0.01121, 0, 0, 0, 0, 0, 0
121 threadCount, WRITE, 1421529, 46846, 46846, 46846, 2.6, 2.2, 5.6, 8.7, 17.6, 80.9, 30.3, 0.00614, 0, 0, 0, 0, 0, 0
121 threadCount, total, 1421529, 46846, 46846, 46846, 2.6, 2.2, 5.6, 8.7, 17.6, 80.9, 30.3, 0.00614, 0, 0, 0, 0, 0, 0
181 threadCount, WRITE, 1598305, 52449, 52449, 52449, 3.4, 3.0, 7.1, 10.8, 22.8, 75.7, 30.5, 0.00433, 0, 0, 0, 0, 0, 0
181 threadCount, total, 1598305, 52449, 52449, 52449, 3.4, 3.0, 7.1, 10.8, 22.8, 75.7, 30.5, 0.00433, 0, 0, 0, 0, 0, 0
271 threadCount, WRITE, 1781409, 58078, 58078, 58078, 4.7, 4.0, 9.7, 15.1, 32.5, 122.5, 30.7, 0.00491, 0, 0, 0, 0, 0, 0
271 threadCount, total, 1781409, 58078, 58078, 58078, 4.7, 4.0, 9.7, 15.1, 32.5, 122.5, 30.7, 0.00491, 0, 0, 0, 0, 0, 0
406 threadCount, WRITE, 1936359, 62348, 62348, 62348, 6.5, 5.3, 14.8, 24.3, 47.9, 138.8, 31.1, 0.00872, 0, 0, 0, 0, 0, 0
406 threadCount, total, 1936359, 62348, 62348, 62348, 6.5, 5.3, 14.8, 24.3, 47.9, 138.8, 31.1, 0.00872, 0, 0, 0, 0, 0, 0
609 threadCount, WRITE, 2227671, 62411, 62411, 62411, 9.7, 8.0, 21.6, 30.9, 51.2, 583.4, 35.7, 0.01980, 0, 0, 0, 0, 0, 0
609 threadCount, total, 2227671, 62411, 62411, 62411, 9.7, 8.0, 21.6, 30.9, 51.2, 583.4, 35.7, 0.01980, 0, 0, 0, 0, 0, 0
913 threadCount, WRITE, 2207513, 69745, 69745, 69745, 13.1, 10.8, 29.1, 44.1, 71.2, 166.8, 31.7, 0.01160, 0, 0, 0, 0, 0, 0
913 threadCount, total, 2207513, 69745, 69745, 69745, 13.1, 10.8, 29.1, 44.1, 71.2, 166.8, 31.7, 0.01160, 0, 0, 0, 0, 0, 0
END
Scyla reads:
id, type, total ops, op/s, pk/s, row/s, mean, med, .95, .99, .999, max, time, stderr, errors, gc: #, max ms, sum ms, sdv ms, mb
4 threadCount, READ, 305589, 10107, 10107, 10107, 0.4, 0.3, 0.7, 1.0, 5.5, 53.0, 30.2, 0.02583, 0, 0, 0, 0, 0, 0
4 threadCount, total, 305589, 10107, 10107, 10107, 0.4, 0.3, 0.7, 1.0, 5.5, 53.0, 30.2, 0.02583, 0, 0, 0, 0, 0, 0
8 threadCount, READ, 433508, 14394, 14394, 14394, 0.5, 0.5, 1.0, 1.5, 5.7, 57.3, 30.1, 0.01571, 0, 0, 0, 0, 0, 0
8 threadCount, total, 433508, 14394, 14394, 14394, 0.5, 0.5, 1.0, 1.5, 5.7, 57.3, 30.1, 0.01571, 0, 0, 0, 0, 0, 0
16 threadCount, READ, 588836, 19502, 19502, 19502, 0.8, 0.7, 1.4, 3.1, 6.9, 48.0, 30.2, 0.01406, 0, 0, 0, 0, 0, 0
16 threadCount, total, 588836, 19502, 19502, 19502, 0.8, 0.7, 1.4, 3.1, 6.9, 48.0, 30.2, 0.01406, 0, 0, 0, 0, 0, 0
24 threadCount, READ, 722077, 23927, 23927, 23927, 1.0, 0.9, 1.8, 2.7, 6.2, 53.1, 30.2, 0.00937, 0, 0, 0, 0, 0, 0
24 threadCount, total, 722077, 23927, 23927, 23927, 1.0, 0.9, 1.8, 2.7, 6.2, 53.1, 30.2, 0.00937, 0, 0, 0, 0, 0, 0
36 threadCount, READ, 862106, 28551, 28551, 28551, 1.2, 1.1, 2.6, 3.9, 7.1, 57.5, 30.2, 0.00198, 0, 0, 0, 0, 0, 0
36 threadCount, total, 862106, 28551, 28551, 28551, 1.2, 1.1, 2.6, 3.9, 7.1, 57.5, 30.2, 0.00198, 0, 0, 0, 0, 0, 0
54 threadCount, READ, 978984, 32323, 32323, 32323, 1.7, 1.3, 3.8, 6.0, 10.6, 47.0, 30.3, 0.01312, 0, 0, 0, 0, 0, 0
54 threadCount, total, 978984, 32323, 32323, 32323, 1.7, 1.3, 3.8, 6.0, 10.6, 47.0, 30.3, 0.01312, 0, 0, 0, 0, 0, 0
81 threadCount, READ, 1151333, 37765, 37765, 37765, 2.1, 1.7, 4.8, 7.9, 14.7, 47.7, 30.5, 0.00363, 0, 0, 0, 0, 0, 0
81 threadCount, total, 1151333, 37765, 37765, 37765, 2.1, 1.7, 4.8, 7.9, 14.7, 47.7, 30.5, 0.00363, 0, 0, 0, 0, 0, 0
121 threadCount, READ, 1322136, 43475, 43475, 43475, 2.8, 2.3, 6.3, 10.3, 19.3, 63.8, 30.4, 0.00627, 0, 0, 0, 0, 0, 0
121 threadCount, total, 1322136, 43475, 43475, 43475, 2.8, 2.3, 6.3, 10.3, 19.3, 63.8, 30.4, 0.00627, 0, 0, 0, 0, 0, 0
181 threadCount, READ, 1467579, 48026, 48026, 48026, 3.8, 3.1, 8.4, 13.5, 25.3, 59.3, 30.6, 0.01608, 0, 0, 0, 0, 0, 0
181 threadCount, total, 1467579, 48026, 48026, 48026, 3.8, 3.1, 8.4, 13.5, 25.3, 59.3, 30.6, 0.01608, 0, 0, 0, 0, 0, 0
271 threadCount, READ, 1605088, 52025, 52025, 52025, 5.2, 4.3, 11.5, 18.6, 34.4, 238.3, 30.9, 0.00908, 0, 0, 0, 0, 0, 0
271 threadCount, total, 1605088, 52025, 52025, 52025, 5.2, 4.3, 11.5, 18.6, 34.4, 238.3, 30.9, 0.00908, 0, 0, 0, 0, 0, 0
406 threadCount, READ, 1729976, 55393, 55393, 55393, 7.3, 5.8, 17.4, 27.8, 53.5, 167.2, 31.2, 0.00499, 0, 0, 0, 0, 0, 0
406 threadCount, total, 1729976, 55393, 55393, 55393, 7.3, 5.8, 17.4, 27.8, 53.5, 167.2, 31.2, 0.00499, 0, 0, 0, 0, 0, 0
609 threadCount, READ, 1934864, 55369, 55369, 55369, 11.0, 8.6, 23.6, 34.1, 66.4, 939.0, 34.9, 0.01919, 0, 0, 0, 0, 0, 0
609 threadCount, total, 1934864, 55369, 55369, 55369, 11.0, 8.6, 23.6, 34.1, 66.4, 939.0, 34.9, 0.01919, 0, 0, 0, 0, 0, 0
913 threadCount, READ, 1949213, 61258, 61258, 61258, 14.9, 12.5, 31.9, 46.9, 87.2, 182.8, 31.8, 0.00424, 0, 0, 0, 0, 0, 0
913 threadCount, total, 1949213, 61258, 61258, 61258, 14.9, 12.5, 31.9, 46.9, 87.2, 182.8, 31.8, 0.00424, 0, 0, 0, 0, 0, 0
END
=================================================================================================================
Cassandra 3.10 writes:
id, type total ops, op/s, pk/s, row/s, mean, med, .95, .99, .999, max, time, stderr, errors, gc: #, max ms, sum ms, sdv ms, mb
4 threadCount, WRITE, 285724, 8163, 8163, 8163, 0.5, 0.4, 0.7, 0.9, 3.9, 70.8, 35.0, 0.02402, 0, 4, 223, 223, 12, 2366
4 threadCount, total, 285724, 8163, 8163, 8163, 0.5, 0.4, 0.7, 0.9, 3.9, 70.8, 35.0, 0.02402, 0, 4, 223, 223, 12, 2366
8 threadCount, WRITE, 294235, 9805, 9805, 9805, 0.8, 0.7, 1.3, 1.7, 4.6, 76.9, 30.0, 0.03755, 0, 5, 303, 303, 8, 2954
8 threadCount, total, 294235, 9805, 9805, 9805, 0.8, 0.7, 1.3, 1.7, 4.6, 76.9, 30.0, 0.03755, 0, 5, 303, 303, 8, 2954
16 threadCount, WRITE, 445437, 14847, 14847, 14847, 1.1, 0.9, 1.9, 2.9, 5.9, 74.9, 30.0, 0.75571, 0, 6, 380, 380, 4, 3518
16 threadCount, total, 445437, 14847, 14847, 14847, 1.1, 0.9, 1.9, 2.9, 5.9, 74.9, 30.0, 0.75571, 0, 6, 380, 380, 4, 3518
24 threadCount, WRITE, 546030, 18199, 18199, 18199, 1.3, 1.1, 2.5, 4.0, 8.3, 74.3, 30.0, 0.96008, 0, 7, 446, 446, 4, 4100
24 threadCount, total, 546030, 18199, 18199, 18199, 1.3, 1.1, 2.5, 4.0, 8.3, 74.3, 30.0, 0.96008, 0, 7, 446, 446, 4, 4100
36 threadCount, WRITE, 652191, 21737, 21737, 21737, 1.6, 1.3, 3.4, 6.0, 14.2, 97.5, 30.0, 0.15974, 0, 10, 639, 639, 10, 5836
36 threadCount, total, 652191, 21737, 21737, 21737, 1.6, 1.3, 3.4, 6.0, 14.2, 97.5, 30.0, 0.15974, 0, 10, 639, 639, 10, 5836
54 threadCount, WRITE, 774739, 25820, 25820, 25820, 2.1, 1.6, 4.6, 8.2, 18.0, 88.4, 30.0, 0.09499, 0, 10, 722, 722, 7, 5768
54 threadCount, total, 774739, 25820, 25820, 25820, 2.1, 1.6, 4.6, 8.2, 18.0, 88.4, 30.0, 0.09499, 0, 10, 722, 722, 7, 5768
81 threadCount, WRITE, 903817, 30121, 30121, 30121, 2.7, 2.0, 6.5, 11.9, 63.0, 94.8, 30.0, 0.08100, 0, 12, 853, 853, 7, 6918
81 threadCount, total, 903817, 30121, 30121, 30121, 2.7, 2.0, 6.5, 11.9, 63.0, 94.8, 30.0, 0.08100, 0, 12, 853, 853, 7, 6918
121 threadCount, WRITE, 1012226, 33713, 33713, 33713, 3.6, 2.5, 9.4, 16.2, 79.1, 103.5, 30.0, 0.25288, 0, 14, 981, 981, 11, 8110
121 threadCount, total, 1012226, 33713, 33713, 33713, 3.6, 2.5, 9.4, 16.2, 79.1, 103.5, 30.0, 0.25288, 0, 14, 981, 981, 11, 8110
181 threadCount, WRITE, 1051922, 35056, 35056, 35056, 5.1, 3.5, 14.3, 25.7, 72.0, 98.4, 30.0, 0.05920, 0, 18, 1056, 1056, 9, 10603
181 threadCount, total, 1051922, 35056, 35056, 35056, 5.1, 3.5, 14.3, 25.7, 72.0, 98.4, 30.0, 0.05920, 0, 18, 1056, 1056, 9, 10603
271 threadCount, WRITE, 1180533, 39335, 39335, 39335, 6.9, 5.0, 17.5, 29.5, 88.7, 138.3, 30.0, 0.04975, 0, 15, 1044, 1044, 10, 8629
271 threadCount, total, 1180533, 39335, 39335, 39335, 6.9, 5.0, 17.5, 29.5, 88.7, 138.3, 30.0, 0.04975, 0, 15, 1044, 1044, 10, 8629
406 threadCount, WRITE, 1246272, 41528, 41528, 41528, 9.7, 7.6, 23.1, 39.0, 88.9, 133.5, 30.0, 0.04522, 0, 17, 1146, 1146, 5, 9811
406 threadCount, total, 1246272, 41528, 41528, 41528, 9.7, 7.6, 23.1, 39.0, 88.9, 133.5, 30.0, 0.04522, 0, 17, 1146, 1146, 5, 9811
609 threadCount, WRITE, 1268475, 42253, 42253, 42253, 14.3, 11.6, 33.2, 68.8, 102.6, 216.0, 30.0, 0.05877, 0, 19, 1113, 1113, 14, 11092
609 threadCount, total, 1268475, 42253, 42253, 42253, 14.3, 11.6, 33.2, 68.8, 102.6, 216.0, 30.0, 0.05877, 0, 19, 1113, 1113, 14, 11092
913 threadCount, WRITE, 1276882, 42533, 42533, 42533, 21.3, 18.2, 44.6, 90.8, 159.9, 415.5, 30.0, 0.06204, 0, 18, 1108, 1108, 15, 10456
913 threadCount, total, 1276882, 42533, 42533, 42533, 21.3, 18.2, 44.6, 90.8, 159.9, 415.5, 30.0, 0.06204, 0, 18, 1108, 1108, 15, 10456
reads:
id, type total ops, op/s, pk/s, row/s, mean, med, .95, .99, .999, max, time, stderr, errors, gc: #, max ms, sum ms, sdv ms, mb
4 threadCount, READ, 225430, 7514, 7514, 7514, 0.5, 0.5, 0.7, 0.9, 4.3, 40.0, 30.0, 0.01064, 0, 6, 115, 115, 1, 3802
4 threadCount, total, 225430, 7514, 7514, 7514, 0.5, 0.5, 0.7, 0.9, 4.3, 40.0, 30.0, 0.01064, 0, 6, 115, 115, 1, 3802
8 threadCount, READ, 270583, 9019, 9019, 9019, 0.9, 0.8, 1.4, 2.0, 4.8, 31.2, 30.0, 0.07611, 0, 6, 129, 129, 4, 3820
8 threadCount, total, 270583, 9019, 9019, 9019, 0.9, 0.8, 1.4, 2.0, 4.8, 31.2, 30.0, 0.07611, 0, 6, 129, 129, 4, 3820
16 threadCount, READ, 382902, 12761, 12761, 12761, 1.2, 1.1, 2.4, 3.6, 8.3, 30.0, 30.0, 0.18006, 0, 8, 170, 170, 3, 5093
16 threadCount, total, 382902, 12761, 12761, 12761, 1.2, 1.1, 2.4, 3.6, 8.3, 30.0, 30.0, 0.18006, 0, 8, 170, 170, 3, 5093
24 threadCount, READ, 465070, 15500, 15500, 15500, 1.5, 1.3, 3.1, 5.0, 11.0, 29.2, 30.0, 0.18411, 0, 9, 168, 168, 2, 5745
24 threadCount, total, 465070, 15500, 15500, 15500, 1.5, 1.3, 3.1, 5.0, 11.0, 29.2, 30.0, 0.18411, 0, 9, 168, 168, 2, 5745
36 threadCount, READ, 546611, 18217, 18217, 18217, 2.0, 1.6, 4.3, 7.2, 15.0, 30.3, 30.0, -3.75679, 0, 10, 174, 174, 1, 6389
36 threadCount, total, 546611, 18217, 18217, 18217, 2.0, 1.6, 4.3, 7.2, 15.0, 30.3, 30.0, -3.75679, 0, 10, 174, 174, 1, 6389
54 threadCount, READ, 626721, 20883, 20883, 20883, 2.6, 2.0, 6.1, 10.5, 22.0, 48.0, 30.0, 0.04829, 0, 11, 206, 206, 2, 7031
54 threadCount, total, 626721, 20883, 20883, 20883, 2.6, 2.0, 6.1, 10.5, 22.0, 48.0, 30.0, 0.04829, 0, 11, 206, 206, 2, 7031
81 threadCount, READ, 718258, 23931, 23931, 23931, 3.4, 2.6, 8.4, 14.7, 26.7, 51.4, 30.0, 0.08767, 0, 12, 217, 217, 2, 7674
81 threadCount, total, 718258, 23931, 23931, 23931, 3.4, 2.6, 8.4, 14.7, 26.7, 51.4, 30.0, 0.08767, 0, 12, 217, 217, 2, 7674
121 threadCount, READ, 799272, 26637, 26637, 26637, 4.5, 3.4, 11.7, 19.4, 32.0, 60.1, 30.0, 0.04917, 0, 14, 251, 251, 2, 8954
121 threadCount, total, 799272, 26637, 26637, 26637, 4.5, 3.4, 11.7, 19.4, 32.0, 60.1, 30.0, 0.04917, 0, 14, 251, 251, 2, 8954
181 threadCount, READ, 873478, 29104, 29104, 29104, 6.2, 4.7, 15.8, 25.3, 41.4, 142.3, 30.0, 0.05593, 0, 14, 295, 295, 6, 8944
181 threadCount, total, 873478, 29104, 29104, 29104, 6.2, 4.7, 15.8, 25.3, 41.4, 142.3, 30.0, 0.05593, 0, 14, 295, 295, 6, 8944
271 threadCount, READ, 931044, 31010, 31010, 31010, 8.7, 6.8, 21.8, 33.0, 50.5, 119.3, 30.0, 0.05045, 0, 15, 270, 270, 3, 9596
271 threadCount, total, 931044, 31010, 31010, 31010, 8.7, 6.8, 21.8, 33.0, 50.5, 119.3, 30.0, 0.05045, 0, 15, 270, 270, 3, 9596
406 threadCount, READ, 973083, 32419, 32419, 32419, 12.5, 10.2, 29.3, 42.9, 69.1, 170.9, 30.0, 0.05421, 0, 16, 301, 301, 4, 10236
406 threadCount, total, 973083, 32419, 32419, 32419, 12.5, 10.2, 29.3, 42.9, 69.1, 170.9, 30.0, 0.05421, 0, 16, 301, 301, 4, 10236
609 threadCount, READ, 1003894, 33421, 33421, 33421, 18.1, 16.1, 38.4, 55.8, 88.3, 172.6, 30.0, 0.04802, 0, 17, 355, 355, 3, 10877
609 threadCount, total, 1003894, 33421, 33421, 33421, 18.1, 16.1, 38.4, 55.8, 88.3, 172.6, 30.0, 0.04802, 0, 17, 355, 355, 3, 10877
913 threadCount, READ, 1009209, 33589, 33589, 33589, 27.0, 24.7, 53.3, 77.7, 158.7, 234.1, 30.0, 0.06550, 0, 16, 357, 357, 3, 10237
913 threadCount, total, 1009209, 33589, 33589, 33589, 27.0, 24.7, 53.3, 77.7, 158.7, 234.1, 30.0, 0.06550, 0, 16, 357, 357, 3, 10237
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment