Introduction
This is a report for the insert benchmark with 120M docs and 12 client(s). It is generated by scripts (bash, awk, sed) and Tufte might not be impressed. An overview of the insert benchmark is here and a short update is here. Below, by DBMS, I mean DBMS+version.config. An example is my8020.c10b40 where my means MySQL, 8020 is version 8.0.20 and c10b40 is the name for the configuration file.
The test server has 32 cores, 128G RAM and 1 NVMe device. The benchmark was run with 12 clients and there were 1 or 3 connections per client (1 for queries or inserts without rate limits, 1+1 for rate limited inserts+deletes). It uses 8 tables with a table per client. It loads 10M rows per table without secondary indexes, creates 3 secondary indexes per table, then inserts 16m+4m rows per table with a delete per insert to avoid growing the table. It then does 6 read+write tests for 1800s each that do queries as fast as possible with 100,100,500,500,1000,1000 inserts/s and the same for deletes/s per client concurrent with the queries. The database is cached. Clients and the DBMS share one server.
The tested DBMS are:
- ma120300_rel_withdbg.cz12b_sync_c32r128 - MariaDB 12.3.0 with the z12b_config that adds sync_binlog=1 and innodb_flush_log_at_trx_commit=1 to z12b
- ma120300_rel_withdbg.cz12c_sync_c32r128 - MariaDB 12.3.0 with the z12c_config that adds innodb_flush_log_at_trx_commit=1 to z12c
Contents
- Summary
- l.i0: load without secondary indexes
- l.x: create secondary indexes
- l.i1: continue load after secondary indexes created with 50 inserts per transaction
- l.i2: continue load after secondary indexes created with 5 inserts per transaction
- qr100.L1: range queries with 100 insert/s per client
- qp100.L2: point queries with 100 insert/s per client
- qr500.L3: range queries with 500 insert/s per client
- qp500.L4: point queries with 500 insert/s per client
- qr1000.L5: range queries with 1000 insert/s per client
- qp1000.L6: point queries with 1000 insert/s per client
Summary
The numbers are inserts/s for l.i0, l.i1 and l.i2, indexed docs (or rows) /s for l.x and queries/s for qr100, qp100 thru qr1000, qp1000" The values are the average rate over the entire test for inserts (IPS) and queries (QPS). The range of values for IPS and QPS is split into 3 parts: bottom 25%, middle 50%, top 25%. Values in the bottom 25% have a red background, values in the top 25% have a green background and values in the middle have no color. A gray background is used for values that can be ignored because the DBMS did not sustain the target insert rate. Red backgrounds are not used when the minimum value is within 80% of the max value.
| dbms | l.i0 | l.x | l.i1 | l.i2 | qr100 | qp100 | qr500 | qp500 | qr1000 | qp1000 |
|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 122449 | 1846155 | 63054 | 10690 | 90926 | 84875 | 89597 | 83986 | 88403 | 82451 |
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 442804 | 1846155 | 171735 | 38710 | 90487 | 84249 | 89501 | 83615 | 88449 | 82584 |
This table has relative throughput, throughput for the DBMS relative to the DBMS in the first line, using the absolute throughput from the previous table. Values less than 0.95 have a yellow background. Values greater than 1.05 have a blue background.
| dbms | l.i0 | l.x | l.i1 | l.i2 | qr100 | qp100 | qr500 | qp500 | qr1000 | qp1000 |
|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 3.62 | 1.00 | 2.72 | 3.62 | 1.00 | 0.99 | 1.00 | 1.00 | 1.00 | 1.00 |
This lists the average rate of inserts/s for the tests that do inserts concurrent with queries. For such tests the query rate is listed in the table above. The read+write tests are setup so that the insert rate should match the target rate every second. Cells that are not at least 95% of the target have a red background to indicate a failure to satisfy the target.
| dbms | qr100.L1 | qp100.L2 | qr500.L3 | qp500.L4 | qr1000.L5 | qp1000.L6 |
|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 1192 | 1192 | 5964 | 5964 | 11927 | 11927 |
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 1193 | 1193 | 5964 | 5960 | 11927 | 11927 |
| target | 1200 | 1200 | 6000 | 6000 | 12000 | 12000 |
l.i0
l.i0: load without secondary indexes. Graphs for performance per 1-second interval are here.
Average throughput:
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 0.285 | 99.664 | 0.050 | 0.001 | 0.242 | ||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 98.445 | 1.552 | 0.001 | 0.002 | 0.215 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 122449 0 0 0.0 3206.7 50.4 0.000 0.000 0.026 0.421 42023 6.4 0.343 17 8.0 108.8 9.9 0.242 10599 7199 ma120300_rel_withdbg.cz12b_sync_c32r128 442804 0 0 0.0 4455.2 175.4 0.000 0.000 0.010 0.406 95061 20.7 0.215 15 8.0 109.3 10.0 0.215 39895 37895 ma120300_rel_withdbg.cz12c_sync_c32r128
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 0.067 0.612 0.000 0.000 0.069 0.837 3206.7 51603.2 4195.8 56.72 0.450 16.08 21.68 1372.5 0.000 0.000 0.462 21.06 1043.4 0.445 1.920 96.59 ma120300_rel_withdbg.cz12b_sync_c32r128 0.100 1.600 0.000 0.000 0.002 0.296 4455.2 179603 3236.7 42.99 0.308 40.84 7.430 47.04 0.000 0.000 1.586 15.79 816.8 0.440 1.724 82.09 ma120300_rel_withdbg.cz12c_sync_c32r128
l.x
l.x: create secondary indexes.
Average throughput:
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 1846155 0 0 0.0 13242.5 1270.4 0.000 0.000 0.007 0.705 19670 31.1 0.011 5 16.9 117.7 17.9 0.017 NA NA ma120300_rel_withdbg.cz12b_sync_c32r128 1846155 0 0 0.0 12747.8 1262.5 0.000 0.000 0.007 0.700 17368 30.9 0.009 5 16.9 118.2 17.9 0.008 NA NA ma120300_rel_withdbg.cz12c_sync_c32r128
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 0.308 37.23 0.000 0.000 0.014 19.85 13242.5 1300891 406.8 2.833 0.201 88.74 24.58 159225 0.000 0.000 1.273 4138.0 82.82 0.614 3.100 38.88 ma120300_rel_withdbg.cz12b_sync_c32r128 0.277 32.62 0.000 0.000 0.009 10.75 12747.8 1292850 388.1 2.852 0.232 94.67 21.58 152294 0.000 0.000 1.277 4671.5 83.52 0.632 3.571 37.60 ma120300_rel_withdbg.cz12c_sync_c32r128
l.i1
l.i1: continue load after secondary indexes created with 50 inserts per transaction. Graphs for performance per 1-second interval are here.
Average throughput:
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 0.007 | 94.710 | 5.264 | 0.017 | 0.002 | 0.661 | |||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 84.740 | 14.809 | 0.446 | 0.005 | 0.239 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 0.063 | 95.126 | 4.795 | 0.014 | 0.002 | 0.874 | |||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 88.063 | 11.552 | 0.381 | 0.004 | 0.239 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 63054 0 0 0.0 9010.2 240.8 0.000 0.000 0.143 3.910 80361 17.5 1.274 89 22.3 123.1 24.0 0.661 5849 2000 ma120300_rel_withdbg.cz12b_sync_c32r128 171735 0 0 0.0 13068.4 473.6 0.000 0.000 0.076 2.824 141148 50.3 0.822 94 26.2 128.6 29.1 0.239 15648 5149 ma120300_rel_withdbg.cz12c_sync_c32r128
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 0.024 0.095 0.000 0.000 0.050 0.440 9010.2 246567 3147.8 26.14 0.698 27.27 77.56 1469.7 0.000 0.000 0.936 10.71 1526.8 0.647 6.871 97.14 ma120300_rel_withdbg.cz12b_sync_c32r128 0.001 0.004 0.000 0.000 0.004 0.018 13068.4 484939 722.2 5.233 0.273 37.25 1.361 45.64 0.000 0.000 1.740 33.55 1546.5 0.455 4.287 75.92 ma120300_rel_withdbg.cz12c_sync_c32r128
l.i2
l.i2: continue load after secondary indexes created with 5 inserts per transaction. Graphs for performance per 1-second interval are here.
Average throughput:
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 0.224 | 99.015 | 0.757 | 0.004 | 0.169 | ||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 1.137 | 98.031 | 0.822 | 0.010 | 0.056 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 0.163 | 99.072 | 0.761 | 0.004 | 0.169 | ||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 1.086 | 98.101 | 0.804 | 0.009 | 0.056 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 10690 0 0 0.0 4734.3 52.4 0.000 0.000 0.443 5.023 87304 7.3 8.167 219 22.3 123.1 24.0 0.169 945 300 ma120300_rel_withdbg.cz12b_sync_c32r128 38710 0 0 0.0 6400.9 151.4 0.000 0.000 0.165 4.004 230850 22.8 5.964 188 26.2 128.6 29.1 0.056 3860 1310 ma120300_rel_withdbg.cz12c_sync_c32r128
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 0.006 0.023 0.000 0.000 0.008 0.116 4734.3 53702.3 2645.6 35.94 0.509 11.24 0.019 0.094 0.000 0.000 0.164 0.450 1753.4 0.571 3.329 98.04 ma120300_rel_withdbg.cz12b_sync_c32r128 0.002 0.010 0.000 0.000 0.000 0.048 6400.9 155007 39.75 0.419 0.459 23.69 0.660 2.652 0.000 0.000 1.830 3.222 1571.6 0.742 3.254 89.73 ma120300_rel_withdbg.cz12c_sync_c32r128
qr100.L1
qr100.L1: range queries with 100 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 99.993 | 0.007 | nonzero | 0.004 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 99.993 | 0.007 | nonzero | 0.003 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 0.134 | 99.769 | 0.083 | 0.014 | 0.074 | ||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 94.012 | 5.743 | 0.245 | 0.059 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 0.692 | 99.218 | 0.076 | 0.014 | 0.076 | ||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 95.178 | 4.583 | 0.238 | 0.057 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 1192 90926 0 0.0 95.6 1.8 0.000 0.000 0.080 1.547 521899 38.9 5.740 137 22.3 123.1 24.0 0.004 7631 7567 ma120300_rel_withdbg.cz12b_sync_c32r128 1193 90487 0 0.0 59.5 1.6 0.000 0.000 0.050 1.372 518793 38.9 5.733 138 26.2 128.6 29.1 0.003 7487 7423 ma120300_rel_withdbg.cz12c_sync_c32r128
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 0.000 0.000 0.000 0.000 0.000 0.000 95.62 1843.8 76.63 44.38 0.536 19.55 0.215 1.339 0.000 0.000 0.041 0.221 39.86 0.510 0.071 2.605 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 0.000 0.000 0.000 0.000 59.55 1636.3 3.073 5.072 0.504 28.08 0.001 0.002 0.000 0.000 0.003 0.011 26.41 0.512 0.041 1.711 ma120300_rel_withdbg.cz12c_sync_c32r128
qp100.L2
qp100.L2: point queries with 100 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 99.991 | 0.009 | nonzero | 0.001 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 99.990 | 0.010 | nonzero | 0.003 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 4.380 | 95.551 | 0.067 | 0.002 | 0.065 | ||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 92.002 | 7.359 | 0.639 | 0.059 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 7.667 | 92.264 | 0.067 | 0.002 | 0.064 | ||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 92.734 | 6.646 | 0.620 | 0.059 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 1192 84875 0 0.0 149.5 2.1 0.000 0.000 0.125 1.799 492472 38.5 5.802 145 22.3 123.1 24.0 0.001 7119 7055 ma120300_rel_withdbg.cz12b_sync_c32r128 1193 84249 0 0.0 60.1 1.6 0.000 0.000 0.050 1.369 487951 38.9 5.792 148 26.2 128.6 29.1 0.003 7055 6975 ma120300_rel_withdbg.cz12c_sync_c32r128
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 0.000 0.000 0.000 0.000 0.000 0.000 149.5 2144.2 121.6 44.81 0.471 14.54 0.004 0.015 0.000 0.000 0.039 0.077 63.39 0.500 0.102 3.982 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 0.000 0.000 0.000 0.000 60.08 1632.3 3.145 5.113 0.526 27.73 0.003 0.011 0.000 0.000 0.033 0.055 26.50 0.537 0.042 1.744 ma120300_rel_withdbg.cz12c_sync_c32r128
qr500.L3
qr500.L3: range queries with 500 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 99.977 | 0.023 | nonzero | nonzero | nonzero | 0.027 | |||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 99.980 | 0.020 | nonzero | nonzero | 0.011 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 0.599 | 98.896 | 0.506 | 0.054 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 95.250 | 4.047 | 0.697 | 0.006 | 0.074 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 0.783 | 98.745 | 0.472 | 0.058 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 95.558 | 3.772 | 0.665 | 0.005 | 0.073 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 5964 89597 0 0.0 754.8 17.8 0.000 0.000 0.127 3.055 518170 39.9 5.783 143 22.3 123.1 24.0 0.027 7503 7391 ma120300_rel_withdbg.cz12b_sync_c32r128 5964 89501 0 0.0 553.2 17.0 0.000 0.000 0.093 2.926 515821 39.9 5.763 143 26.2 128.6 29.1 0.011 7551 7439 ma120300_rel_withdbg.cz12c_sync_c32r128
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 0.001 0.004 0.000 0.000 0.006 0.022 754.8 18220.6 313.5 41.49 0.551 23.11 6.765 78.20 0.000 0.000 0.235 2.041 172.0 0.516 0.397 10.95 ma120300_rel_withdbg.cz12b_sync_c32r128 0.001 0.002 0.000 0.000 0.000 0.011 553.2 17452.1 4.061 1.820 0.512 41.78 0.263 1.061 0.000 0.000 0.414 1.105 88.54 0.494 0.178 5.002 ma120300_rel_withdbg.cz12c_sync_c32r128
qp500.L4
qp500.L4: point queries with 500 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 99.970 | 0.029 | nonzero | nonzero | 0.007 | ||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 99.976 | 0.024 | nonzero | nonzero | 0.008 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 0.429 | 98.972 | 0.599 | 0.062 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 93.888 | 5.132 | 0.957 | 0.023 | 0.098 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 0.421 | 99.031 | 0.549 | 0.062 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 94.339 | 4.715 | 0.926 | 0.019 | 0.079 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 5964 83986 0 0.0 725.6 17.6 0.000 0.000 0.122 3.020 491189 39.9 5.848 152 22.3 123.1 24.0 0.007 7039 6927 ma120300_rel_withdbg.cz12b_sync_c32r128 5960 83615 0 0.0 566.5 17.2 0.000 0.000 0.095 2.955 487242 39.9 5.827 153 26.2 128.6 29.1 0.008 6975 6879 ma120300_rel_withdbg.cz12c_sync_c32r128
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 0.001 0.002 0.000 0.000 0.000 0.011 725.6 18008.3 261.9 38.26 0.525 24.78 2.806 44.05 0.000 0.000 0.246 2.916 160.2 0.505 0.355 9.592 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 0.000 0.000 0.000 0.000 566.5 17609.6 4.439 1.807 0.515 41.19 0.264 9.173 0.000 0.000 0.512 9.195 92.00 0.515 0.196 5.173 ma120300_rel_withdbg.cz12c_sync_c32r128
qr1000.L5
qr1000.L5: range queries with 1000 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 99.942 | 0.057 | 0.001 | nonzero | nonzero | nonzero | 0.074 | ||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 99.948 | 0.051 | 0.001 | 0.001 | nonzero | nonzero | 0.117 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 0.395 | 98.513 | 1.085 | 0.007 | 0.097 | ||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 95.317 | 3.763 | 0.915 | 0.005 | 0.134 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 0.387 | 98.653 | 0.955 | 0.005 | 0.092 | ||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 95.969 | 3.151 | 0.875 | 0.005 | 0.134 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 11927 88403 0 0.0 1460.4 35.4 0.000 0.000 0.122 3.036 515193 41.8 5.828 151 22.3 123.1 24.0 0.074 7407 7231 ma120300_rel_withdbg.cz12b_sync_c32r128 11927 88449 0 0.0 1434.5 42.1 0.000 0.000 0.120 3.616 513610 41.8 5.807 151 26.2 128.6 29.1 0.117 7407 7263 ma120300_rel_withdbg.cz12c_sync_c32r128
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 0.003 0.011 0.000 0.000 0.006 0.055 1460.4 36207.1 526.7 35.93 0.547 24.76 8.161 447.4 0.000 0.000 0.471 8.233 322.4 0.519 0.829 19.41 ma120300_rel_withdbg.cz12b_sync_c32r128 0.001 0.002 0.000 0.000 0.003 0.011 1434.5 43133.6 6.216 0.888 0.459 37.33 0.631 23.77 0.000 0.000 1.450 24.99 203.5 0.506 0.485 10.67 ma120300_rel_withdbg.cz12c_sync_c32r128
qp1000.L6
qp1000.L6: point queries with 1000 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 99.926 | 0.073 | 0.001 | nonzero | nonzero | 0.035 | |||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 99.939 | 0.060 | 0.001 | nonzero | nonzero | 0.017 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 0.183 | 98.629 | 1.184 | 0.005 | 0.099 | ||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 93.481 | 5.230 | 1.273 | 0.015 | 0.182 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ma120300_rel_withdbg.cz12b_sync_c32r128 | 0.200 | 98.790 | 1.007 | 0.004 | 0.099 | ||||||
| ma120300_rel_withdbg.cz12c_sync_c32r128 | 94.200 | 4.554 | 1.235 | 0.011 | 0.218 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 11927 82451 0 0.0 1420.4 35.2 0.000 0.000 0.119 3.021 487149 41.5 5.908 161 22.3 123.1 24.0 0.035 6895 6783 ma120300_rel_withdbg.cz12b_sync_c32r128 11927 82584 0 0.0 1160.6 35.3 0.000 0.000 0.097 3.030 484289 41.7 5.864 162 26.2 128.6 29.1 0.017 6927 6815 ma120300_rel_withdbg.cz12c_sync_c32r128
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 0.004 0.015 0.000 0.000 0.004 0.066 1420.4 36037.6 502.6 34.85 0.547 25.84 11.56 1748.9 0.000 0.000 0.459 55.02 303.4 0.522 0.793 18.20 ma120300_rel_withdbg.cz12b_sync_c32r128 0.001 0.002 0.000 0.000 0.000 0.011 1160.6 36141.6 5.826 0.875 0.473 37.69 0.594 20.95 0.000 0.000 1.482 22.00 182.8 0.526 0.504 10.30 ma120300_rel_withdbg.cz12c_sync_c32r128
l.i0
l.i0: load without secondary indexes
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 122449 0 0 0.0 3206.7 50.4 0.000 0.000 0.026 0.421 42023 6.4 0.343 17 8.0 108.8 9.9 0.242 10599 7199 ma120300_rel_withdbg.cz12b_sync_c32r128 442804 0 0 0.0 4455.2 175.4 0.000 0.000 0.010 0.406 95061 20.7 0.215 15 8.0 109.3 10.0 0.215 39895 37895 ma120300_rel_withdbg.cz12c_sync_c32r128
l.x
l.x: create secondary indexes
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 1846155 0 0 0.0 13242.5 1270.4 0.000 0.000 0.007 0.705 19670 31.1 0.011 5 16.9 117.7 17.9 0.017 NA NA ma120300_rel_withdbg.cz12b_sync_c32r128 1846155 0 0 0.0 12747.8 1262.5 0.000 0.000 0.007 0.700 17368 30.9 0.009 5 16.9 118.2 17.9 0.008 NA NA ma120300_rel_withdbg.cz12c_sync_c32r128
l.i1
l.i1: continue load after secondary indexes created with 50 inserts per transaction
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 63054 0 0 0.0 9010.2 240.8 0.000 0.000 0.143 3.910 80361 17.5 1.274 89 22.3 123.1 24.0 0.661 5849 2000 ma120300_rel_withdbg.cz12b_sync_c32r128 171735 0 0 0.0 13068.4 473.6 0.000 0.000 0.076 2.824 141148 50.3 0.822 94 26.2 128.6 29.1 0.239 15648 5149 ma120300_rel_withdbg.cz12c_sync_c32r128
l.i2
l.i2: continue load after secondary indexes created with 5 inserts per transaction
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 10690 0 0 0.0 4734.3 52.4 0.000 0.000 0.443 5.023 87304 7.3 8.167 219 22.3 123.1 24.0 0.169 945 300 ma120300_rel_withdbg.cz12b_sync_c32r128 38710 0 0 0.0 6400.9 151.4 0.000 0.000 0.165 4.004 230850 22.8 5.964 188 26.2 128.6 29.1 0.056 3860 1310 ma120300_rel_withdbg.cz12c_sync_c32r128
qr100.L1
qr100.L1: range queries with 100 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 1192 90926 0 0.0 95.6 1.8 0.000 0.000 0.080 1.547 521899 38.9 5.740 137 22.3 123.1 24.0 0.004 7631 7567 ma120300_rel_withdbg.cz12b_sync_c32r128 1193 90487 0 0.0 59.5 1.6 0.000 0.000 0.050 1.372 518793 38.9 5.733 138 26.2 128.6 29.1 0.003 7487 7423 ma120300_rel_withdbg.cz12c_sync_c32r128
qp100.L2
qp100.L2: point queries with 100 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 1192 84875 0 0.0 149.5 2.1 0.000 0.000 0.125 1.799 492472 38.5 5.802 145 22.3 123.1 24.0 0.001 7119 7055 ma120300_rel_withdbg.cz12b_sync_c32r128 1193 84249 0 0.0 60.1 1.6 0.000 0.000 0.050 1.369 487951 38.9 5.792 148 26.2 128.6 29.1 0.003 7055 6975 ma120300_rel_withdbg.cz12c_sync_c32r128
qr500.L3
qr500.L3: range queries with 500 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 5964 89597 0 0.0 754.8 17.8 0.000 0.000 0.127 3.055 518170 39.9 5.783 143 22.3 123.1 24.0 0.027 7503 7391 ma120300_rel_withdbg.cz12b_sync_c32r128 5964 89501 0 0.0 553.2 17.0 0.000 0.000 0.093 2.926 515821 39.9 5.763 143 26.2 128.6 29.1 0.011 7551 7439 ma120300_rel_withdbg.cz12c_sync_c32r128
qp500.L4
qp500.L4: point queries with 500 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 5964 83986 0 0.0 725.6 17.6 0.000 0.000 0.122 3.020 491189 39.9 5.848 152 22.3 123.1 24.0 0.007 7039 6927 ma120300_rel_withdbg.cz12b_sync_c32r128 5960 83615 0 0.0 566.5 17.2 0.000 0.000 0.095 2.955 487242 39.9 5.827 153 26.2 128.6 29.1 0.008 6975 6879 ma120300_rel_withdbg.cz12c_sync_c32r128
qr1000.L5
qr1000.L5: range queries with 1000 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 11927 88403 0 0.0 1460.4 35.4 0.000 0.000 0.122 3.036 515193 41.8 5.828 151 22.3 123.1 24.0 0.074 7407 7231 ma120300_rel_withdbg.cz12b_sync_c32r128 11927 88449 0 0.0 1434.5 42.1 0.000 0.000 0.120 3.616 513610 41.8 5.807 151 26.2 128.6 29.1 0.117 7407 7263 ma120300_rel_withdbg.cz12c_sync_c32r128
qp1000.L6
qp1000.L6: point queries with 1000 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 11927 82451 0 0.0 1420.4 35.2 0.000 0.000 0.119 3.021 487149 41.5 5.908 161 22.3 123.1 24.0 0.035 6895 6783 ma120300_rel_withdbg.cz12b_sync_c32r128 11927 82584 0 0.0 1160.6 35.3 0.000 0.000 0.097 3.030 484289 41.7 5.864 162 26.2 128.6 29.1 0.017 6927 6815 ma120300_rel_withdbg.cz12c_sync_c32r128
l.i0
- l.i0: load without secondary indexes
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.285 99.664 0.050 0.001 0.000 0.000 0.000 0.000 0.242 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 98.445 1.552 0.001 0.002 0.000 0.000 0.000 0.000 0.215 ma120300_rel_withdbg.cz12c_sync_c32r128
l.x
- l.x: create secondary indexes
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
TODO - determine whether there is data for create index response time
l.i1
- l.i1: continue load after secondary indexes created with 50 inserts per transaction
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.007 94.710 5.264 0.017 0.002 0.000 0.000 0.000 0.661 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 84.740 14.809 0.446 0.005 0.000 0.000 0.000 0.000 0.239 ma120300_rel_withdbg.cz12c_sync_c32r128
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.063 95.126 4.795 0.014 0.002 0.000 0.000 0.000 0.874 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 88.063 11.552 0.381 0.004 0.000 0.000 0.000 0.000 0.239 ma120300_rel_withdbg.cz12c_sync_c32r128
l.i2
- l.i2: continue load after secondary indexes created with 5 inserts per transaction
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.224 99.015 0.757 0.004 0.000 0.000 0.000 0.000 0.169 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 1.137 98.031 0.822 0.010 0.000 0.000 0.000 0.000 0.000 0.056 ma120300_rel_withdbg.cz12c_sync_c32r128
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.163 99.072 0.761 0.004 0.000 0.000 0.000 0.000 0.169 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 1.086 98.101 0.804 0.009 0.000 0.000 0.000 0.000 0.000 0.056 ma120300_rel_withdbg.cz12c_sync_c32r128
qr100.L1
- qr100.L1: range queries with 100 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 99.993 0.007 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 ma120300_rel_withdbg.cz12b_sync_c32r128 99.993 0.007 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 ma120300_rel_withdbg.cz12c_sync_c32r128
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.134 99.769 0.083 0.014 0.000 0.000 0.000 0.000 0.074 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 94.012 5.743 0.245 0.000 0.000 0.000 0.000 0.000 0.059 ma120300_rel_withdbg.cz12c_sync_c32r128
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.692 99.218 0.076 0.014 0.000 0.000 0.000 0.000 0.076 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 95.178 4.583 0.238 0.000 0.000 0.000 0.000 0.000 0.057 ma120300_rel_withdbg.cz12c_sync_c32r128
qp100.L2
- qp100.L2: point queries with 100 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 99.991 0.009 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.001 ma120300_rel_withdbg.cz12b_sync_c32r128 99.990 0.010 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 ma120300_rel_withdbg.cz12c_sync_c32r128
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 4.380 95.551 0.067 0.002 0.000 0.000 0.000 0.000 0.065 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 92.002 7.359 0.639 0.000 0.000 0.000 0.000 0.000 0.059 ma120300_rel_withdbg.cz12c_sync_c32r128
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 7.667 92.264 0.067 0.002 0.000 0.000 0.000 0.000 0.064 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 92.734 6.646 0.620 0.000 0.000 0.000 0.000 0.000 0.059 ma120300_rel_withdbg.cz12c_sync_c32r128
qr500.L3
- qr500.L3: range queries with 500 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 99.977 0.023 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.027 ma120300_rel_withdbg.cz12b_sync_c32r128 99.980 0.020 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.011 ma120300_rel_withdbg.cz12c_sync_c32r128
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.599 98.896 0.506 0.000 0.000 0.000 0.000 0.000 0.054 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 95.250 4.047 0.697 0.006 0.000 0.000 0.000 0.000 0.074 ma120300_rel_withdbg.cz12c_sync_c32r128
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.783 98.745 0.472 0.000 0.000 0.000 0.000 0.000 0.058 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 95.558 3.772 0.665 0.005 0.000 0.000 0.000 0.000 0.073 ma120300_rel_withdbg.cz12c_sync_c32r128
qp500.L4
- qp500.L4: point queries with 500 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 99.970 0.029 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.007 ma120300_rel_withdbg.cz12b_sync_c32r128 99.976 0.024 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.008 ma120300_rel_withdbg.cz12c_sync_c32r128
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.429 98.972 0.599 0.000 0.000 0.000 0.000 0.000 0.062 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 93.888 5.132 0.957 0.023 0.000 0.000 0.000 0.000 0.098 ma120300_rel_withdbg.cz12c_sync_c32r128
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.421 99.031 0.549 0.000 0.000 0.000 0.000 0.000 0.062 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 94.339 4.715 0.926 0.019 0.000 0.000 0.000 0.000 0.079 ma120300_rel_withdbg.cz12c_sync_c32r128
qr1000.L5
- qr1000.L5: range queries with 1000 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 99.942 0.057 0.001 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.074 ma120300_rel_withdbg.cz12b_sync_c32r128 99.948 0.051 0.001 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.117 ma120300_rel_withdbg.cz12c_sync_c32r128
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.395 98.513 1.085 0.007 0.000 0.000 0.000 0.000 0.097 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 95.317 3.763 0.915 0.005 0.000 0.000 0.000 0.000 0.134 ma120300_rel_withdbg.cz12c_sync_c32r128
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.387 98.653 0.955 0.005 0.000 0.000 0.000 0.000 0.092 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 95.969 3.151 0.875 0.005 0.000 0.000 0.000 0.000 0.134 ma120300_rel_withdbg.cz12c_sync_c32r128
qp1000.L6
- qp1000.L6: point queries with 1000 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 99.926 0.073 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.035 ma120300_rel_withdbg.cz12b_sync_c32r128 99.939 0.060 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.017 ma120300_rel_withdbg.cz12c_sync_c32r128
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.183 98.629 1.184 0.005 0.000 0.000 0.000 0.000 0.099 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 93.481 5.230 1.273 0.015 0.000 0.000 0.000 0.000 0.182 ma120300_rel_withdbg.cz12c_sync_c32r128
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.200 98.790 1.007 0.004 0.000 0.000 0.000 0.000 0.099 ma120300_rel_withdbg.cz12b_sync_c32r128 0.000 0.000 94.200 4.554 1.235 0.011 0.000 0.000 0.000 0.000 0.218 ma120300_rel_withdbg.cz12c_sync_c32r128