Introduction
This is a report for the insert benchmark with 30M docs and 1 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 8 AMD cores, 32G RAM and an NVMe device for the database. The benchmark was run with 1 client 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 1 table with a table per client. It loads 30M rows per table without secondary indexes, creates 3 secondary indexes per table, then inserts 40m+10m 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 by InnoDB. Clients and the DBMS share one server.
The tested DBMS are:
- ma120300_rel_withdbg.cz12b_c8r32 - MariaDB 12.3.0 with the z12b_c8r32 config
- ma120300_rel_withdbg.cz12c_c8r32 - MariaDB 12.3.0 with the z12c_c8r32 config that uses the binlog storage engine
- ma120300_rel_withdbg.cz12b_sync_c8r32 - MariaDB 12.3.0 with the z12b_c8r32 config that syncs InnoDB and the binlog on commit
- ma120300_rel_withdbg.cz12c_sync_c8r32 - MariaDB 12.3.0 with the z12c_c8r32 config that uses the binlog storage engine and syncs InnoDB on commit
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_c8r32 | 162162 | 187501 | 40080 | 27322 | 9096 | 8460 | 9114 | 8411 | 9091 | 8415 |
| ma120300_rel_withdbg.cz12c_c8r32 | 166667 | 188680 | 40161 | 28248 | 9113 | 8377 | 9115 | 8404 | 9143 | 8373 |
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 7036 | 191083 | 2777 | 254 | 9145 | 8528 | 9119 | 8486 | 9049 | 8438 |
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 12290 | 193549 | 11071 | 1735 | 9266 | 8573 | 9218 | 8550 | 9313 | 8501 |
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_c8r32 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| ma120300_rel_withdbg.cz12c_c8r32 | 1.03 | 1.01 | 1.00 | 1.03 | 1.00 | 0.99 | 1.00 | 1.00 | 1.01 | 1.00 |
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 0.04 | 1.02 | 0.07 | 0.01 | 1.01 | 1.01 | 1.00 | 1.01 | 1.00 | 1.00 |
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 0.08 | 1.03 | 0.28 | 0.06 | 1.02 | 1.01 | 1.01 | 1.02 | 1.02 | 1.01 |
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_c8r32 | 100 | 100 | 500 | 500 | 999 | 999 |
| ma120300_rel_withdbg.cz12c_c8r32 | 100 | 100 | 500 | 500 | 1000 | 999 |
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 100 | 100 | 500 | 500 | 999 | 999 |
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 100 | 100 | 500 | 500 | 1000 | 999 |
| target | 100 | 100 | 500 | 500 | 1000 | 1000 |
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_c8r32 | 99.669 | 0.142 | 0.047 | 0.138 | 0.004 | 0.188 | |||||
| ma120300_rel_withdbg.cz12c_c8r32 | 99.667 | 0.140 | 0.080 | 0.112 | 0.001 | 0.215 | |||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 85.577 | 14.423 | 0.001 | 0.225 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 0.004 | 99.766 | 0.229 | nonzero | 0.074 |
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 162162 0 0 0.0 272.7 31.6 0.000 0.000 0.002 0.200 21116 19.8 0.130 10 2.0 32.8 2.5 0.188 164173 132774 ma120300_rel_withdbg.cz12b_c8r32 166667 0 0 0.0 831.5 57.8 0.000 0.000 0.005 0.355 24485 20.0 0.147 10 2.0 33.3 2.6 0.215 167869 136176 ma120300_rel_withdbg.cz12c_c8r32 7036 0 0 0.0 567.8 5.1 0.000 0.000 0.081 0.737 3898 2.9 0.554 33 2.0 32.8 2.6 0.225 7299 5998 ma120300_rel_withdbg.cz12b_sync_c8r32 12290 0 0 0.0 534.0 9.1 0.000 0.000 0.043 0.758 5168 4.3 0.421 28 2.0 33.3 2.6 0.074 12398 10298 ma120300_rel_withdbg.cz12c_sync_c8r32
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.228 0.911 0.000 0.000 4.588 2.556 276.2 32934.0 21.09 9.423 6.702 117.2 0.450 3.862 0.000 0.000 0.421 2.458 6.855 2.131 1.944 7.245 ma120300_rel_withdbg.cz12b_c8r32 0.229 0.915 0.000 0.000 2.474 2.743 844.4 59695.2 25.69 3.750 3.439 89.40 0.417 3.179 0.000 0.000 0.469 5.101 9.131 1.725 2.261 7.983 ma120300_rel_withdbg.cz12c_c8r32 0.010 0.040 0.000 0.000 0.006 0.197 567.9 5183.7 568.7 50.07 1.467 9.105 2.516 19.05 0.000 0.000 0.050 0.615 211.5 1.344 1.109 82.35 ma120300_rel_withdbg.cz12b_sync_c8r32 0.017 0.067 0.000 0.000 0.006 0.222 534.0 9311.6 646.1 55.25 1.642 17.49 18.32 145.7 0.000 0.000 0.376 3.178 163.3 1.267 1.070 81.36 ma120300_rel_withdbg.cz12c_sync_c8r32
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 187501 0 0 0.0 2509.1 166.9 0.000 0.000 0.013 0.912 7683 12.2 0.041 5 4.2 35.0 4.1 0.001 NA NA ma120300_rel_withdbg.cz12b_c8r32 188680 0 0 0.0 2109.7 162.7 0.000 0.000 0.011 0.883 5306 12.0 0.028 5 4.2 35.5 4.2 0.001 NA NA ma120300_rel_withdbg.cz12c_c8r32 191083 0 0 0.0 2514.9 169.8 0.000 0.000 0.013 0.910 7390 12.2 0.039 5 4.2 35.0 4.3 0.019 NA NA ma120300_rel_withdbg.cz12b_sync_c8r32 193549 0 0 0.0 2076.0 164.6 0.000 0.000 0.011 0.871 5123 12.1 0.026 5 4.2 35.5 4.5 0.008 NA NA ma120300_rel_withdbg.cz12c_sync_c8r32
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.187 0.748 0.000 0.000 0.043 1.677 2452.4 173333 19.72 1.635 0.173 99.29 1.348 10078.3 0.000 0.000 0.051 786.0 8.335 1.561 0.256 7.223 ma120300_rel_withdbg.cz12b_c8r32 0.173 0.693 0.000 0.000 0.040 1.733 2104.4 170002 17.01 1.487 0.177 107.5 1.093 8439.1 0.000 0.000 0.043 642.3 8.371 1.533 0.280 6.571 ma120300_rel_withdbg.cz12c_c8r32 0.013 0.053 0.000 0.000 0.000 0.267 2456.3 176456 20.01 1.673 0.142 100.8 1.086 8198.2 0.000 0.000 0.028 516.4 8.406 1.205 0.208 6.646 ma120300_rel_withdbg.cz12b_sync_c8r32 0.187 0.746 0.000 0.000 0.061 1.733 2068.8 171898 19.97 1.768 0.192 108.9 1.709 17176.8 0.000 0.000 0.042 1010.2 9.012 0.964 0.283 6.324 ma120300_rel_withdbg.cz12c_sync_c8r32
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_c8r32 | 38.517 | 60.059 | 1.193 | 0.226 | 0.004 | nonzero | 0.270 | ||||
| ma120300_rel_withdbg.cz12c_c8r32 | 42.867 | 55.567 | 1.330 | 0.233 | 0.004 | 0.169 | |||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 50.492 | 49.488 | 0.020 | 0.244 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 73.114 | 26.504 | 0.381 | 0.001 | 0.245 |
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_c8r32 | 87.092 | 11.744 | 0.966 | 0.196 | 0.003 | nonzero | 0.270 | ||||
| ma120300_rel_withdbg.cz12c_c8r32 | 87.316 | 11.399 | 1.079 | 0.203 | 0.003 | 0.168 | |||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 50.033 | 49.947 | 0.020 | 0.227 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 73.084 | 26.651 | 0.264 | 0.001 | 0.224 |
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 40080 0 0 0.0 3632.5 134.2 0.000 0.000 0.091 3.430 32308 31.5 0.806 63 5.9 36.7 6.5 0.270 41045 13598 ma120300_rel_withdbg.cz12b_c8r32 40161 0 0 0.0 4083.0 151.1 0.000 0.000 0.102 3.852 33806 31.8 0.842 63 5.8 37.1 6.4 0.169 41195 14947 ma120300_rel_withdbg.cz12c_c8r32 2777 0 0 0.0 1043.0 14.0 0.000 0.000 0.376 5.168 5695 4.0 2.051 115 5.3 36.1 5.9 0.244 2750 1700 ma120300_rel_withdbg.cz12b_sync_c8r32 11071 0 0 0.0 2022.6 45.5 0.000 0.000 0.183 4.212 12271 10.5 1.108 76 5.7 37.0 6.3 0.245 12348 3749 ma120300_rel_withdbg.cz12c_sync_c8r32
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.059 0.234 0.000 0.000 0.191 0.747 3636.6 137533 47.81 1.237 0.878 38.59 0.279 37.68 0.000 0.000 0.278 16.54 47.25 1.599 3.180 16.64 ma120300_rel_withdbg.cz12b_c8r32 0.062 0.246 0.000 0.000 0.206 0.626 4090.0 154922 50.15 1.163 0.881 39.20 0.371 36.97 0.000 0.000 0.493 19.46 54.42 1.584 3.538 18.67 ma120300_rel_withdbg.cz12c_c8r32 0.004 0.016 0.000 0.000 0.015 0.074 1042.3 14335.5 689.2 41.63 1.617 12.85 0.007 0.030 0.000 0.000 0.031 0.146 335.5 1.939 2.294 97.06 ma120300_rel_withdbg.cz12b_sync_c8r32 0.017 0.068 0.000 0.000 0.031 0.183 2021.6 46589.8 285.5 18.00 0.933 23.56 0.264 1.080 0.000 0.000 0.215 1.072 456.4 1.302 2.111 92.45 ma120300_rel_withdbg.cz12c_sync_c8r32
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_c8r32 | 98.378 | 1.515 | 0.040 | 0.063 | 0.003 | nonzero | 0.067 | ||||
| ma120300_rel_withdbg.cz12c_c8r32 | 98.728 | 1.155 | 0.042 | 0.072 | 0.003 | 0.041 | |||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 26.537 | 73.462 | 0.001 | 0.079 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 89.759 | 10.238 | 0.003 | 0.033 |
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_c8r32 | 99.197 | 0.711 | 0.034 | 0.056 | 0.003 | nonzero | 0.067 | ||||
| ma120300_rel_withdbg.cz12c_c8r32 | 99.333 | 0.567 | 0.036 | 0.061 | 0.002 | 0.040 | |||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 26.532 | 73.466 | 0.002 | 0.108 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | nonzero | 89.717 | 10.280 | 0.003 | 0.037 |
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 27322 0 0 0.0 2025.5 76.3 0.000 0.000 0.074 2.861 126000 32.5 4.612 95 5.9 36.7 6.5 0.067 28112 23622 ma120300_rel_withdbg.cz12b_c8r32 28248 0 0 0.0 2503.4 95.4 0.000 0.000 0.089 3.458 131305 33.2 4.648 94 5.8 37.1 6.4 0.041 29352 23273 ma120300_rel_withdbg.cz12c_c8r32 254 0 0 0.0 736.1 3.9 0.000 0.000 2.896 15.702 3972 1.8 15.626 566 5.3 36.1 5.9 0.079 240 175 ma120300_rel_withdbg.cz12b_sync_c8r32 1735 0 0 0.0 1526.2 8.6 0.000 0.000 0.880 5.049 12507 4.0 7.209 184 5.7 37.0 6.3 0.033 1920 1160 ma120300_rel_withdbg.cz12c_sync_c8r32
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.031 0.122 0.000 0.000 0.007 0.278 2020.0 78134.8 6.628 0.335 0.996 39.31 0.247 4.722 0.000 0.000 0.207 2.706 28.04 1.653 1.944 8.265 ma120300_rel_withdbg.cz12b_c8r32 0.052 0.209 0.000 0.000 0.019 0.522 2534.8 98509.5 10.61 0.424 1.072 39.76 0.461 2.029 0.000 0.000 0.401 2.520 35.95 1.556 2.577 10.09 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.002 0.000 0.000 0.005 0.008 736.1 3991.4 269.2 27.15 2.534 4.968 0.001 0.146 0.000 0.000 0.001 0.382 305.8 3.167 2.748 98.49 ma120300_rel_withdbg.cz12b_sync_c8r32 0.003 0.012 0.000 0.000 0.008 0.028 1524.7 8728.9 9.880 0.682 0.749 5.204 0.964 4.001 0.000 0.000 0.395 1.893 698.6 1.405 2.083 96.45 ma120300_rel_withdbg.cz12c_sync_c8r32
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_c8r32 | 99.964 | 0.036 | nonzero | nonzero | 0.007 | ||||||
| ma120300_rel_withdbg.cz12c_c8r32 | 99.963 | 0.037 | nonzero | 0.001 | |||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 99.977 | 0.023 | nonzero | nonzero | 0.007 | ||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 99.986 | 0.014 | 0.001 |
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_c8r32 | 7.972 | 83.111 | 8.889 | 0.028 | 0.026 | ||||||
| ma120300_rel_withdbg.cz12c_c8r32 | 12.139 | 87.833 | 0.028 | 0.008 | |||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 33.056 | 66.944 | 0.051 | ||||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 27.278 | 69.167 | 3.556 | 0.024 |
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_c8r32 | 42.639 | 48.500 | 8.861 | 0.015 | |||||||
| ma120300_rel_withdbg.cz12c_c8r32 | 59.639 | 40.333 | 0.028 | 0.007 | |||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 31.889 | 68.056 | 0.056 | 0.066 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 12.194 | 86.056 | 1.750 | 0.026 |
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 100 9096 0 0.0 9.1 0.3 0.000 0.000 0.092 2.968 52160 12.4 5.735 109 5.9 36.7 6.4 0.007 9102 9006 ma120300_rel_withdbg.cz12b_c8r32 100 9113 0 0.0 5.6 0.2 0.000 0.000 0.056 1.757 52238 12.4 5.732 109 5.8 37.1 6.4 0.001 9118 9023 ma120300_rel_withdbg.cz12c_c8r32 100 9145 0 0.0 34.7 0.4 0.000 0.000 0.348 4.417 52553 12.4 5.747 108 5.3 36.1 5.9 0.007 9151 9070 ma120300_rel_withdbg.cz12b_sync_c8r32 100 9266 0 0.0 11.2 0.2 0.000 0.000 0.112 1.877 53107 12.4 5.731 107 5.7 37.0 6.3 0.001 9246 9150 ma120300_rel_withdbg.cz12c_sync_c8r32
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 9.163 297.1 0.929 24.37 6.172 43.42 0.001 0.002 0.000 0.000 0.000 0.011 1.334 2.658 0.021 1.464 ma120300_rel_withdbg.cz12b_c8r32 0.000 0.000 0.000 0.000 0.000 0.000 5.592 175.5 3.944 41.44 4.430 31.47 0.000 0.000 0.000 0.000 0.000 0.000 1.993 2.132 0.029 2.154 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 0.000 0.000 0.000 34.77 441.9 21.13 42.52 2.041 9.404 0.001 0.002 0.000 0.000 0.003 0.011 12.16 2.041 0.084 4.342 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 0.000 0.000 0.000 0.000 11.19 187.7 3.955 26.12 2.695 16.77 0.001 0.002 0.000 0.000 0.003 0.011 5.027 1.946 0.041 1.908 ma120300_rel_withdbg.cz12c_sync_c8r32
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_c8r32 | 99.964 | 0.036 | nonzero | 0.001 | |||||||
| ma120300_rel_withdbg.cz12c_c8r32 | 99.962 | 0.038 | 0.001 | ||||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 99.981 | 0.019 | nonzero | 0.002 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 99.987 | 0.013 | nonzero | 0.001 |
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_c8r32 | 0.361 | 90.778 | 8.861 | 0.011 | |||||||
| ma120300_rel_withdbg.cz12c_c8r32 | 0.750 | 99.194 | 0.028 | 0.028 | 0.019 | ||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 31.611 | 68.389 | 0.056 | ||||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 13.806 | 70.944 | 15.250 | 0.033 |
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_c8r32 | 31.861 | 59.389 | 8.750 | 0.011 | |||||||
| ma120300_rel_withdbg.cz12c_c8r32 | 48.028 | 51.944 | 0.028 | 0.012 | |||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 28.861 | 71.111 | 0.028 | 0.065 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 7.861 | 86.778 | 5.361 | 0.022 |
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 100 8460 0 0.0 20.3 0.6 0.000 0.000 0.203 6.063 49044 11.9 5.797 113 5.9 36.7 6.4 0.001 8462 8383 ma120300_rel_withdbg.cz12b_c8r32 100 8377 0 0.0 22.9 0.6 0.000 0.000 0.229 6.575 48577 12.1 5.799 116 5.8 37.1 6.4 0.001 8382 8301 ma120300_rel_withdbg.cz12c_c8r32 100 8528 0 0.0 41.0 0.6 0.000 0.000 0.410 6.157 49512 12.2 5.806 114 5.3 36.1 5.9 0.002 8527 8431 ma120300_rel_withdbg.cz12b_sync_c8r32 100 8573 0 0.0 30.2 0.7 0.000 0.000 0.303 7.156 49731 12.1 5.801 113 5.7 37.0 6.3 0.001 8575 8479 ma120300_rel_withdbg.cz12c_sync_c8r32
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 15.46 471.8 0.902 23.10 6.136 42.78 0.006 0.025 0.000 0.000 0.025 0.123 1.367 2.603 0.022 1.478 ma120300_rel_withdbg.cz12b_c8r32 0.000 0.000 0.000 0.000 0.000 0.000 18.31 530.0 3.995 41.20 4.418 31.72 0.000 0.000 0.000 0.000 0.000 0.000 2.188 2.091 0.031 2.209 ma120300_rel_withdbg.cz12c_c8r32 0.001 0.004 0.000 0.000 0.003 0.011 41.09 616.8 21.19 42.44 2.058 9.447 0.001 0.002 0.000 0.000 0.003 0.011 12.21 2.070 0.085 4.391 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 0.000 0.000 0.000 0.000 23.90 539.8 3.933 25.62 2.992 16.83 0.000 0.000 0.000 0.000 0.000 0.000 5.224 2.169 0.046 2.150 ma120300_rel_withdbg.cz12c_sync_c8r32
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_c8r32 | 99.947 | 0.053 | nonzero | nonzero | nonzero | 0.017 | |||||
| ma120300_rel_withdbg.cz12c_c8r32 | 99.948 | 0.052 | nonzero | 0.001 | |||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 99.971 | 0.029 | nonzero | 0.002 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 99.976 | 0.024 | nonzero | 0.002 |
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_c8r32 | 51.672 | 46.528 | 1.789 | 0.011 | 0.019 | ||||||
| ma120300_rel_withdbg.cz12c_c8r32 | 59.689 | 40.311 | 0.003 | ||||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 53.389 | 46.611 | 0.064 | ||||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 72.106 | 27.700 | 0.194 | 0.021 |
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_c8r32 | 86.756 | 11.472 | 1.767 | 0.006 | 0.018 | ||||||
| ma120300_rel_withdbg.cz12c_c8r32 | 89.961 | 10.039 | 0.003 | ||||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 52.244 | 47.756 | 0.048 | ||||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 72.967 | 27.011 | 0.022 | 0.020 |
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 500 9114 0 0.0 62.2 2.0 0.000 0.000 0.124 4.188 52645 12.5 5.777 110 5.9 36.7 6.4 0.017 9118 8974 ma120300_rel_withdbg.cz12b_c8r32 500 9115 0 0.0 9.1 0.7 0.000 0.000 0.018 1.383 52397 12.4 5.748 109 5.8 37.1 6.4 0.001 9118 9053 ma120300_rel_withdbg.cz12c_c8r32 500 9119 0 0.0 147.6 1.5 0.000 0.000 0.295 2.976 53002 12.4 5.812 109 5.3 36.1 5.9 0.002 9119 9038 ma120300_rel_withdbg.cz12b_sync_c8r32 500 9218 0 0.0 51.7 0.9 0.000 0.000 0.103 1.860 53141 12.4 5.765 108 5.7 37.0 6.3 0.002 9215 9134 ma120300_rel_withdbg.cz12c_sync_c8r32
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 56.94 1947.1 0.686 7.661 7.182 85.10 0.001 0.004 0.000 0.000 0.006 0.022 1.884 2.215 0.054 1.566 ma120300_rel_withdbg.cz12b_c8r32 0.000 0.000 0.000 0.000 0.000 0.000 9.089 691.5 4.029 30.74 4.683 76.08 0.001 0.002 0.000 0.000 0.003 0.011 2.000 1.903 0.046 2.138 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 0.000 0.000 0.000 141.4 1313.4 105.6 42.76 1.922 9.291 0.002 0.009 0.000 0.000 0.008 0.045 60.02 2.278 0.409 16.72 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 0.000 0.000 0.000 0.000 46.63 789.1 6.583 12.20 1.277 16.92 0.001 0.002 0.000 0.000 0.000 0.011 21.87 1.374 0.090 3.998 ma120300_rel_withdbg.cz12c_sync_c8r32
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_c8r32 | 99.947 | 0.053 | nonzero | 0.002 | |||||||
| ma120300_rel_withdbg.cz12c_c8r32 | 99.943 | 0.057 | nonzero | 0.002 | |||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 99.974 | 0.026 | nonzero | 0.002 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 99.978 | 0.022 | nonzero | 0.002 |
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_c8r32 | 38.817 | 59.367 | 1.811 | 0.006 | 0.019 | ||||||
| ma120300_rel_withdbg.cz12c_c8r32 | 44.806 | 55.189 | 0.006 | 0.006 | |||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 49.950 | 50.050 | 0.049 | ||||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 67.922 | 31.883 | 0.194 | 0.022 |
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_c8r32 | 85.072 | 13.139 | 1.789 | 0.014 | |||||||
| ma120300_rel_withdbg.cz12c_c8r32 | 87.450 | 12.544 | 0.006 | 0.006 | |||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 48.478 | 51.522 | 0.063 | ||||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 68.289 | 31.689 | 0.022 | 0.020 |
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 500 8411 0 0.0 64.1 2.1 0.000 0.000 0.128 4.208 49085 12.1 5.836 115 5.9 36.7 6.4 0.002 8414 8333 ma120300_rel_withdbg.cz12b_c8r32 500 8404 0 0.0 15.4 0.8 0.000 0.000 0.031 1.720 48831 12.2 5.811 116 5.8 37.1 6.4 0.002 8411 8335 ma120300_rel_withdbg.cz12c_c8r32 500 8486 0 0.0 153.3 1.6 0.000 0.000 0.307 3.264 49891 12.4 5.879 117 5.3 36.1 5.9 0.002 8494 8399 ma120300_rel_withdbg.cz12b_sync_c8r32 500 8550 0 0.0 53.3 0.9 0.000 0.000 0.107 1.933 49783 12.3 5.822 115 5.7 37.0 6.3 0.002 8543 8463 ma120300_rel_withdbg.cz12c_sync_c8r32
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 62.83 2070.0 0.737 8.130 7.141 84.99 0.008 0.031 0.000 0.000 0.026 0.145 1.935 2.102 0.056 1.561 ma120300_rel_withdbg.cz12b_c8r32 0.000 0.000 0.000 0.000 0.000 0.000 9.070 688.1 4.031 30.78 4.707 75.86 0.001 0.002 0.000 0.000 0.003 0.011 2.001 1.891 0.046 2.148 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 0.000 0.000 0.000 147.7 1477.8 105.7 42.66 1.939 9.302 0.002 0.007 0.000 0.000 0.017 0.033 60.09 2.313 0.416 16.95 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 0.000 0.000 0.000 0.000 47.05 796.1 7.193 13.09 1.357 16.92 0.000 0.000 0.000 0.000 0.000 0.000 22.00 1.469 0.096 4.329 ma120300_rel_withdbg.cz12c_sync_c8r32
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_c8r32 | 99.947 | 0.053 | nonzero | nonzero | 0.010 | ||||||
| ma120300_rel_withdbg.cz12c_c8r32 | 99.944 | 0.055 | nonzero | nonzero | 0.016 | ||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 99.962 | 0.037 | nonzero | nonzero | nonzero | 0.021 | |||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 99.974 | 0.025 | nonzero | nonzero | 0.012 |
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_c8r32 | 73.228 | 25.900 | 0.869 | 0.003 | 0.042 | ||||||
| ma120300_rel_withdbg.cz12c_c8r32 | 75.242 | 24.444 | 0.300 | 0.014 | 0.018 | ||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 56.394 | 43.606 | 0.061 | ||||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 77.667 | 22.258 | 0.075 | 0.022 |
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_c8r32 | 92.750 | 6.383 | 0.867 | 0.011 | |||||||
| ma120300_rel_withdbg.cz12c_c8r32 | 93.564 | 6.247 | 0.175 | 0.014 | 0.018 | ||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 55.058 | 44.942 | 0.046 | ||||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 78.444 | 21.531 | 0.025 | 0.019 |
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 999 9091 0 0.0 20.9 1.3 0.000 0.000 0.021 1.377 52508 12.7 5.776 112 5.9 36.7 6.4 0.010 9100 9022 ma120300_rel_withdbg.cz12b_c8r32 1000 9143 0 0.0 108.2 3.6 0.000 0.000 0.108 3.731 53079 12.8 5.805 112 5.8 37.1 6.4 0.016 9148 8975 ma120300_rel_withdbg.cz12c_c8r32 999 9049 0 0.0 361.0 4.5 0.000 0.000 0.361 4.643 53614 13.3 5.925 118 5.3 36.1 5.9 0.021 9055 8846 ma120300_rel_withdbg.cz12b_sync_c8r32 1000 9313 0 0.0 183.3 3.8 0.000 0.000 0.183 3.935 54243 12.9 5.824 111 5.7 37.0 6.3 0.012 9311 9103 ma120300_rel_withdbg.cz12c_sync_c8r32
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.022 0.011 15.82 1243.4 0.629 5.470 7.674 101.5 0.010 0.040 0.000 0.000 0.036 0.178 1.259 2.000 0.086 1.426 ma120300_rel_withdbg.cz12b_c8r32 0.002 0.007 0.000 0.000 0.000 0.022 102.2 3568.9 3.337 15.28 4.960 81.14 0.001 0.002 0.000 0.000 0.003 0.011 3.226 1.757 0.104 2.386 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 0.000 0.000 0.000 355.1 4479.1 211.4 40.57 1.870 10.25 0.003 0.013 0.000 0.000 0.017 0.067 121.0 2.316 0.908 32.42 ma120300_rel_withdbg.cz12b_sync_c8r32 0.001 0.002 0.000 0.000 0.011 0.011 177.3 3774.4 5.534 5.120 1.084 17.61 0.001 0.002 0.000 0.000 0.000 0.011 42.92 1.355 0.202 6.921 ma120300_rel_withdbg.cz12c_sync_c8r32
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_c8r32 | 99.946 | 0.054 | nonzero | nonzero | 0.014 | ||||||
| ma120300_rel_withdbg.cz12c_c8r32 | 99.939 | 0.061 | nonzero | 0.003 | |||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 99.969 | 0.031 | nonzero | 0.002 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 99.972 | 0.028 | 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_c8r32 | 61.464 | 37.531 | 0.983 | 0.022 | 0.042 | ||||||
| ma120300_rel_withdbg.cz12c_c8r32 | 66.406 | 33.242 | 0.311 | 0.042 | 0.046 | ||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 57.700 | 42.297 | 0.003 | 0.065 | |||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 80.994 | 18.939 | 0.067 | 0.034 |
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_c8r32 | 91.503 | 7.553 | 0.928 | 0.017 | 0.041 | ||||||
| ma120300_rel_withdbg.cz12c_c8r32 | 92.508 | 7.297 | 0.172 | 0.022 | 0.023 | ||||||
| ma120300_rel_withdbg.cz12b_sync_c8r32 | 56.139 | 43.861 | 0.046 | ||||||||
| ma120300_rel_withdbg.cz12c_sync_c8r32 | 81.617 | 18.350 | 0.033 | 0.034 |
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 999 8415 0 0.0 100.0 3.3 0.000 0.000 0.100 3.399 49440 13.0 5.875 124 5.9 36.7 6.4 0.014 8415 8333 ma120300_rel_withdbg.cz12b_c8r32 999 8373 0 0.0 101.4 3.5 0.000 0.000 0.101 3.561 49142 12.9 5.869 123 5.8 37.1 6.4 0.003 8380 8287 ma120300_rel_withdbg.cz12c_c8r32 999 8438 0 0.0 303.3 3.0 0.000 0.000 0.304 3.115 50453 13.3 5.980 126 5.3 36.1 5.9 0.002 8447 8335 ma120300_rel_withdbg.cz12b_sync_c8r32 999 8501 0 0.0 175.0 3.6 0.000 0.000 0.175 3.731 50090 13.2 5.893 124 5.7 37.0 6.3 0.008 8510 8399 ma120300_rel_withdbg.cz12c_sync_c8r32
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 93.99 3241.7 0.851 5.083 6.875 93.85 0.015 0.060 0.000 0.000 0.054 0.279 2.397 1.988 0.104 1.673 ma120300_rel_withdbg.cz12b_c8r32 0.001 0.002 0.000 0.000 0.000 0.011 95.55 3424.0 3.349 15.10 4.857 80.62 0.001 0.002 0.000 0.000 0.003 0.011 3.172 1.806 0.108 2.418 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 0.000 0.000 0.000 303.5 3114.5 211.2 42.02 1.892 9.566 0.003 0.011 0.000 0.000 0.014 0.056 120.2 2.304 0.842 32.18 ma120300_rel_withdbg.cz12b_sync_c8r32 0.001 0.002 0.000 0.000 0.003 0.011 175.2 3735.7 5.950 5.451 1.033 17.74 0.001 0.002 0.000 0.000 0.008 0.011 42.98 1.287 0.194 6.612 ma120300_rel_withdbg.cz12c_sync_c8r32
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 162162 0 0 0.0 272.7 31.6 0.000 0.000 0.002 0.200 21116 19.8 0.130 10 2.0 32.8 2.5 0.188 164173 132774 ma120300_rel_withdbg.cz12b_c8r32 166667 0 0 0.0 831.5 57.8 0.000 0.000 0.005 0.355 24485 20.0 0.147 10 2.0 33.3 2.6 0.215 167869 136176 ma120300_rel_withdbg.cz12c_c8r32 7036 0 0 0.0 567.8 5.1 0.000 0.000 0.081 0.737 3898 2.9 0.554 33 2.0 32.8 2.6 0.225 7299 5998 ma120300_rel_withdbg.cz12b_sync_c8r32 12290 0 0 0.0 534.0 9.1 0.000 0.000 0.043 0.758 5168 4.3 0.421 28 2.0 33.3 2.6 0.074 12398 10298 ma120300_rel_withdbg.cz12c_sync_c8r32
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 187501 0 0 0.0 2509.1 166.9 0.000 0.000 0.013 0.912 7683 12.2 0.041 5 4.2 35.0 4.1 0.001 NA NA ma120300_rel_withdbg.cz12b_c8r32 188680 0 0 0.0 2109.7 162.7 0.000 0.000 0.011 0.883 5306 12.0 0.028 5 4.2 35.5 4.2 0.001 NA NA ma120300_rel_withdbg.cz12c_c8r32 191083 0 0 0.0 2514.9 169.8 0.000 0.000 0.013 0.910 7390 12.2 0.039 5 4.2 35.0 4.3 0.019 NA NA ma120300_rel_withdbg.cz12b_sync_c8r32 193549 0 0 0.0 2076.0 164.6 0.000 0.000 0.011 0.871 5123 12.1 0.026 5 4.2 35.5 4.5 0.008 NA NA ma120300_rel_withdbg.cz12c_sync_c8r32
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 40080 0 0 0.0 3632.5 134.2 0.000 0.000 0.091 3.430 32308 31.5 0.806 63 5.9 36.7 6.5 0.270 41045 13598 ma120300_rel_withdbg.cz12b_c8r32 40161 0 0 0.0 4083.0 151.1 0.000 0.000 0.102 3.852 33806 31.8 0.842 63 5.8 37.1 6.4 0.169 41195 14947 ma120300_rel_withdbg.cz12c_c8r32 2777 0 0 0.0 1043.0 14.0 0.000 0.000 0.376 5.168 5695 4.0 2.051 115 5.3 36.1 5.9 0.244 2750 1700 ma120300_rel_withdbg.cz12b_sync_c8r32 11071 0 0 0.0 2022.6 45.5 0.000 0.000 0.183 4.212 12271 10.5 1.108 76 5.7 37.0 6.3 0.245 12348 3749 ma120300_rel_withdbg.cz12c_sync_c8r32
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 27322 0 0 0.0 2025.5 76.3 0.000 0.000 0.074 2.861 126000 32.5 4.612 95 5.9 36.7 6.5 0.067 28112 23622 ma120300_rel_withdbg.cz12b_c8r32 28248 0 0 0.0 2503.4 95.4 0.000 0.000 0.089 3.458 131305 33.2 4.648 94 5.8 37.1 6.4 0.041 29352 23273 ma120300_rel_withdbg.cz12c_c8r32 254 0 0 0.0 736.1 3.9 0.000 0.000 2.896 15.702 3972 1.8 15.626 566 5.3 36.1 5.9 0.079 240 175 ma120300_rel_withdbg.cz12b_sync_c8r32 1735 0 0 0.0 1526.2 8.6 0.000 0.000 0.880 5.049 12507 4.0 7.209 184 5.7 37.0 6.3 0.033 1920 1160 ma120300_rel_withdbg.cz12c_sync_c8r32
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 100 9096 0 0.0 9.1 0.3 0.000 0.000 0.092 2.968 52160 12.4 5.735 109 5.9 36.7 6.4 0.007 9102 9006 ma120300_rel_withdbg.cz12b_c8r32 100 9113 0 0.0 5.6 0.2 0.000 0.000 0.056 1.757 52238 12.4 5.732 109 5.8 37.1 6.4 0.001 9118 9023 ma120300_rel_withdbg.cz12c_c8r32 100 9145 0 0.0 34.7 0.4 0.000 0.000 0.348 4.417 52553 12.4 5.747 108 5.3 36.1 5.9 0.007 9151 9070 ma120300_rel_withdbg.cz12b_sync_c8r32 100 9266 0 0.0 11.2 0.2 0.000 0.000 0.112 1.877 53107 12.4 5.731 107 5.7 37.0 6.3 0.001 9246 9150 ma120300_rel_withdbg.cz12c_sync_c8r32
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 100 8460 0 0.0 20.3 0.6 0.000 0.000 0.203 6.063 49044 11.9 5.797 113 5.9 36.7 6.4 0.001 8462 8383 ma120300_rel_withdbg.cz12b_c8r32 100 8377 0 0.0 22.9 0.6 0.000 0.000 0.229 6.575 48577 12.1 5.799 116 5.8 37.1 6.4 0.001 8382 8301 ma120300_rel_withdbg.cz12c_c8r32 100 8528 0 0.0 41.0 0.6 0.000 0.000 0.410 6.157 49512 12.2 5.806 114 5.3 36.1 5.9 0.002 8527 8431 ma120300_rel_withdbg.cz12b_sync_c8r32 100 8573 0 0.0 30.2 0.7 0.000 0.000 0.303 7.156 49731 12.1 5.801 113 5.7 37.0 6.3 0.001 8575 8479 ma120300_rel_withdbg.cz12c_sync_c8r32
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 500 9114 0 0.0 62.2 2.0 0.000 0.000 0.124 4.188 52645 12.5 5.777 110 5.9 36.7 6.4 0.017 9118 8974 ma120300_rel_withdbg.cz12b_c8r32 500 9115 0 0.0 9.1 0.7 0.000 0.000 0.018 1.383 52397 12.4 5.748 109 5.8 37.1 6.4 0.001 9118 9053 ma120300_rel_withdbg.cz12c_c8r32 500 9119 0 0.0 147.6 1.5 0.000 0.000 0.295 2.976 53002 12.4 5.812 109 5.3 36.1 5.9 0.002 9119 9038 ma120300_rel_withdbg.cz12b_sync_c8r32 500 9218 0 0.0 51.7 0.9 0.000 0.000 0.103 1.860 53141 12.4 5.765 108 5.7 37.0 6.3 0.002 9215 9134 ma120300_rel_withdbg.cz12c_sync_c8r32
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 500 8411 0 0.0 64.1 2.1 0.000 0.000 0.128 4.208 49085 12.1 5.836 115 5.9 36.7 6.4 0.002 8414 8333 ma120300_rel_withdbg.cz12b_c8r32 500 8404 0 0.0 15.4 0.8 0.000 0.000 0.031 1.720 48831 12.2 5.811 116 5.8 37.1 6.4 0.002 8411 8335 ma120300_rel_withdbg.cz12c_c8r32 500 8486 0 0.0 153.3 1.6 0.000 0.000 0.307 3.264 49891 12.4 5.879 117 5.3 36.1 5.9 0.002 8494 8399 ma120300_rel_withdbg.cz12b_sync_c8r32 500 8550 0 0.0 53.3 0.9 0.000 0.000 0.107 1.933 49783 12.3 5.822 115 5.7 37.0 6.3 0.002 8543 8463 ma120300_rel_withdbg.cz12c_sync_c8r32
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 999 9091 0 0.0 20.9 1.3 0.000 0.000 0.021 1.377 52508 12.7 5.776 112 5.9 36.7 6.4 0.010 9100 9022 ma120300_rel_withdbg.cz12b_c8r32 1000 9143 0 0.0 108.2 3.6 0.000 0.000 0.108 3.731 53079 12.8 5.805 112 5.8 37.1 6.4 0.016 9148 8975 ma120300_rel_withdbg.cz12c_c8r32 999 9049 0 0.0 361.0 4.5 0.000 0.000 0.361 4.643 53614 13.3 5.925 118 5.3 36.1 5.9 0.021 9055 8846 ma120300_rel_withdbg.cz12b_sync_c8r32 1000 9313 0 0.0 183.3 3.8 0.000 0.000 0.183 3.935 54243 12.9 5.824 111 5.7 37.0 6.3 0.012 9311 9103 ma120300_rel_withdbg.cz12c_sync_c8r32
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 999 8415 0 0.0 100.0 3.3 0.000 0.000 0.100 3.399 49440 13.0 5.875 124 5.9 36.7 6.4 0.014 8415 8333 ma120300_rel_withdbg.cz12b_c8r32 999 8373 0 0.0 101.4 3.5 0.000 0.000 0.101 3.561 49142 12.9 5.869 123 5.8 37.1 6.4 0.003 8380 8287 ma120300_rel_withdbg.cz12c_c8r32 999 8438 0 0.0 303.3 3.0 0.000 0.000 0.304 3.115 50453 13.3 5.980 126 5.3 36.1 5.9 0.002 8447 8335 ma120300_rel_withdbg.cz12b_sync_c8r32 999 8501 0 0.0 175.0 3.6 0.000 0.000 0.175 3.731 50090 13.2 5.893 124 5.7 37.0 6.3 0.008 8510 8399 ma120300_rel_withdbg.cz12c_sync_c8r32
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 99.669 0.142 0.047 0.138 0.004 0.000 0.000 0.000 0.000 0.188 ma120300_rel_withdbg.cz12b_c8r32 0.000 99.667 0.140 0.080 0.112 0.001 0.000 0.000 0.000 0.000 0.215 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 85.577 14.423 0.001 0.000 0.000 0.000 0.000 0.225 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 0.004 99.766 0.229 nonzero 0.000 0.000 0.000 0.000 0.074 ma120300_rel_withdbg.cz12c_sync_c8r32
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 38.517 60.059 1.193 0.226 0.004 nonzero 0.000 0.000 0.000 0.270 ma120300_rel_withdbg.cz12b_c8r32 0.000 42.867 55.567 1.330 0.233 0.004 0.000 0.000 0.000 0.000 0.169 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 50.492 49.488 0.020 0.000 0.000 0.000 0.000 0.244 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 73.114 26.504 0.381 0.001 0.000 0.000 0.000 0.000 0.245 ma120300_rel_withdbg.cz12c_sync_c8r32
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 87.092 11.744 0.966 0.196 0.003 nonzero 0.000 0.000 0.000 0.270 ma120300_rel_withdbg.cz12b_c8r32 0.000 87.316 11.399 1.079 0.203 0.003 0.000 0.000 0.000 0.000 0.168 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 50.033 49.947 0.020 0.000 0.000 0.000 0.000 0.227 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 73.084 26.651 0.264 0.001 0.000 0.000 0.000 0.000 0.224 ma120300_rel_withdbg.cz12c_sync_c8r32
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 98.378 1.515 0.040 0.063 0.003 nonzero 0.000 0.000 0.000 0.000 0.067 ma120300_rel_withdbg.cz12b_c8r32 98.728 1.155 0.042 0.072 0.003 0.000 0.000 0.000 0.000 0.000 0.041 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 26.537 73.462 0.001 0.000 0.000 0.000 0.000 0.079 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 89.759 10.238 0.003 0.000 0.000 0.000 0.000 0.000 0.033 ma120300_rel_withdbg.cz12c_sync_c8r32
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 99.197 0.711 0.034 0.056 0.003 nonzero 0.000 0.000 0.000 0.000 0.067 ma120300_rel_withdbg.cz12b_c8r32 99.333 0.567 0.036 0.061 0.002 0.000 0.000 0.000 0.000 0.000 0.040 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 26.532 73.466 0.002 0.000 0.000 0.000 0.000 0.108 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 nonzero 89.717 10.280 0.003 0.000 0.000 0.000 0.000 0.000 0.037 ma120300_rel_withdbg.cz12c_sync_c8r32
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.964 0.036 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.007 ma120300_rel_withdbg.cz12b_c8r32 99.963 0.037 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.001 ma120300_rel_withdbg.cz12c_c8r32 99.977 0.023 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.007 ma120300_rel_withdbg.cz12b_sync_c8r32 99.986 0.014 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.001 ma120300_rel_withdbg.cz12c_sync_c8r32
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 7.972 83.111 8.889 0.028 0.000 0.000 0.000 0.000 0.000 0.026 ma120300_rel_withdbg.cz12b_c8r32 0.000 12.139 87.833 0.028 0.000 0.000 0.000 0.000 0.000 0.000 0.008 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 33.056 66.944 0.000 0.000 0.000 0.000 0.000 0.051 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 27.278 69.167 3.556 0.000 0.000 0.000 0.000 0.000 0.024 ma120300_rel_withdbg.cz12c_sync_c8r32
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 42.639 48.500 8.861 0.000 0.000 0.000 0.000 0.000 0.000 0.015 ma120300_rel_withdbg.cz12b_c8r32 0.000 59.639 40.333 0.028 0.000 0.000 0.000 0.000 0.000 0.000 0.007 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 31.889 68.056 0.056 0.000 0.000 0.000 0.000 0.066 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 12.194 86.056 1.750 0.000 0.000 0.000 0.000 0.000 0.026 ma120300_rel_withdbg.cz12c_sync_c8r32
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.964 0.036 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.001 ma120300_rel_withdbg.cz12b_c8r32 99.962 0.038 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.001 ma120300_rel_withdbg.cz12c_c8r32 99.981 0.019 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.002 ma120300_rel_withdbg.cz12b_sync_c8r32 99.987 0.013 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.001 ma120300_rel_withdbg.cz12c_sync_c8r32
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.361 90.778 8.861 0.000 0.000 0.000 0.000 0.000 0.000 0.011 ma120300_rel_withdbg.cz12b_c8r32 0.000 0.750 99.194 0.028 0.028 0.000 0.000 0.000 0.000 0.000 0.019 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 31.611 68.389 0.000 0.000 0.000 0.000 0.000 0.056 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 13.806 70.944 15.250 0.000 0.000 0.000 0.000 0.000 0.033 ma120300_rel_withdbg.cz12c_sync_c8r32
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 31.861 59.389 8.750 0.000 0.000 0.000 0.000 0.000 0.000 0.011 ma120300_rel_withdbg.cz12b_c8r32 0.000 48.028 51.944 0.028 0.000 0.000 0.000 0.000 0.000 0.000 0.012 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 28.861 71.111 0.028 0.000 0.000 0.000 0.000 0.065 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 7.861 86.778 5.361 0.000 0.000 0.000 0.000 0.000 0.022 ma120300_rel_withdbg.cz12c_sync_c8r32
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.947 0.053 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.017 ma120300_rel_withdbg.cz12b_c8r32 99.948 0.052 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.001 ma120300_rel_withdbg.cz12c_c8r32 99.971 0.029 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.002 ma120300_rel_withdbg.cz12b_sync_c8r32 99.976 0.024 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.002 ma120300_rel_withdbg.cz12c_sync_c8r32
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 51.672 46.528 1.789 0.011 0.000 0.000 0.000 0.000 0.000 0.019 ma120300_rel_withdbg.cz12b_c8r32 0.000 59.689 40.311 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 53.389 46.611 0.000 0.000 0.000 0.000 0.000 0.064 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 72.106 27.700 0.194 0.000 0.000 0.000 0.000 0.000 0.021 ma120300_rel_withdbg.cz12c_sync_c8r32
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 86.756 11.472 1.767 0.006 0.000 0.000 0.000 0.000 0.000 0.018 ma120300_rel_withdbg.cz12b_c8r32 0.000 89.961 10.039 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 52.244 47.756 0.000 0.000 0.000 0.000 0.000 0.048 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 72.967 27.011 0.022 0.000 0.000 0.000 0.000 0.000 0.020 ma120300_rel_withdbg.cz12c_sync_c8r32
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.947 0.053 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.002 ma120300_rel_withdbg.cz12b_c8r32 99.943 0.057 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.002 ma120300_rel_withdbg.cz12c_c8r32 99.974 0.026 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.002 ma120300_rel_withdbg.cz12b_sync_c8r32 99.978 0.022 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.002 ma120300_rel_withdbg.cz12c_sync_c8r32
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 38.817 59.367 1.811 0.006 0.000 0.000 0.000 0.000 0.000 0.019 ma120300_rel_withdbg.cz12b_c8r32 0.000 44.806 55.189 0.006 0.000 0.000 0.000 0.000 0.000 0.000 0.006 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 49.950 50.050 0.000 0.000 0.000 0.000 0.000 0.049 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 67.922 31.883 0.194 0.000 0.000 0.000 0.000 0.000 0.022 ma120300_rel_withdbg.cz12c_sync_c8r32
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 85.072 13.139 1.789 0.000 0.000 0.000 0.000 0.000 0.000 0.014 ma120300_rel_withdbg.cz12b_c8r32 0.000 87.450 12.544 0.006 0.000 0.000 0.000 0.000 0.000 0.000 0.006 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 48.478 51.522 0.000 0.000 0.000 0.000 0.000 0.063 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 68.289 31.689 0.022 0.000 0.000 0.000 0.000 0.000 0.020 ma120300_rel_withdbg.cz12c_sync_c8r32
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.947 0.053 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.010 ma120300_rel_withdbg.cz12b_c8r32 99.944 0.055 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.016 ma120300_rel_withdbg.cz12c_c8r32 99.962 0.037 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.021 ma120300_rel_withdbg.cz12b_sync_c8r32 99.974 0.025 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.012 ma120300_rel_withdbg.cz12c_sync_c8r32
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 73.228 25.900 0.869 0.003 0.000 0.000 0.000 0.000 0.000 0.042 ma120300_rel_withdbg.cz12b_c8r32 0.000 75.242 24.444 0.300 0.014 0.000 0.000 0.000 0.000 0.000 0.018 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 56.394 43.606 0.000 0.000 0.000 0.000 0.000 0.061 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 77.667 22.258 0.075 0.000 0.000 0.000 0.000 0.000 0.022 ma120300_rel_withdbg.cz12c_sync_c8r32
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 92.750 6.383 0.867 0.000 0.000 0.000 0.000 0.000 0.000 0.011 ma120300_rel_withdbg.cz12b_c8r32 0.000 93.564 6.247 0.175 0.014 0.000 0.000 0.000 0.000 0.000 0.018 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 55.058 44.942 0.000 0.000 0.000 0.000 0.000 0.046 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 78.444 21.531 0.025 0.000 0.000 0.000 0.000 0.000 0.019 ma120300_rel_withdbg.cz12c_sync_c8r32
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.946 0.054 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.014 ma120300_rel_withdbg.cz12b_c8r32 99.939 0.061 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 ma120300_rel_withdbg.cz12c_c8r32 99.969 0.031 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.002 ma120300_rel_withdbg.cz12b_sync_c8r32 99.972 0.028 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.008 ma120300_rel_withdbg.cz12c_sync_c8r32
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 61.464 37.531 0.983 0.022 0.000 0.000 0.000 0.000 0.000 0.042 ma120300_rel_withdbg.cz12b_c8r32 0.000 66.406 33.242 0.311 0.042 0.000 0.000 0.000 0.000 0.000 0.046 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 57.700 42.297 0.003 0.000 0.000 0.000 0.000 0.065 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 80.994 18.939 0.067 0.000 0.000 0.000 0.000 0.000 0.034 ma120300_rel_withdbg.cz12c_sync_c8r32
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 91.503 7.553 0.928 0.017 0.000 0.000 0.000 0.000 0.000 0.041 ma120300_rel_withdbg.cz12b_c8r32 0.000 92.508 7.297 0.172 0.022 0.000 0.000 0.000 0.000 0.000 0.023 ma120300_rel_withdbg.cz12c_c8r32 0.000 0.000 0.000 56.139 43.861 0.000 0.000 0.000 0.000 0.000 0.046 ma120300_rel_withdbg.cz12b_sync_c8r32 0.000 0.000 81.617 18.350 0.033 0.000 0.000 0.000 0.000 0.000 0.034 ma120300_rel_withdbg.cz12c_sync_c8r32