Introduction
This is a report for the insert benchmark with 800M 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 800M rows per table without secondary indexes, creates 3 secondary indexes per table, then inserts 4m+1m 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 larger than memory and the workload is IO-bound for except for the range query tests (qr*). Clients and the DBMS share one server.
The tested DBMS are:
- my5651_rel_o2nofp.cz12a_c8r32 - MySQL 5.6.51 with the cz12a_c8r32 config
- my5744_rel_o2nofp.cz12a_c8r32 - MySQL 5.7.44 with the cz12a_c8r32 config
- my8043_rel_o2nofp.cz12a_c8r32 - MySQL 8.0.43 with the cz12a_c8r32 config
- my8044_rel_o2nofp.cz12a_c8r32 - MySQL 8.0.44 with the cz12a_c8r32 config
- my8406_rel_o2nofp.cz12a_c8r32 - MySQL 8.4.6 with the cz12a_c8r32 config
- my8407_rel_o2nofp.cz12a_c8r32 - MySQL 8.4.7 with the cz12a_c8r32 config
- my8407_rel_o2nofp.cz12a_dw0_c8r32 - MySQL 8.4.7 with the cz12a_dw0_c8r32 config that adds innodb_doublewrite=0
- my9400_rel_o2nofp.cz12a_c8r32 - MySQL 9.4.0 with the cz12a_c8r32 config
- my9500_rel_o2nofp.cz12a_c8r32 - MySQL 9.5.0 with the cz12a_c8r32 config
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 177148 | 112233 | 1975 | 2198 | 12027 | 1471 | 11348 | 1145 | 10547 | 856 |
| my5744_rel_o2nofp.cz12a_c8r32 | 160642 | 159077 | 3003 | 3906 | 10067 | 1351 | 9902 | 1110 | 9779 | 1001 |
| my8043_rel_o2nofp.cz12a_c8r32 | 109860 | 293578 | 3077 | 3906 | 9065 | 1299 | 8951 | 1130 | 8896 | 1011 |
| my8044_rel_o2nofp.cz12a_c8r32 | 110072 | 289855 | 3074 | 3968 | 9115 | 1289 | 9012 | 1128 | 8965 | 1010 |
| my8406_rel_o2nofp.cz12a_c8r32 | 108006 | 292826 | 3051 | 3891 | 8763 | 1274 | 8658 | 1110 | 8618 | 996 |
| my8407_rel_o2nofp.cz12a_c8r32 | 105416 | 297398 | 3035 | 4000 | 8850 | 1279 | 8759 | 1117 | 8612 | 999 |
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 108533 | 299738 | 3308 | 4255 | 8723 | 1283 | 8673 | 1137 | 8622 | 1035 |
| my9400_rel_o2nofp.cz12a_c8r32 | 108430 | 300526 | 2994 | 3861 | 9075 | 1269 | 9059 | 1112 | 8953 | 997 |
| my9500_rel_o2nofp.cz12a_c8r32 | 106482 | 309119 | 3026 | 3802 | 9080 | 1275 | 8965 | 1115 | 8894 | 999 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| my5744_rel_o2nofp.cz12a_c8r32 | 0.91 | 1.42 | 1.52 | 1.78 | 0.84 | 0.92 | 0.87 | 0.97 | 0.93 | 1.17 |
| my8043_rel_o2nofp.cz12a_c8r32 | 0.62 | 2.62 | 1.56 | 1.78 | 0.75 | 0.88 | 0.79 | 0.99 | 0.84 | 1.18 |
| my8044_rel_o2nofp.cz12a_c8r32 | 0.62 | 2.58 | 1.56 | 1.81 | 0.76 | 0.88 | 0.79 | 0.99 | 0.85 | 1.18 |
| my8406_rel_o2nofp.cz12a_c8r32 | 0.61 | 2.61 | 1.54 | 1.77 | 0.73 | 0.87 | 0.76 | 0.97 | 0.82 | 1.16 |
| my8407_rel_o2nofp.cz12a_c8r32 | 0.60 | 2.65 | 1.54 | 1.82 | 0.74 | 0.87 | 0.77 | 0.98 | 0.82 | 1.17 |
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 0.61 | 2.67 | 1.67 | 1.94 | 0.73 | 0.87 | 0.76 | 0.99 | 0.82 | 1.21 |
| my9400_rel_o2nofp.cz12a_c8r32 | 0.61 | 2.68 | 1.52 | 1.76 | 0.75 | 0.86 | 0.80 | 0.97 | 0.85 | 1.16 |
| my9500_rel_o2nofp.cz12a_c8r32 | 0.60 | 2.75 | 1.53 | 1.73 | 0.75 | 0.87 | 0.79 | 0.97 | 0.84 | 1.17 |
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 |
|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 100 | 100 | 500 | 500 | 999 | 999 |
| my5744_rel_o2nofp.cz12a_c8r32 | 100 | 100 | 500 | 500 | 999 | 999 |
| my8043_rel_o2nofp.cz12a_c8r32 | 100 | 100 | 500 | 500 | 1000 | 1000 |
| my8044_rel_o2nofp.cz12a_c8r32 | 100 | 100 | 500 | 500 | 1000 | 1000 |
| my8406_rel_o2nofp.cz12a_c8r32 | 100 | 100 | 500 | 500 | 1000 | 1000 |
| my8407_rel_o2nofp.cz12a_c8r32 | 100 | 100 | 500 | 500 | 1000 | 1000 |
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 100 | 100 | 500 | 500 | 1000 | 1000 |
| my9400_rel_o2nofp.cz12a_c8r32 | 100 | 100 | 500 | 500 | 1000 | 1000 |
| my9500_rel_o2nofp.cz12a_c8r32 | 100 | 100 | 500 | 500 | 1000 | 1000 |
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 99.555 | 0.380 | 0.022 | 0.041 | 0.002 | 0.222 | |||||
| my5744_rel_o2nofp.cz12a_c8r32 | 99.711 | 0.115 | 0.059 | 0.114 | 0.001 | 0.161 | |||||
| my8043_rel_o2nofp.cz12a_c8r32 | 99.571 | 0.253 | 0.054 | 0.121 | 0.001 | nonzero | 0.341 | ||||
| my8044_rel_o2nofp.cz12a_c8r32 | 99.574 | 0.250 | 0.056 | 0.118 | 0.001 | nonzero | 0.334 | ||||
| my8406_rel_o2nofp.cz12a_c8r32 | 99.565 | 0.258 | 0.053 | 0.122 | 0.002 | nonzero | 0.340 | ||||
| my8407_rel_o2nofp.cz12a_c8r32 | 99.551 | 0.271 | 0.053 | 0.123 | 0.002 | nonzero | 0.337 | ||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 99.578 | 0.245 | 0.055 | 0.121 | 0.002 | nonzero | 0.347 | ||||
| my9400_rel_o2nofp.cz12a_c8r32 | 99.569 | 0.256 | 0.116 | 0.057 | 0.001 | nonzero | 0.318 | ||||
| my9500_rel_o2nofp.cz12a_c8r32 | 99.494 | 0.330 | 0.085 | 0.089 | 0.002 | nonzero | 0.325 |
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 177148 0 1496 5.8 1159.6 63.5 0.008 0.034 0.007 0.367 23812 19.6 0.134 9 52.6 83.1 24.7 0.222 177976 143381 my5651_rel_o2nofp.cz12a_c8r32 160642 0 0 0.0 1063.3 57.8 0.000 0.000 0.007 0.369 18897 19.4 0.118 10 52.6 83.1 25.0 0.161 160578 149979 my5744_rel_o2nofp.cz12a_c8r32 109860 0 0 0.0 745.0 41.2 0.000 0.000 0.007 0.384 13601 17.2 0.124 13 52.4 83.0 25.3 0.341 109786 102585 my8043_rel_o2nofp.cz12a_c8r32 110072 0 0 0.0 746.5 41.3 0.000 0.000 0.007 0.384 13604 17.2 0.124 13 52.4 83.0 25.3 0.334 110082 102785 my8044_rel_o2nofp.cz12a_c8r32 108006 0 0 0.0 732.5 40.5 0.000 0.000 0.007 0.384 13387 17.2 0.124 13 52.4 120.1 25.3 0.340 107987 100687 my8406_rel_o2nofp.cz12a_c8r32 105416 0 0 0.0 715.5 39.6 0.000 0.000 0.007 0.384 13046 17.2 0.124 13 52.4 120.1 25.3 0.337 105288 98187 my8407_rel_o2nofp.cz12a_c8r32 108533 0 0 0.0 677.8 33.6 0.000 0.000 0.006 0.317 13271 17.2 0.122 13 52.4 120.1 25.2 0.347 108585 100985 my8407_rel_o2nofp.cz12a_dw0_c8r32 108430 0 0 0.0 735.6 40.7 0.000 0.000 0.007 0.384 13422 17.2 0.124 13 52.4 120.1 25.3 0.318 108386 101387 my9400_rel_o2nofp.cz12a_c8r32 106482 0 0 0.0 730.4 40.4 0.000 0.000 0.007 0.388 14060 17.2 0.132 13 52.4 120.1 25.4 0.325 106485 98787 my9500_rel_o2nofp.cz12a_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 1496.0 5984.6 0.000 0.000 0.106 3.965 1160.6 65078.2 10.29 0.902 0.479 57.06 0.263 1.999 0.000 0.000 0.150 1.122 1.528 2.558 0.763 11.78 my5651_rel_o2nofp.cz12a_c8r32 0.244 1.878 0.000 0.000 2.385 2.347 1064.1 59247.2 21.88 2.057 0.889 55.32 0.315 4.446 0.000 0.000 0.126 2.328 4.393 1.533 0.918 6.915 my5744_rel_o2nofp.cz12a_c8r32 0.201 1.773 0.002 0.051 2.052 2.029 745.3 42216.2 15.27 2.070 1.475 56.34 0.216 1.931 0.000 0.000 0.129 1.584 4.551 1.550 1.085 5.122 my8043_rel_o2nofp.cz12a_c8r32 0.204 1.737 0.002 0.044 1.912 2.033 746.9 42301.9 15.87 2.131 1.460 56.33 0.215 1.990 0.000 0.000 0.127 1.643 4.550 1.528 1.070 5.121 my8044_rel_o2nofp.cz12a_c8r32 0.190 1.589 0.002 0.045 2.003 2.004 732.9 41506.9 15.45 2.109 1.486 56.33 0.142 2.140 0.000 0.000 0.133 3.105 4.512 1.558 1.073 5.115 my8406_rel_o2nofp.cz12a_c8r32 0.190 1.608 0.002 0.045 1.970 1.985 715.8 40513.8 15.13 2.115 1.452 56.28 0.151 2.796 0.000 0.000 0.129 3.897 4.463 1.564 1.022 5.046 my8407_rel_o2nofp.cz12a_c8r32 0.189 1.561 0.000 0.000 1.927 2.014 678.1 34466.4 14.52 2.137 1.434 50.36 0.204 1.804 0.000 0.000 0.127 1.558 4.528 1.552 0.958 5.103 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.198 1.732 0.000 0.000 2.051 1.976 735.9 41674.3 15.66 2.140 1.402 56.32 0.236 1.923 0.000 0.000 0.099 1.420 4.514 1.076 1.015 4.770 my9400_rel_o2nofp.cz12a_c8r32 0.192 1.601 0.000 0.000 1.931 1.984 730.7 41370.8 15.82 2.165 1.443 56.33 0.158 2.067 0.000 0.000 0.117 2.756 4.591 1.264 1.038 4.858 my9500_rel_o2nofp.cz12a_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 112233 0 1216 111.6 1791.4 145.3 0.011 1.019 0.016 1.325 2299 10.1 0.020 7 111.4 141.9 24.8 0.004 NA NA my5651_rel_o2nofp.cz12a_c8r32 159077 0 1677 155.8 2412.2 189.5 0.011 1.003 0.015 1.220 8900 11.6 0.056 6 121.1 151.7 25.1 0.001 NA NA my5744_rel_o2nofp.cz12a_c8r32 293578 0 4074 400.3 8863.5 447.7 0.014 1.396 0.030 1.562 20887 40.6 0.071 11 120.7 151.3 25.4 0.002 NA NA my8043_rel_o2nofp.cz12a_c8r32 289855 0 4016 395.3 8753.0 442.0 0.014 1.396 0.030 1.562 20348 41.5 0.070 11 120.7 151.3 25.4 0.002 NA NA my8044_rel_o2nofp.cz12a_c8r32 292826 0 4061 401.1 8843.8 446.9 0.014 1.403 0.030 1.563 20731 40.2 0.071 11 120.7 188.4 25.4 0.002 NA NA my8406_rel_o2nofp.cz12a_c8r32 297398 0 4121 407.3 8983.2 453.6 0.014 1.402 0.030 1.562 21046 41.5 0.071 11 120.7 188.4 25.4 0.001 NA NA my8407_rel_o2nofp.cz12a_c8r32 299738 0 4154 411.1 8841.7 434.6 0.014 1.404 0.029 1.485 21979 41.6 0.073 11 120.7 188.4 25.4 0.001 NA NA my8407_rel_o2nofp.cz12a_dw0_c8r32 300526 0 4115 401.0 9087.4 458.6 0.014 1.366 0.030 1.563 21351 41.2 0.071 11 120.7 188.4 25.4 0.002 NA NA my9400_rel_o2nofp.cz12a_c8r32 309119 0 4291 423.9 9351.9 471.9 0.014 1.404 0.030 1.563 21635 41.5 0.070 11 120.7 188.4 25.6 0.002 NA NA my9500_rel_o2nofp.cz12a_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 1215.0 114372 0.000 0.000 0.154 94.59 1792.5 148842 85.30 4.005 0.239 90.66 0.169 4609.8 0.000 0.000 0.001 38.81 31.03 2.666 0.686 38.15 my5651_rel_o2nofp.cz12a_c8r32 1676.1 159695 0.000 0.000 0.153 97.72 2407.9 194037 15.94 0.484 0.139 117.9 0.527 10119.4 0.000 0.000 0.004 85.61 3.851 2.804 0.579 23.64 my5744_rel_o2nofp.cz12a_c8r32 4068.2 410444 0.000 0.000 0.377 113.8 8849.5 458953 34.71 0.433 0.619 69.97 5.367 47610.8 0.000 0.000 0.017 209.1 7.820 3.269 6.149 66.04 my8043_rel_o2nofp.cz12a_c8r32 4010.5 405300 0.000 0.000 0.334 114.4 8738.2 453109 34.01 0.435 0.544 70.94 4.553 47124.1 0.000 0.000 0.022 316.1 7.745 3.002 5.316 63.42 my8044_rel_o2nofp.cz12a_c8r32 4056.0 411319 0.000 0.000 0.384 114.5 8829.5 458065 34.14 0.449 0.623 69.98 4.652 40404.5 0.000 0.000 0.029 250.4 7.814 4.025 6.126 66.75 my8406_rel_o2nofp.cz12a_c8r32 4114.8 417601 0.000 0.000 0.350 114.7 8968.0 464928 34.94 0.437 0.572 70.33 4.883 48389.5 0.000 0.000 0.017 290.8 7.913 3.236 5.751 65.62 my8407_rel_o2nofp.cz12a_c8r32 4148.4 421534 0.000 0.000 0.344 114.8 8826.0 445381 34.62 0.463 0.982 68.17 3.939 41529.9 0.000 0.000 0.016 255.9 7.944 3.265 8.259 65.05 my8407_rel_o2nofp.cz12a_dw0_c8r32 4109.0 411197 0.013 0.001 0.282 111.9 9072.5 470084 34.89 0.459 0.608 69.48 4.773 44110.2 0.000 0.000 0.017 296.2 8.039 2.509 5.425 59.74 my9400_rel_o2nofp.cz12a_c8r32 4285.7 434654 0.000 0.000 0.304 114.2 9337.4 483717 35.44 0.441 0.594 69.42 4.679 42574.9 0.000 0.000 0.017 213.6 8.229 2.694 5.688 62.21 my9500_rel_o2nofp.cz12a_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 14.247 | 84.720 | 1.031 | 0.001 | 0.697 | ||||||
| my5744_rel_o2nofp.cz12a_c8r32 | 64.752 | 34.836 | 0.411 | 0.113 | |||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 0.001 | 67.993 | 30.679 | 1.325 | 0.003 | 0.432 | |||||
| my8044_rel_o2nofp.cz12a_c8r32 | 68.450 | 30.118 | 1.430 | 0.003 | 0.474 | ||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 0.003 | 67.681 | 30.976 | 1.337 | 0.003 | 0.506 | |||||
| my8407_rel_o2nofp.cz12a_c8r32 | 0.001 | 67.840 | 30.610 | 1.546 | 0.003 | 0.500 | |||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 0.001 | 70.641 | 28.075 | 1.280 | 0.003 | 0.431 | |||||
| my9400_rel_o2nofp.cz12a_c8r32 | 67.406 | 30.990 | 1.601 | 0.003 | 0.477 | ||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 68.093 | 30.406 | 1.499 | 0.003 | 0.493 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 0.024 | 94.983 | 4.772 | 0.219 | 0.001 | 0.001 | 0.574 | ||||
| my5744_rel_o2nofp.cz12a_c8r32 | 0.004 | 99.677 | 0.285 | 0.034 | 0.049 | ||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 99.361 | 0.594 | 0.042 | 0.003 | 0.431 | ||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 99.404 | 0.544 | 0.051 | 0.001 | 0.466 | ||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 99.321 | 0.632 | 0.045 | 0.001 | 0.440 | ||||||
| my8407_rel_o2nofp.cz12a_c8r32 | 99.369 | 0.585 | 0.044 | 0.001 | 0.001 | 0.468 | |||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 99.710 | 0.249 | 0.039 | 0.003 | 0.430 | ||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 99.350 | 0.599 | 0.046 | 0.005 | 0.104 | ||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 99.364 | 0.583 | 0.051 | 0.003 | 0.492 |
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 1975 0 9384 145.8 16394.7 382.2 4.751 75.581 8.300 198.112 45500 16.5 23.034 668 144.5 175.0 24.7 0.697 1850 1200 my5651_rel_o2nofp.cz12a_c8r32 3003 0 13870 216.7 18840.3 560.2 4.619 73.901 6.274 191.029 36919 22.2 12.294 591 144.6 175.1 25.1 0.113 3000 1600 my5744_rel_o2nofp.cz12a_c8r32 3077 0 11433 178.6 16737.9 503.5 3.716 59.453 5.440 167.563 76647 21.6 24.910 562 148.8 179.5 25.4 0.432 2900 1750 my8043_rel_o2nofp.cz12a_c8r32 3074 0 11435 178.7 16790.9 505.3 3.719 59.506 5.461 168.300 75710 21.7 24.625 565 148.8 179.6 25.4 0.474 2900 1750 my8044_rel_o2nofp.cz12a_c8r32 3051 0 11382 177.8 16681.4 502.3 3.730 59.687 5.467 168.586 78250 21.6 25.646 566 148.7 216.9 25.4 0.506 2900 1700 my8406_rel_o2nofp.cz12a_c8r32 3035 0 11308 176.7 16592.3 498.6 3.726 59.614 5.467 168.240 76794 21.6 25.304 569 148.7 217.1 25.4 0.500 2850 1700 my8407_rel_o2nofp.cz12a_c8r32 3308 0 12284 191.9 15972.1 298.2 3.713 59.405 4.828 92.304 89089 22.8 26.927 551 148.7 217.0 25.3 0.431 3150 1850 my8407_rel_o2nofp.cz12a_dw0_c8r32 2994 0 11170 174.5 16392.6 493.1 3.731 59.694 5.475 168.660 75995 21.4 25.383 572 148.7 217.0 24.5 0.477 2850 1650 my9400_rel_o2nofp.cz12a_c8r32 3026 0 11282 176.3 16545.3 497.1 3.729 59.659 5.468 168.228 76245 21.7 25.199 574 148.8 217.1 25.5 0.493 2850 1700 my9500_rel_o2nofp.cz12a_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 9397.2 149511 0.000 0.000 0.102 15.91 16407.4 389368 16.42 0.142 0.038 24.98 0.002 0.083 0.000 0.000 0.007 0.406 3.948 2.508 1.496 72.27 my5651_rel_o2nofp.cz12a_c8r32 13880.7 222090 0.000 0.000 0.151 16.00 18905.8 575401 37.25 0.331 0.143 31.39 0.004 0.027 0.000 0.000 0.009 0.121 9.795 3.264 4.791 79.65 my5744_rel_o2nofp.cz12a_c8r32 11444.7 183114 0.000 0.000 0.150 16.00 16792.1 516985 56.39 0.423 1.994 31.33 0.011 2.205 0.000 0.000 0.015 5.000 10.19 3.639 35.45 73.97 my8043_rel_o2nofp.cz12a_c8r32 11446.2 183137 0.000 0.000 0.152 16.00 16846.7 518881 48.20 0.396 1.890 31.43 0.013 0.432 0.000 0.000 0.017 0.726 10.18 3.548 33.80 74.31 my8044_rel_o2nofp.cz12a_c8r32 11393.6 182296 0.000 0.000 0.148 16.00 16736.1 515791 76.56 0.542 2.124 31.36 0.009 1.081 0.000 0.000 0.011 4.038 10.11 3.583 37.55 73.77 my8406_rel_o2nofp.cz12a_c8r32 11319.1 181103 0.000 0.000 0.150 16.00 16644.7 511942 63.69 0.481 2.098 31.34 0.018 0.791 0.000 0.000 0.025 2.116 10.02 3.633 36.86 74.03 my8407_rel_o2nofp.cz12a_c8r32 12299.7 196793 0.000 0.000 0.131 16.00 16028.6 306137 37.17 0.345 4.673 19.88 0.013 1.009 0.000 0.000 0.025 2.706 9.797 3.749 77.99 70.99 my8407_rel_o2nofp.cz12a_dw0_c8r32 11182.6 178921 0.007 0.000 0.156 16.00 16446.0 506362 36.51 0.348 2.087 31.52 0.015 0.956 0.000 0.000 0.019 2.078 9.928 3.635 36.48 73.65 my9400_rel_o2nofp.cz12a_c8r32 11292.6 180680 0.000 0.000 0.157 16.00 16599.8 510419 50.51 0.413 2.106 31.45 0.014 0.855 0.000 0.000 0.022 1.825 10.11 3.689 37.10 73.77 my9500_rel_o2nofp.cz12a_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 0.386 | 16.956 | 72.162 | 10.281 | 0.215 | 0.035 | |||||
| my5744_rel_o2nofp.cz12a_c8r32 | 0.789 | 56.744 | 38.871 | 3.562 | 0.034 | 0.039 | |||||
| my8043_rel_o2nofp.cz12a_c8r32 | 0.001 | 53.487 | 43.280 | 3.153 | 0.079 | 0.050 | |||||
| my8044_rel_o2nofp.cz12a_c8r32 | 0.001 | 55.420 | 41.381 | 3.159 | 0.039 | 0.048 | |||||
| my8406_rel_o2nofp.cz12a_c8r32 | 0.001 | 53.582 | 43.169 | 3.185 | 0.064 | 0.041 | |||||
| my8407_rel_o2nofp.cz12a_c8r32 | 55.695 | 41.160 | 3.110 | 0.036 | 0.044 | ||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 57.135 | 41.555 | 1.087 | 0.222 | 0.001 | 0.106 | |||||
| my9400_rel_o2nofp.cz12a_c8r32 | 53.611 | 43.108 | 3.228 | 0.053 | 0.052 | ||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 50.318 | 46.282 | 3.349 | 0.051 | 0.031 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 4.109 | 74.066 | 20.787 | 0.988 | 0.051 | 0.031 | |||||
| my5744_rel_o2nofp.cz12a_c8r32 | 38.399 | 61.453 | 0.122 | 0.025 | 0.001 | 0.024 | |||||
| my8043_rel_o2nofp.cz12a_c8r32 | 98.043 | 1.830 | 0.122 | 0.005 | 0.051 | ||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 98.119 | 1.758 | 0.113 | 0.009 | 0.029 | ||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 98.155 | 1.728 | 0.108 | 0.007 | 0.001 | 0.068 | |||||
| my8407_rel_o2nofp.cz12a_c8r32 | 0.001 | 98.276 | 1.615 | 0.102 | 0.006 | 0.032 | |||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 99.141 | 0.758 | 0.091 | 0.009 | 0.001 | 0.102 | |||||
| my9400_rel_o2nofp.cz12a_c8r32 | 98.145 | 1.720 | 0.127 | 0.009 | 0.040 | ||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 97.744 | 2.097 | 0.149 | 0.010 | 0.062 |
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 2198 0 9893 146.5 15586.5 366.3 4.501 68.240 7.092 170.668 59892 24.2 27.251 881 144.5 175.0 24.7 0.035 2190 1940 my5651_rel_o2nofp.cz12a_c8r32 3906 0 15695 245.2 21534.2 621.1 4.018 64.288 5.513 162.808 59863 31.0 15.325 635 144.6 175.1 25.1 0.039 3970 3055 my5744_rel_o2nofp.cz12a_c8r32 3906 0 10715 167.4 16427.2 477.4 2.743 43.890 4.205 125.137 96583 29.0 24.726 594 148.9 179.8 25.4 0.050 3829 2980 my8043_rel_o2nofp.cz12a_c8r32 3968 0 10903 170.4 16728.2 486.3 2.748 43.962 4.216 125.498 96100 29.2 24.218 589 148.9 179.8 25.4 0.048 3925 3535 my8044_rel_o2nofp.cz12a_c8r32 3891 0 10709 167.3 16460.2 479.0 2.752 44.036 4.230 126.052 98132 29.2 25.220 600 148.8 217.4 25.4 0.041 3840 3140 my8406_rel_o2nofp.cz12a_c8r32 4000 0 10852 169.6 16704.9 484.9 2.713 43.408 4.176 124.136 97172 29.6 24.293 592 148.9 217.5 25.4 0.044 3925 3545 my8407_rel_o2nofp.cz12a_c8r32 4255 0 11644 181.9 15866.4 275.1 2.736 43.779 3.729 66.204 111356 30.9 26.169 581 148.8 217.4 25.3 0.106 4155 3730 my8407_rel_o2nofp.cz12a_dw0_c8r32 3861 0 10658 166.5 16315.4 474.5 2.760 44.165 4.226 125.843 95973 28.9 24.857 599 148.9 217.5 24.5 0.052 3805 3375 my9400_rel_o2nofp.cz12a_c8r32 3802 0 10686 167.0 16372.4 475.2 2.811 44.968 4.306 127.973 96428 29.4 25.361 619 148.8 217.4 25.5 0.031 3750 3435 my9500_rel_o2nofp.cz12a_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 9866.7 149567 0.000 0.000 0.118 15.16 15550.4 374683 10.42 0.067 0.041 24.10 0.038 1.467 0.000 0.000 0.100 3.867 3.769 3.050 1.797 75.27 my5651_rel_o2nofp.cz12a_c8r32 15697.2 251155 0.000 0.000 0.176 16.00 21560.0 636728 19.36 0.090 0.117 29.53 0.032 0.320 0.000 0.000 0.130 1.280 6.420 3.680 5.259 81.04 my5744_rel_o2nofp.cz12a_c8r32 10703.7 171258 0.000 0.000 0.194 16.00 16420.6 488625 21.40 0.131 2.136 29.76 0.008 0.032 0.000 0.000 0.020 0.080 5.656 4.421 37.05 69.25 my8043_rel_o2nofp.cz12a_c8r32 10892.1 174272 0.000 0.000 0.174 16.00 16723.9 497891 12.16 0.072 1.894 29.77 0.008 0.033 0.000 0.000 0.020 0.082 5.682 4.022 33.57 69.69 my8044_rel_o2nofp.cz12a_c8r32 10699.7 171194 0.000 0.000 0.168 16.00 16432.2 489711 38.39 0.233 2.240 29.80 0.000 0.000 0.000 0.000 0.000 0.000 5.684 4.285 38.59 69.30 my8406_rel_o2nofp.cz12a_c8r32 10846.8 173548 0.000 0.000 0.158 16.00 16689.7 496121 26.98 0.161 2.025 29.72 0.008 0.473 0.000 0.000 0.010 1.184 5.910 4.065 35.54 69.45 my8407_rel_o2nofp.cz12a_c8r32 11636.2 186177 0.000 0.000 0.140 16.00 15853.2 281417 2.461 0.017 4.933 17.75 0.009 1.009 0.000 0.000 0.011 2.522 4.387 4.553 79.71 65.84 my8407_rel_o2nofp.cz12a_dw0_c8r32 10650.3 170404 0.000 0.000 0.175 16.00 16309.1 485680 2.412 0.016 2.055 29.78 0.000 0.000 0.000 0.000 0.000 0.000 5.656 4.239 35.41 68.86 my9400_rel_o2nofp.cz12a_c8r32 10675.7 170810 0.000 0.000 0.170 16.00 16359.0 486209 14.15 0.087 2.060 29.72 0.000 0.000 0.000 0.000 0.000 0.000 5.447 4.157 35.54 68.53 my9500_rel_o2nofp.cz12a_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 99.759 | 0.205 | 0.026 | 0.009 | nonzero | 0.032 | |||||
| my5744_rel_o2nofp.cz12a_c8r32 | 99.917 | 0.074 | 0.004 | 0.005 | 0.011 | ||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 99.980 | 0.019 | nonzero | 0.001 | 0.012 | ||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 99.981 | 0.018 | nonzero | nonzero | 0.009 | ||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 99.978 | 0.021 | nonzero | nonzero | 0.012 | ||||||
| my8407_rel_o2nofp.cz12a_c8r32 | 99.979 | 0.020 | nonzero | nonzero | 0.010 | ||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 99.976 | 0.022 | nonzero | 0.001 | 0.011 | ||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 99.979 | 0.020 | nonzero | 0.001 | 0.012 | ||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 99.980 | 0.020 | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 47.500 | 51.083 | 1.417 | 0.131 | |||||||
| my5744_rel_o2nofp.cz12a_c8r32 | 78.778 | 21.222 | 0.022 | ||||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 55.306 | 44.694 | 0.025 | ||||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 65.722 | 34.278 | 0.027 | ||||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 55.750 | 44.250 | 0.028 | ||||||||
| my8407_rel_o2nofp.cz12a_c8r32 | 68.194 | 31.806 | 0.027 | ||||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 58.722 | 41.278 | 0.027 | ||||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 58.889 | 41.111 | 0.027 | ||||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 57.111 | 42.889 | 0.027 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 1.250 | 14.972 | 75.611 | 7.889 | 0.278 | 0.101 | |||||
| my5744_rel_o2nofp.cz12a_c8r32 | 31.917 | 67.333 | 0.750 | 0.012 | |||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 90.083 | 9.917 | 0.012 | ||||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 92.194 | 7.806 | 0.012 | ||||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 90.139 | 9.861 | 0.011 | ||||||||
| my8407_rel_o2nofp.cz12a_c8r32 | 92.972 | 7.028 | 0.011 | ||||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 90.500 | 9.500 | 0.011 | ||||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 90.583 | 9.417 | 0.012 | ||||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 90.861 | 9.111 | 0.028 | 0.021 |
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 12027 468 7.3 1112.3 31.2 0.039 0.618 11.135 320.022 70529 12.1 5.864 80 144.5 175.0 24.7 0.032 12126 10719 my5651_rel_o2nofp.cz12a_c8r32 100 10067 466 7.3 286.0 8.3 0.046 0.740 2.860 85.385 58593 12.6 5.820 100 144.6 175.1 25.1 0.011 10127 9375 my5744_rel_o2nofp.cz12a_c8r32 100 9065 419 6.5 308.6 8.9 0.046 0.739 3.086 91.416 53700 12.9 5.924 114 148.9 179.8 25.3 0.012 9071 8943 my8043_rel_o2nofp.cz12a_c8r32 100 9115 417 6.5 305.0 8.8 0.046 0.732 3.050 90.362 53993 12.7 5.923 111 148.9 179.8 25.3 0.009 9119 8943 my8044_rel_o2nofp.cz12a_c8r32 100 8763 418 6.5 305.7 8.9 0.048 0.764 3.060 90.773 52035 12.4 5.938 113 148.8 217.4 25.4 0.012 8767 8639 my8406_rel_o2nofp.cz12a_c8r32 100 8850 418 6.5 306.8 8.9 0.047 0.755 3.068 90.764 52489 13.4 5.931 121 148.9 217.5 25.4 0.010 8863 8703 my8407_rel_o2nofp.cz12a_c8r32 100 8723 418 6.5 272.9 4.8 0.048 0.768 2.731 49.287 51760 13.4 5.934 123 148.8 217.4 25.3 0.011 8735 8543 my8407_rel_o2nofp.cz12a_dw0_c8r32 100 9075 418 6.5 306.0 8.9 0.046 0.737 3.063 90.972 53787 13.2 5.927 116 148.9 217.5 24.5 0.012 9087 8943 my9400_rel_o2nofp.cz12a_c8r32 100 9080 419 6.5 312.9 9.0 0.046 0.738 3.132 92.563 53837 12.9 5.929 114 148.8 217.4 25.5 0.012 9103 8911 my9500_rel_o2nofp.cz12a_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 448.5 7120.9 0.000 0.000 0.673 15.87 1111.6 31947.8 6.544 7.080 1.122 42.03 0.000 0.000 0.000 0.000 0.000 0.000 2.860 1.464 0.363 6.294 my5651_rel_o2nofp.cz12a_c8r32 446.4 7141.9 0.000 0.000 2.070 16.00 283.4 8465.4 3.811 2.158 0.263 30.87 0.000 0.000 0.000 0.000 0.000 0.000 1.403 1.629 0.922 4.131 my5744_rel_o2nofp.cz12a_c8r32 416.2 6659.4 0.000 0.000 0.925 16.00 306.0 9066.7 0.993 0.490 0.148 30.42 0.000 0.000 0.000 0.000 0.000 0.000 2.233 1.680 0.441 4.038 my8043_rel_o2nofp.cz12a_c8r32 414.5 6631.9 0.000 0.000 0.698 16.00 302.2 8956.0 0.942 0.484 0.524 30.41 0.000 0.000 0.000 0.000 0.000 0.000 2.208 1.887 0.407 5.886 my8044_rel_o2nofp.cz12a_c8r32 415.9 6654.7 0.000 0.000 0.898 16.00 303.1 8994.2 1.130 0.535 0.139 30.46 0.000 0.000 0.000 0.000 0.000 0.000 2.180 1.671 0.423 4.069 my8406_rel_o2nofp.cz12a_c8r32 414.8 6637.4 0.000 0.000 0.622 16.00 304.6 9011.5 1.051 0.519 0.541 30.37 0.000 0.000 0.000 0.000 0.000 0.000 2.328 1.806 0.385 6.280 my8407_rel_o2nofp.cz12a_c8r32 415.9 6654.0 0.000 0.000 0.999 16.00 270.5 4887.0 0.856 0.521 0.297 19.44 0.000 0.000 0.000 0.000 0.000 0.000 1.778 1.899 0.485 4.610 my8407_rel_o2nofp.cz12a_dw0_c8r32 415.6 6649.1 0.000 0.000 1.018 16.00 303.4 9014.9 0.903 0.490 0.225 30.56 0.000 0.000 0.000 0.000 0.000 0.000 1.774 1.854 0.485 4.527 my9400_rel_o2nofp.cz12a_c8r32 416.3 6660.3 0.000 0.000 0.794 16.00 310.3 9172.2 1.017 0.510 0.171 30.34 0.000 0.000 0.000 0.000 0.000 0.000 2.603 1.795 0.392 4.039 my9500_rel_o2nofp.cz12a_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 0.159 | 98.393 | 1.442 | 0.005 | 0.011 | ||||||
| my5744_rel_o2nofp.cz12a_c8r32 | 0.118 | 94.857 | 4.981 | 0.044 | 0.015 | ||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 0.009 | 94.497 | 5.379 | 0.115 | 0.016 | ||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 0.010 | 93.790 | 6.098 | 0.103 | nonzero | 0.025 | |||||
| my8406_rel_o2nofp.cz12a_c8r32 | 0.009 | 92.716 | 7.155 | 0.121 | 0.014 | ||||||
| my8407_rel_o2nofp.cz12a_c8r32 | 0.008 | 92.662 | 7.275 | 0.056 | 0.014 | ||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 0.010 | 92.718 | 7.264 | 0.009 | 0.016 | ||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 0.009 | 91.696 | 8.173 | 0.123 | nonzero | 0.016 | |||||
| my9500_rel_o2nofp.cz12a_c8r32 | 0.008 | 92.875 | 6.996 | 0.120 | nonzero | 0.018 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 47.611 | 52.389 | 0.054 | ||||||||
| my5744_rel_o2nofp.cz12a_c8r32 | 75.250 | 24.750 | 0.039 | ||||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 92.944 | 7.056 | 0.031 | ||||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 97.694 | 2.306 | 0.022 | ||||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 92.111 | 7.889 | 0.049 | ||||||||
| my8407_rel_o2nofp.cz12a_c8r32 | 98.944 | 1.056 | 0.038 | ||||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 99.611 | 0.389 | 0.034 | ||||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 92.778 | 7.222 | 0.049 | ||||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 94.361 | 5.639 | 0.045 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 0.222 | 88.167 | 11.056 | 0.556 | 0.025 | ||||||
| my5744_rel_o2nofp.cz12a_c8r32 | 99.917 | 0.083 | 0.005 | ||||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 99.833 | 0.167 | 0.007 | ||||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 99.750 | 0.250 | 0.005 | ||||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 99.750 | 0.250 | 0.006 | ||||||||
| my8407_rel_o2nofp.cz12a_c8r32 | 99.750 | 0.250 | 0.010 | ||||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 99.944 | 0.028 | 0.028 | 0.036 | |||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 99.694 | 0.306 | 0.006 | ||||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 99.750 | 0.222 | 0.028 | 0.046 |
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 1471 9971 155.7 1051.4 29.3 6.778 108.418 10.524 299.980 28281 3.9 19.226 212 144.5 175.0 24.7 0.011 1552 1024 my5651_rel_o2nofp.cz12a_c8r32 100 1351 9293 145.2 1410.5 35.1 6.879 110.069 14.105 358.969 27635 4.6 20.456 272 144.6 175.1 25.1 0.015 1408 992 my5744_rel_o2nofp.cz12a_c8r32 100 1299 9003 140.7 1290.3 36.0 6.931 110.895 12.916 368.786 27374 4.8 21.075 296 148.9 179.8 25.3 0.016 1360 944 my8043_rel_o2nofp.cz12a_c8r32 100 1289 8967 140.1 1276.7 35.7 6.957 111.308 12.767 365.175 27189 5.7 21.093 354 148.9 179.8 25.3 0.025 1360 944 my8044_rel_o2nofp.cz12a_c8r32 100 1274 8856 138.4 1282.8 35.8 6.954 111.264 12.840 367.404 27167 4.9 21.333 308 148.8 217.5 25.3 0.014 1344 928 my8406_rel_o2nofp.cz12a_c8r32 100 1279 8908 139.2 1276.0 35.6 6.966 111.449 12.760 364.706 26681 5.6 20.864 350 148.9 217.5 25.4 0.014 1344 928 my8407_rel_o2nofp.cz12a_c8r32 100 1283 8932 139.6 1127.7 18.2 6.964 111.430 11.289 186.309 26434 5.6 20.610 349 148.8 217.4 25.3 0.016 1344 944 my8407_rel_o2nofp.cz12a_dw0_c8r32 100 1269 8827 137.9 1280.7 35.7 6.956 111.299 12.807 366.041 26933 5.0 21.224 315 148.9 217.5 24.5 0.016 1344 928 my9400_rel_o2nofp.cz12a_c8r32 100 1275 8882 138.8 1280.4 35.6 6.964 111.425 12.816 365.242 27116 5.6 21.260 351 148.8 217.5 25.5 0.018 1344 944 my9500_rel_o2nofp.cz12a_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 9969.6 159464 0.000 0.000 0.070 15.99 1054.3 30049.5 2.905 8.881 0.313 53.87 0.000 0.000 0.000 0.000 0.000 0.000 1.209 1.352 0.752 70.89 my5651_rel_o2nofp.cz12a_c8r32 9292.1 148673 0.000 0.000 0.078 16.00 1394.2 35422.9 3.293 0.320 0.037 25.29 0.003 0.040 0.000 0.000 0.011 0.201 1.131 2.740 0.761 68.43 my5744_rel_o2nofp.cz12a_c8r32 9001.4 144022 0.000 0.000 0.077 16.00 1275.3 36417.5 3.241 0.251 0.889 28.64 0.000 0.000 0.000 0.000 0.000 0.000 2.510 2.394 1.696 65.42 my8043_rel_o2nofp.cz12a_c8r32 8966.0 143456 0.000 0.000 0.077 16.00 1260.8 36065.4 2.002 0.170 0.830 28.71 0.004 0.016 0.000 0.000 0.011 0.078 1.955 2.397 1.602 63.28 my8044_rel_o2nofp.cz12a_c8r32 8854.5 141672 0.000 0.000 0.078 16.00 1267.7 36275.3 5.034 0.367 1.044 28.70 0.001 0.007 0.000 0.000 0.001 0.017 2.526 2.384 1.859 64.28 my8406_rel_o2nofp.cz12a_c8r32 8906.2 142499 0.000 0.000 0.074 16.00 1259.8 36010.7 3.560 0.266 0.670 28.70 0.001 0.007 0.000 0.000 0.001 0.017 1.843 1.966 1.309 62.68 my8407_rel_o2nofp.cz12a_c8r32 8931.1 142898 0.000 0.000 0.070 16.00 1114.1 18394.2 0.821 0.099 0.037 16.69 0.001 0.007 0.000 0.000 0.001 0.017 2.564 1.556 0.718 62.42 my8407_rel_o2nofp.cz12a_dw0_c8r32 8826.1 141218 0.000 0.000 0.078 16.00 1265.7 36177.6 0.910 0.097 0.937 28.67 0.001 0.007 0.000 0.000 0.001 0.017 2.527 2.467 1.730 64.50 my9400_rel_o2nofp.cz12a_c8r32 8880.7 142090 0.000 0.000 0.078 16.00 1265.4 36064.7 2.513 0.210 1.017 28.59 0.001 0.007 0.000 0.000 0.001 0.017 2.604 2.451 1.796 63.07 my9500_rel_o2nofp.cz12a_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 99.061 | 0.826 | 0.101 | 0.013 | 0.011 | ||||||
| my5744_rel_o2nofp.cz12a_c8r32 | 99.892 | 0.079 | 0.018 | 0.011 | 0.011 | ||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 99.965 | 0.033 | 0.001 | 0.001 | 0.010 | ||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 99.967 | 0.032 | 0.001 | nonzero | 0.010 | ||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 99.959 | 0.039 | 0.001 | 0.001 | 0.009 | ||||||
| my8407_rel_o2nofp.cz12a_c8r32 | 99.964 | 0.035 | 0.001 | nonzero | 0.009 | ||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 99.958 | 0.041 | 0.001 | 0.001 | 0.012 | ||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 99.963 | 0.035 | 0.001 | 0.001 | 0.011 | ||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 99.964 | 0.034 | 0.001 | 0.001 | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 0.067 | 61.700 | 38.233 | 0.056 | |||||||
| my5744_rel_o2nofp.cz12a_c8r32 | 0.167 | 96.978 | 2.856 | 0.028 | |||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 92.800 | 7.200 | 0.030 | ||||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 93.511 | 6.483 | 0.006 | 0.318 | |||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 92.667 | 7.328 | 0.006 | 0.309 | |||||||
| my8407_rel_o2nofp.cz12a_c8r32 | 99.839 | 0.161 | 0.053 | ||||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 0.011 | 91.733 | 8.250 | 0.006 | 0.326 | ||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 91.844 | 8.156 | 0.027 | ||||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 92.144 | 7.850 | 0.006 | 0.345 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 2.672 | 7.344 | 88.867 | 1.117 | 0.028 | ||||||
| my5744_rel_o2nofp.cz12a_c8r32 | 30.089 | 69.678 | 0.233 | 0.013 | |||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 98.972 | 1.028 | 0.012 | ||||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 99.117 | 0.883 | 0.014 | ||||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 98.878 | 1.122 | 0.011 | ||||||||
| my8407_rel_o2nofp.cz12a_c8r32 | 99.967 | 0.028 | 0.006 | 0.052 | |||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 98.578 | 1.422 | 0.014 | ||||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 99.283 | 0.717 | 0.011 | ||||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 99.000 | 0.994 | 0.006 | 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 500 11348 2408 37.4 2379.5 68.5 0.212 3.379 4.762 140.294 72992 15.0 6.432 106 144.5 175.0 24.7 0.011 11439 9999 my5651_rel_o2nofp.cz12a_c8r32 500 9902 2377 37.1 2346.4 67.7 0.240 3.841 4.693 138.577 61762 14.3 6.237 116 144.6 175.1 25.1 0.011 9967 8383 my5744_rel_o2nofp.cz12a_c8r32 500 8951 2416 37.7 2466.0 71.0 0.270 4.318 4.935 145.491 61084 14.9 6.824 133 148.9 179.8 25.3 0.010 8959 8799 my8043_rel_o2nofp.cz12a_c8r32 500 9012 2412 37.7 2470.5 71.2 0.268 4.282 4.944 145.851 61428 15.4 6.816 137 148.9 179.8 25.3 0.010 9023 8879 my8044_rel_o2nofp.cz12a_c8r32 500 8658 2412 37.7 2461.5 71.0 0.279 4.457 4.923 145.412 59504 15.4 6.872 142 148.8 217.5 25.3 0.009 8671 8527 my8406_rel_o2nofp.cz12a_c8r32 500 8759 2413 37.7 2480.6 71.3 0.275 4.407 4.961 146.097 60016 15.4 6.852 141 148.9 217.6 25.3 0.009 8767 8639 my8407_rel_o2nofp.cz12a_c8r32 500 8673 2419 37.8 2198.2 37.5 0.279 4.462 4.396 76.755 59831 15.4 6.899 142 148.8 217.5 25.3 0.012 8687 8527 my8407_rel_o2nofp.cz12a_dw0_c8r32 500 9059 2412 37.7 2468.4 71.1 0.266 4.261 4.937 145.635 61885 15.2 6.831 134 148.9 217.6 24.5 0.011 9071 8927 my9400_rel_o2nofp.cz12a_c8r32 500 8965 2412 37.7 2478.9 71.2 0.269 4.304 4.961 145.920 61793 15.6 6.893 139 148.8 217.5 25.5 0.011 8975 8815 my9500_rel_o2nofp.cz12a_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 2383.1 37942.1 0.000 0.000 0.325 15.92 2384.7 70250.9 4.287 0.343 0.071 31.63 0.007 0.027 0.000 0.000 0.017 0.134 1.460 1.390 0.859 13.03 my5651_rel_o2nofp.cz12a_c8r32 2353.4 37654.9 0.000 0.000 0.686 16.00 2350.4 69407.1 4.328 0.264 0.065 30.09 0.003 0.033 0.000 0.000 0.011 0.167 1.530 1.726 1.673 12.01 my5744_rel_o2nofp.cz12a_c8r32 2409.9 38557.8 0.000 0.000 0.575 16.00 2471.8 72868.7 5.630 0.243 0.236 30.06 0.011 0.045 0.000 0.000 0.042 0.223 1.916 1.510 1.869 13.33 my8043_rel_o2nofp.cz12a_c8r32 2406.3 38500.2 0.000 0.000 0.517 16.00 2476.1 73044.6 3.346 0.152 0.343 30.09 0.006 0.025 0.000 0.000 0.022 0.123 2.049 1.637 1.895 13.88 my8044_rel_o2nofp.cz12a_c8r32 2406.2 38498.6 0.000 0.000 0.561 16.00 2467.1 72868.3 9.365 0.391 0.292 30.12 0.006 0.914 0.000 0.000 0.017 4.568 1.904 1.428 1.903 13.37 my8406_rel_o2nofp.cz12a_c8r32 2407.2 38515.5 0.000 0.000 0.430 16.00 2486.4 73214.7 6.686 0.280 0.374 30.04 0.003 0.027 0.000 0.000 0.011 0.134 2.426 1.761 1.790 13.28 my8407_rel_o2nofp.cz12a_c8r32 2413.1 38609.4 0.000 0.000 0.529 16.00 2203.2 38459.9 0.890 0.055 0.142 18.24 0.000 0.000 0.000 0.000 0.000 0.000 2.874 1.612 1.556 11.48 my8407_rel_o2nofp.cz12a_dw0_c8r32 2406.9 38510.4 0.000 0.000 0.590 16.00 2474.0 72979.4 1.084 0.063 0.226 30.10 0.003 0.011 0.000 0.000 0.006 0.056 1.982 1.592 1.882 13.12 my9400_rel_o2nofp.cz12a_c8r32 2406.1 38497.3 0.000 0.000 0.493 16.00 2484.6 73079.5 3.988 0.179 0.281 29.98 0.000 0.000 0.000 0.000 0.000 0.000 2.785 1.695 1.737 12.81 my9500_rel_o2nofp.cz12a_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 0.011 | 81.780 | 17.988 | 0.220 | nonzero | 0.020 | |||||
| my5744_rel_o2nofp.cz12a_c8r32 | 0.005 | 82.675 | 17.012 | 0.308 | 0.001 | 0.024 | |||||
| my8043_rel_o2nofp.cz12a_c8r32 | nonzero | 88.377 | 11.038 | 0.583 | 0.002 | 0.023 | |||||
| my8044_rel_o2nofp.cz12a_c8r32 | nonzero | 87.710 | 11.708 | 0.581 | 0.001 | 0.038 | |||||
| my8406_rel_o2nofp.cz12a_c8r32 | 0.001 | 85.183 | 14.224 | 0.591 | 0.002 | 0.025 | |||||
| my8407_rel_o2nofp.cz12a_c8r32 | nonzero | 85.994 | 13.403 | 0.601 | 0.001 | 0.023 | |||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | nonzero | 85.806 | 13.889 | 0.303 | 0.001 | 0.022 | |||||
| my9400_rel_o2nofp.cz12a_c8r32 | nonzero | 85.694 | 13.697 | 0.607 | 0.002 | 0.029 | |||||
| my9500_rel_o2nofp.cz12a_c8r32 | nonzero | 85.798 | 13.601 | 0.599 | 0.002 | nonzero | 0.128 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 0.006 | 53.756 | 44.156 | 2.083 | 0.095 | ||||||
| my5744_rel_o2nofp.cz12a_c8r32 | 0.006 | 89.361 | 10.628 | 0.006 | 0.077 | ||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 98.439 | 1.561 | 0.059 | ||||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 89.972 | 10.028 | 0.057 | ||||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 93.133 | 6.867 | 0.047 | ||||||||
| my8407_rel_o2nofp.cz12a_c8r32 | 93.217 | 6.783 | 0.046 | ||||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 93.572 | 6.428 | 0.035 | ||||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 94.839 | 5.161 | 0.058 | ||||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 93.239 | 6.761 | 0.047 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 0.067 | 21.783 | 62.294 | 15.844 | 0.011 | 0.065 | |||||
| my5744_rel_o2nofp.cz12a_c8r32 | 0.644 | 99.056 | 0.300 | 0.012 | |||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 99.861 | 0.139 | 0.015 | ||||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 99.917 | 0.078 | 0.006 | 0.017 | |||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 99.889 | 0.111 | 0.009 | ||||||||
| my8407_rel_o2nofp.cz12a_c8r32 | 99.617 | 0.378 | 0.006 | 0.017 | |||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 99.417 | 0.578 | 0.006 | 0.021 | |||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 99.867 | 0.128 | 0.006 | 0.019 | |||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 99.883 | 0.111 | 0.006 | 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 500 1145 11219 175.1 4112.1 113.2 9.798 156.577 8.229 232.056 32298 9.2 28.208 643 144.5 175.0 24.7 0.020 1168 800 my5651_rel_o2nofp.cz12a_c8r32 500 1110 11052 172.7 4533.6 111.1 9.953 159.251 9.073 227.608 33894 6.7 30.524 483 144.6 175.1 25.1 0.024 1120 832 my5744_rel_o2nofp.cz12a_c8r32 500 1130 11197 175.0 4024.7 113.8 9.906 158.503 8.049 233.163 38177 7.6 33.776 538 148.9 179.8 25.3 0.023 1168 944 my8043_rel_o2nofp.cz12a_c8r32 500 1128 11173 174.6 4026.6 114.0 9.909 158.548 8.058 233.597 38289 7.8 33.960 553 148.9 179.8 25.3 0.038 1152 928 my8044_rel_o2nofp.cz12a_c8r32 500 1110 11059 172.8 4017.2 113.9 9.963 159.413 8.034 233.258 38510 7.7 34.694 555 148.8 217.6 25.3 0.025 1136 928 my8406_rel_o2nofp.cz12a_c8r32 500 1117 11089 173.3 4035.6 114.1 9.928 158.851 8.071 233.686 38611 7.8 34.570 559 148.9 217.7 25.3 0.023 1152 928 my8407_rel_o2nofp.cz12a_c8r32 500 1137 11242 175.7 3566.2 58.8 9.888 158.201 7.132 120.400 37253 7.7 32.764 542 148.8 217.6 25.3 0.022 1168 928 my8407_rel_o2nofp.cz12a_dw0_c8r32 500 1112 11078 173.1 4021.7 113.9 9.958 159.336 8.043 233.222 38227 7.7 34.364 554 148.9 217.7 24.5 0.029 1136 928 my9400_rel_o2nofp.cz12a_c8r32 500 1115 11082 173.2 4037.5 114.0 9.935 158.965 8.075 233.436 38360 7.8 34.391 559 148.8 217.6 25.5 0.128 1152 912 my9500_rel_o2nofp.cz12a_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 11223.2 179352 0.000 0.000 0.076 15.98 4096.3 115716 4.256 0.109 0.042 28.75 0.007 0.027 0.000 0.000 0.019 0.134 1.486 2.368 1.031 71.48 my5651_rel_o2nofp.cz12a_c8r32 11052.5 176840 0.000 0.000 0.087 16.00 4520.9 113370 4.521 0.101 0.059 25.44 0.003 0.033 0.000 0.000 0.014 0.167 1.842 3.096 1.237 73.36 my5744_rel_o2nofp.cz12a_c8r32 11198.4 179175 0.000 0.000 0.084 16.00 4011.4 116205 9.441 0.235 1.284 28.99 0.003 0.011 0.000 0.000 0.006 0.056 2.588 2.784 5.909 71.66 my8043_rel_o2nofp.cz12a_c8r32 11174.0 178784 0.000 0.000 0.085 16.00 4014.0 116374 5.229 0.131 1.327 29.01 0.003 0.013 0.000 0.000 0.008 0.067 2.359 2.858 6.094 69.38 my8044_rel_o2nofp.cz12a_c8r32 11060.3 176965 0.000 0.000 0.084 16.00 4003.4 116237 16.28 0.405 1.474 29.05 0.019 3.198 0.000 0.000 0.061 15.99 2.401 2.754 6.614 70.57 my8406_rel_o2nofp.cz12a_c8r32 11089.7 177435 0.000 0.000 0.085 16.00 4021.5 116445 11.31 0.280 1.435 28.97 0.010 0.080 0.000 0.000 0.042 0.401 2.587 2.903 6.523 69.11 my8407_rel_o2nofp.cz12a_c8r32 11243.1 179890 0.000 0.000 0.079 16.00 3553.5 59998.8 0.896 0.025 1.208 16.91 0.004 0.452 0.000 0.000 0.025 2.262 2.496 2.883 4.944 68.00 my8407_rel_o2nofp.cz12a_dw0_c8r32 11078.9 177262 0.000 0.000 0.085 16.00 4007.8 116219 1.152 0.030 1.428 29.02 0.008 0.031 0.000 0.000 0.036 0.156 2.467 2.971 6.440 70.70 my9400_rel_o2nofp.cz12a_c8r32 11082.9 177326 0.000 0.000 0.084 16.00 4024.8 116359 6.599 0.165 1.456 28.93 0.004 0.203 0.000 0.000 0.011 1.014 2.563 2.939 6.582 69.37 my9500_rel_o2nofp.cz12a_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 98.144 | 1.650 | 0.192 | 0.014 | 0.016 | ||||||
| my5744_rel_o2nofp.cz12a_c8r32 | 99.877 | 0.098 | 0.014 | 0.011 | 0.012 | ||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 99.946 | 0.052 | 0.002 | 0.001 | 0.010 | ||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 99.948 | 0.050 | 0.002 | nonzero | 0.010 | ||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 99.937 | 0.061 | 0.002 | 0.001 | 0.010 | ||||||
| my8407_rel_o2nofp.cz12a_c8r32 | 99.940 | 0.058 | 0.002 | 0.001 | 0.009 | ||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 99.938 | 0.059 | 0.002 | 0.001 | 0.011 | ||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 99.945 | 0.053 | 0.002 | nonzero | nonzero | 0.036 | |||||
| my9500_rel_o2nofp.cz12a_c8r32 | 99.943 | 0.055 | 0.002 | nonzero | 0.009 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 0.239 | 73.417 | 26.311 | 0.033 | 0.094 | ||||||
| my5744_rel_o2nofp.cz12a_c8r32 | 0.775 | 98.764 | 0.461 | 0.036 | |||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 0.067 | 97.589 | 2.344 | 0.050 | |||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 0.053 | 98.231 | 1.717 | 0.032 | |||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 0.044 | 98.106 | 1.850 | 0.035 | |||||||
| my8407_rel_o2nofp.cz12a_c8r32 | 0.022 | 97.731 | 2.247 | 0.033 | |||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 0.061 | 97.378 | 2.561 | 0.046 | |||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 0.022 | 98.494 | 1.483 | 0.041 | |||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 0.044 | 98.469 | 1.486 | 0.035 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 0.450 | 28.556 | 69.825 | 1.169 | 0.041 | ||||||
| my5744_rel_o2nofp.cz12a_c8r32 | 13.308 | 84.708 | 1.983 | 0.015 | |||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 99.606 | 0.394 | 0.012 | ||||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 99.667 | 0.333 | 0.011 | ||||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 99.775 | 0.225 | 0.011 | ||||||||
| my8407_rel_o2nofp.cz12a_c8r32 | 99.744 | 0.256 | 0.011 | ||||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 99.617 | 0.375 | 0.008 | 0.034 | |||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 99.639 | 0.353 | 0.008 | 0.039 | |||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 99.775 | 0.219 | 0.006 | 0.038 |
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 10547 4290 66.6 5092.2 145.5 0.407 6.467 5.095 149.086 75136 17.7 7.124 134 144.5 175.0 24.7 0.016 10687 7775 my5651_rel_o2nofp.cz12a_c8r32 999 9779 4240 66.2 5157.8 147.4 0.434 6.937 5.161 151.017 66282 17.2 6.778 141 144.6 175.1 25.1 0.012 9855 8415 my5744_rel_o2nofp.cz12a_c8r32 1000 8896 4245 66.3 5217.8 149.3 0.477 7.635 5.218 152.881 70492 17.7 7.924 159 148.9 179.8 25.3 0.010 8911 8735 my8043_rel_o2nofp.cz12a_c8r32 1000 8965 4244 66.3 5206.1 149.1 0.473 7.574 5.206 152.674 70734 18.5 7.890 165 148.9 179.8 25.3 0.010 8975 8799 my8044_rel_o2nofp.cz12a_c8r32 1000 8618 4247 66.4 5205.3 149.2 0.493 7.885 5.205 152.773 68785 17.9 7.982 166 148.8 217.8 25.3 0.010 8623 8447 my8406_rel_o2nofp.cz12a_c8r32 1000 8612 4250 66.4 5226.2 149.4 0.493 7.895 5.226 153.028 68764 18.4 7.985 171 148.9 217.9 25.3 0.009 8623 8463 my8407_rel_o2nofp.cz12a_c8r32 1000 8622 4246 66.3 4622.3 77.7 0.492 7.878 4.622 79.572 69043 18.2 8.007 169 148.8 217.8 25.3 0.011 8639 8447 my8407_rel_o2nofp.cz12a_dw0_c8r32 1000 8953 4247 66.4 5213.8 149.3 0.474 7.590 5.214 152.871 71036 17.9 7.935 160 148.9 217.8 24.5 0.036 8959 8783 my9400_rel_o2nofp.cz12a_c8r32 1000 8894 4248 66.4 5222.1 149.2 0.478 7.642 5.222 152.800 70301 18.6 7.904 167 148.8 217.8 25.5 0.009 8911 8735 my9500_rel_o2nofp.cz12a_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 4268.2 67864.5 0.000 0.000 0.173 15.90 5087.3 148857 6.525 0.130 0.034 29.34 0.014 0.058 0.000 0.000 0.042 0.290 2.240 1.504 0.892 21.93 my5651_rel_o2nofp.cz12a_c8r32 4217.2 67475.5 0.000 0.000 0.357 16.00 5161.9 151046 5.646 0.112 0.048 29.32 0.002 0.027 0.000 0.000 0.006 0.134 2.170 1.514 1.713 18.95 my5744_rel_o2nofp.cz12a_c8r32 4240.1 67842.1 0.000 0.000 0.408 16.00 5226.3 153126 9.270 0.181 0.243 29.37 0.001 0.004 0.000 0.000 0.003 0.022 2.237 1.330 2.799 21.19 my8043_rel_o2nofp.cz12a_c8r32 4238.7 67818.9 0.000 0.000 0.317 16.00 5214.5 152914 5.220 0.103 0.268 29.39 0.001 0.004 0.000 0.000 0.003 0.022 2.238 1.456 2.563 21.39 my8044_rel_o2nofp.cz12a_c8r32 4241.8 67868.4 0.000 0.000 0.287 16.00 5213.9 153019 16.56 0.322 0.273 29.41 0.020 3.113 0.000 0.000 0.045 15.24 2.280 1.347 2.559 21.74 my8406_rel_o2nofp.cz12a_c8r32 4244.5 67912.4 0.000 0.000 0.381 16.00 5235.3 153289 11.53 0.224 0.257 29.34 0.017 0.136 0.000 0.000 0.042 0.643 2.219 1.358 2.781 21.23 my8407_rel_o2nofp.cz12a_c8r32 4239.9 67838.5 0.000 0.000 0.442 16.00 4630.4 79701.5 0.997 0.024 0.158 17.30 0.008 0.782 0.000 0.000 0.029 3.673 2.245 1.661 2.438 20.30 my8407_rel_o2nofp.cz12a_dw0_c8r32 4242.0 67871.1 0.000 0.000 0.303 16.00 5222.4 153119 1.182 0.025 0.279 29.39 0.013 0.056 0.000 0.000 0.039 0.249 2.298 1.503 2.512 21.63 my9400_rel_o2nofp.cz12a_c8r32 4242.7 67883.4 0.000 0.000 0.274 16.00 5230.7 153044 6.422 0.126 0.300 29.32 0.013 0.615 0.000 0.000 0.045 2.956 2.345 1.560 2.538 21.89 my9500_rel_o2nofp.cz12a_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | nonzero | 48.812 | 50.301 | 0.885 | 0.001 | 0.033 | |||||
| my5744_rel_o2nofp.cz12a_c8r32 | nonzero | 75.463 | 23.835 | 0.700 | 0.001 | 0.026 | |||||
| my8043_rel_o2nofp.cz12a_c8r32 | nonzero | 77.005 | 21.917 | 1.070 | 0.008 | 0.029 | |||||
| my8044_rel_o2nofp.cz12a_c8r32 | 75.943 | 22.987 | 1.063 | 0.007 | 0.028 | ||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 72.457 | 26.454 | 1.080 | 0.008 | nonzero | 0.069 | |||||
| my8407_rel_o2nofp.cz12a_c8r32 | 72.709 | 26.208 | 1.078 | 0.005 | 0.027 | ||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 73.019 | 26.498 | 0.475 | 0.008 | 0.045 | ||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 72.755 | 26.150 | 1.087 | 0.008 | 0.041 | ||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 72.809 | 26.106 | 1.079 | 0.006 | nonzero | 0.122 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 0.006 | 56.381 | 40.925 | 2.689 | 0.172 | ||||||
| my5744_rel_o2nofp.cz12a_c8r32 | 0.006 | 91.736 | 8.258 | 0.055 | |||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 0.003 | 93.578 | 6.414 | 0.006 | 0.065 | ||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 93.872 | 6.128 | 0.057 | ||||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 95.122 | 4.875 | 0.003 | 0.258 | |||||||
| my8407_rel_o2nofp.cz12a_c8r32 | 94.661 | 5.336 | 0.003 | 0.300 | |||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 97.792 | 2.208 | 0.049 | ||||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 94.944 | 5.047 | 0.006 | 0.003 | 0.444 | ||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 95.133 | 4.864 | 0.003 | 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 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| my5651_rel_o2nofp.cz12a_c8r32 | 0.303 | 33.011 | 49.806 | 16.850 | 0.031 | 0.090 | |||||
| my5744_rel_o2nofp.cz12a_c8r32 | 0.217 | 97.244 | 2.536 | 0.003 | 0.018 | ||||||
| my8043_rel_o2nofp.cz12a_c8r32 | 99.850 | 0.147 | 0.003 | 0.016 | |||||||
| my8044_rel_o2nofp.cz12a_c8r32 | 99.803 | 0.197 | 0.016 | ||||||||
| my8406_rel_o2nofp.cz12a_c8r32 | 99.725 | 0.264 | 0.008 | 0.003 | 0.257 | ||||||
| my8407_rel_o2nofp.cz12a_c8r32 | 99.814 | 0.181 | 0.003 | 0.003 | 0.300 | ||||||
| my8407_rel_o2nofp.cz12a_dw0_c8r32 | 99.842 | 0.153 | 0.006 | 0.041 | |||||||
| my9400_rel_o2nofp.cz12a_c8r32 | 99.772 | 0.225 | 0.003 | 0.026 | |||||||
| my9500_rel_o2nofp.cz12a_c8r32 | 99.864 | 0.128 | 0.008 | 0.046 |
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 856 12077 188.3 8946.4 180.6 14.107 225.216 8.952 185.090 45697 12.0 53.379 1121 144.5 175.0 24.7 0.033 848 720 my5651_rel_o2nofp.cz12a_c8r32 999 1001 13212 206.4 6860.8 181.9 13.204 211.259 6.865 186.377 37070 9.2 37.048 736 144.6 175.1 25.1 0.026 1008 864 my5744_rel_o2nofp.cz12a_c8r32 1000 1011 13266 207.3 6535.6 185.0 13.123 209.967 6.536 189.467 50566 10.5 50.021 831 148.9 179.8 25.3 0.029 1024 912 my8043_rel_o2nofp.cz12a_c8r32 1000 1010 13257 207.1 6532.4 185.1 13.132 210.115 6.532 189.574 50222 10.5 49.749 832 148.9 179.8 25.3 0.028 1024 928 my8044_rel_o2nofp.cz12a_c8r32 1000 996 13148 205.4 6510.7 184.8 13.207 211.317 6.511 189.209 51788 10.7 52.023 860 148.8 218.0 25.3 0.069 1008 912 my8406_rel_o2nofp.cz12a_c8r32 1000 999 13171 205.8 6531.0 184.8 13.190 211.034 6.531 189.258 50854 10.6 50.925 849 148.9 218.0 25.3 0.027 1008 912 my8407_rel_o2nofp.cz12a_c8r32 1000 1035 13451 210.2 5805.9 95.7 12.997 207.952 5.806 98.016 49490 10.5 47.821 812 148.8 217.9 25.3 0.045 1040 928 my8407_rel_o2nofp.cz12a_dw0_c8r32 1000 997 13162 205.7 6516.9 184.7 13.201 211.222 6.517 189.130 50715 10.6 50.867 851 148.9 218.0 24.5 0.041 1008 912 my9400_rel_o2nofp.cz12a_c8r32 1000 999 13174 205.8 6545.3 185.0 13.188 211.015 6.545 189.391 50819 10.7 50.875 857 148.8 218.0 25.5 0.122 1008 912 my9500_rel_o2nofp.cz12a_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 12081.6 192876 0.000 0.000 0.095 15.96 8930.4 184625 5.477 0.062 0.031 20.77 0.026 0.103 0.000 0.000 0.072 0.513 2.016 3.038 1.424 76.56 my5651_rel_o2nofp.cz12a_c8r32 13213.8 211421 0.000 0.000 0.096 16.00 6849.6 185997 6.064 0.090 0.070 27.25 0.002 0.027 0.000 0.000 0.006 0.134 2.126 3.100 1.752 77.70 my5744_rel_o2nofp.cz12a_c8r32 13268.7 212299 0.000 0.000 0.099 16.00 6524.9 189166 14.82 0.226 1.489 29.00 0.001 0.004 0.000 0.000 0.003 0.022 2.528 2.922 10.87 76.56 my8043_rel_o2nofp.cz12a_c8r32 13259.9 212159 0.000 0.000 0.097 16.00 6520.7 189245 7.914 0.122 1.426 29.03 0.002 0.007 0.000 0.000 0.003 0.033 2.548 2.908 10.46 74.63 my8044_rel_o2nofp.cz12a_c8r32 13150.7 210411 0.000 0.000 0.095 16.00 6498.2 188858 26.41 0.404 1.656 29.07 0.025 3.844 0.000 0.000 0.113 18.89 2.563 2.902 11.86 75.62 my8406_rel_o2nofp.cz12a_c8r32 13173.9 210782 0.000 0.000 0.093 16.00 6521.5 188994 17.93 0.274 1.604 28.99 0.020 0.158 0.000 0.000 0.074 0.754 2.508 2.878 11.55 74.33 my8407_rel_o2nofp.cz12a_c8r32 13454.0 215263 0.000 0.000 0.086 16.00 5797.1 97878.3 0.979 0.016 1.896 16.89 0.016 1.686 0.000 0.000 0.055 8.197 2.396 2.949 11.89 73.01 my8407_rel_o2nofp.cz12a_dw0_c8r32 13164.4 210631 0.000 0.000 0.094 16.00 6506.2 188829 1.168 0.018 1.603 29.03 0.010 0.042 0.000 0.000 0.028 0.182 2.519 2.971 11.53 75.57 my9400_rel_o2nofp.cz12a_c8r32 13176.8 210828 0.000 0.000 0.097 16.00 6532.8 189041 10.08 0.154 1.604 28.94 0.018 0.905 0.000 0.000 0.057 4.405 2.547 2.896 11.62 74.56 my9500_rel_o2nofp.cz12a_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 177148 0 1496 5.8 1159.6 63.5 0.008 0.034 0.007 0.367 23812 19.6 0.134 9 52.6 83.1 24.7 0.222 177976 143381 my5651_rel_o2nofp.cz12a_c8r32 160642 0 0 0.0 1063.3 57.8 0.000 0.000 0.007 0.369 18897 19.4 0.118 10 52.6 83.1 25.0 0.161 160578 149979 my5744_rel_o2nofp.cz12a_c8r32 109860 0 0 0.0 745.0 41.2 0.000 0.000 0.007 0.384 13601 17.2 0.124 13 52.4 83.0 25.3 0.341 109786 102585 my8043_rel_o2nofp.cz12a_c8r32 110072 0 0 0.0 746.5 41.3 0.000 0.000 0.007 0.384 13604 17.2 0.124 13 52.4 83.0 25.3 0.334 110082 102785 my8044_rel_o2nofp.cz12a_c8r32 108006 0 0 0.0 732.5 40.5 0.000 0.000 0.007 0.384 13387 17.2 0.124 13 52.4 120.1 25.3 0.340 107987 100687 my8406_rel_o2nofp.cz12a_c8r32 105416 0 0 0.0 715.5 39.6 0.000 0.000 0.007 0.384 13046 17.2 0.124 13 52.4 120.1 25.3 0.337 105288 98187 my8407_rel_o2nofp.cz12a_c8r32 108533 0 0 0.0 677.8 33.6 0.000 0.000 0.006 0.317 13271 17.2 0.122 13 52.4 120.1 25.2 0.347 108585 100985 my8407_rel_o2nofp.cz12a_dw0_c8r32 108430 0 0 0.0 735.6 40.7 0.000 0.000 0.007 0.384 13422 17.2 0.124 13 52.4 120.1 25.3 0.318 108386 101387 my9400_rel_o2nofp.cz12a_c8r32 106482 0 0 0.0 730.4 40.4 0.000 0.000 0.007 0.388 14060 17.2 0.132 13 52.4 120.1 25.4 0.325 106485 98787 my9500_rel_o2nofp.cz12a_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 112233 0 1216 111.6 1791.4 145.3 0.011 1.019 0.016 1.325 2299 10.1 0.020 7 111.4 141.9 24.8 0.004 NA NA my5651_rel_o2nofp.cz12a_c8r32 159077 0 1677 155.8 2412.2 189.5 0.011 1.003 0.015 1.220 8900 11.6 0.056 6 121.1 151.7 25.1 0.001 NA NA my5744_rel_o2nofp.cz12a_c8r32 293578 0 4074 400.3 8863.5 447.7 0.014 1.396 0.030 1.562 20887 40.6 0.071 11 120.7 151.3 25.4 0.002 NA NA my8043_rel_o2nofp.cz12a_c8r32 289855 0 4016 395.3 8753.0 442.0 0.014 1.396 0.030 1.562 20348 41.5 0.070 11 120.7 151.3 25.4 0.002 NA NA my8044_rel_o2nofp.cz12a_c8r32 292826 0 4061 401.1 8843.8 446.9 0.014 1.403 0.030 1.563 20731 40.2 0.071 11 120.7 188.4 25.4 0.002 NA NA my8406_rel_o2nofp.cz12a_c8r32 297398 0 4121 407.3 8983.2 453.6 0.014 1.402 0.030 1.562 21046 41.5 0.071 11 120.7 188.4 25.4 0.001 NA NA my8407_rel_o2nofp.cz12a_c8r32 299738 0 4154 411.1 8841.7 434.6 0.014 1.404 0.029 1.485 21979 41.6 0.073 11 120.7 188.4 25.4 0.001 NA NA my8407_rel_o2nofp.cz12a_dw0_c8r32 300526 0 4115 401.0 9087.4 458.6 0.014 1.366 0.030 1.563 21351 41.2 0.071 11 120.7 188.4 25.4 0.002 NA NA my9400_rel_o2nofp.cz12a_c8r32 309119 0 4291 423.9 9351.9 471.9 0.014 1.404 0.030 1.563 21635 41.5 0.070 11 120.7 188.4 25.6 0.002 NA NA my9500_rel_o2nofp.cz12a_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 1975 0 9384 145.8 16394.7 382.2 4.751 75.581 8.300 198.112 45500 16.5 23.034 668 144.5 175.0 24.7 0.697 1850 1200 my5651_rel_o2nofp.cz12a_c8r32 3003 0 13870 216.7 18840.3 560.2 4.619 73.901 6.274 191.029 36919 22.2 12.294 591 144.6 175.1 25.1 0.113 3000 1600 my5744_rel_o2nofp.cz12a_c8r32 3077 0 11433 178.6 16737.9 503.5 3.716 59.453 5.440 167.563 76647 21.6 24.910 562 148.8 179.5 25.4 0.432 2900 1750 my8043_rel_o2nofp.cz12a_c8r32 3074 0 11435 178.7 16790.9 505.3 3.719 59.506 5.461 168.300 75710 21.7 24.625 565 148.8 179.6 25.4 0.474 2900 1750 my8044_rel_o2nofp.cz12a_c8r32 3051 0 11382 177.8 16681.4 502.3 3.730 59.687 5.467 168.586 78250 21.6 25.646 566 148.7 216.9 25.4 0.506 2900 1700 my8406_rel_o2nofp.cz12a_c8r32 3035 0 11308 176.7 16592.3 498.6 3.726 59.614 5.467 168.240 76794 21.6 25.304 569 148.7 217.1 25.4 0.500 2850 1700 my8407_rel_o2nofp.cz12a_c8r32 3308 0 12284 191.9 15972.1 298.2 3.713 59.405 4.828 92.304 89089 22.8 26.927 551 148.7 217.0 25.3 0.431 3150 1850 my8407_rel_o2nofp.cz12a_dw0_c8r32 2994 0 11170 174.5 16392.6 493.1 3.731 59.694 5.475 168.660 75995 21.4 25.383 572 148.7 217.0 24.5 0.477 2850 1650 my9400_rel_o2nofp.cz12a_c8r32 3026 0 11282 176.3 16545.3 497.1 3.729 59.659 5.468 168.228 76245 21.7 25.199 574 148.8 217.1 25.5 0.493 2850 1700 my9500_rel_o2nofp.cz12a_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 2198 0 9893 146.5 15586.5 366.3 4.501 68.240 7.092 170.668 59892 24.2 27.251 881 144.5 175.0 24.7 0.035 2190 1940 my5651_rel_o2nofp.cz12a_c8r32 3906 0 15695 245.2 21534.2 621.1 4.018 64.288 5.513 162.808 59863 31.0 15.325 635 144.6 175.1 25.1 0.039 3970 3055 my5744_rel_o2nofp.cz12a_c8r32 3906 0 10715 167.4 16427.2 477.4 2.743 43.890 4.205 125.137 96583 29.0 24.726 594 148.9 179.8 25.4 0.050 3829 2980 my8043_rel_o2nofp.cz12a_c8r32 3968 0 10903 170.4 16728.2 486.3 2.748 43.962 4.216 125.498 96100 29.2 24.218 589 148.9 179.8 25.4 0.048 3925 3535 my8044_rel_o2nofp.cz12a_c8r32 3891 0 10709 167.3 16460.2 479.0 2.752 44.036 4.230 126.052 98132 29.2 25.220 600 148.8 217.4 25.4 0.041 3840 3140 my8406_rel_o2nofp.cz12a_c8r32 4000 0 10852 169.6 16704.9 484.9 2.713 43.408 4.176 124.136 97172 29.6 24.293 592 148.9 217.5 25.4 0.044 3925 3545 my8407_rel_o2nofp.cz12a_c8r32 4255 0 11644 181.9 15866.4 275.1 2.736 43.779 3.729 66.204 111356 30.9 26.169 581 148.8 217.4 25.3 0.106 4155 3730 my8407_rel_o2nofp.cz12a_dw0_c8r32 3861 0 10658 166.5 16315.4 474.5 2.760 44.165 4.226 125.843 95973 28.9 24.857 599 148.9 217.5 24.5 0.052 3805 3375 my9400_rel_o2nofp.cz12a_c8r32 3802 0 10686 167.0 16372.4 475.2 2.811 44.968 4.306 127.973 96428 29.4 25.361 619 148.8 217.4 25.5 0.031 3750 3435 my9500_rel_o2nofp.cz12a_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 12027 468 7.3 1112.3 31.2 0.039 0.618 11.135 320.022 70529 12.1 5.864 80 144.5 175.0 24.7 0.032 12126 10719 my5651_rel_o2nofp.cz12a_c8r32 100 10067 466 7.3 286.0 8.3 0.046 0.740 2.860 85.385 58593 12.6 5.820 100 144.6 175.1 25.1 0.011 10127 9375 my5744_rel_o2nofp.cz12a_c8r32 100 9065 419 6.5 308.6 8.9 0.046 0.739 3.086 91.416 53700 12.9 5.924 114 148.9 179.8 25.3 0.012 9071 8943 my8043_rel_o2nofp.cz12a_c8r32 100 9115 417 6.5 305.0 8.8 0.046 0.732 3.050 90.362 53993 12.7 5.923 111 148.9 179.8 25.3 0.009 9119 8943 my8044_rel_o2nofp.cz12a_c8r32 100 8763 418 6.5 305.7 8.9 0.048 0.764 3.060 90.773 52035 12.4 5.938 113 148.8 217.4 25.4 0.012 8767 8639 my8406_rel_o2nofp.cz12a_c8r32 100 8850 418 6.5 306.8 8.9 0.047 0.755 3.068 90.764 52489 13.4 5.931 121 148.9 217.5 25.4 0.010 8863 8703 my8407_rel_o2nofp.cz12a_c8r32 100 8723 418 6.5 272.9 4.8 0.048 0.768 2.731 49.287 51760 13.4 5.934 123 148.8 217.4 25.3 0.011 8735 8543 my8407_rel_o2nofp.cz12a_dw0_c8r32 100 9075 418 6.5 306.0 8.9 0.046 0.737 3.063 90.972 53787 13.2 5.927 116 148.9 217.5 24.5 0.012 9087 8943 my9400_rel_o2nofp.cz12a_c8r32 100 9080 419 6.5 312.9 9.0 0.046 0.738 3.132 92.563 53837 12.9 5.929 114 148.8 217.4 25.5 0.012 9103 8911 my9500_rel_o2nofp.cz12a_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 1471 9971 155.7 1051.4 29.3 6.778 108.418 10.524 299.980 28281 3.9 19.226 212 144.5 175.0 24.7 0.011 1552 1024 my5651_rel_o2nofp.cz12a_c8r32 100 1351 9293 145.2 1410.5 35.1 6.879 110.069 14.105 358.969 27635 4.6 20.456 272 144.6 175.1 25.1 0.015 1408 992 my5744_rel_o2nofp.cz12a_c8r32 100 1299 9003 140.7 1290.3 36.0 6.931 110.895 12.916 368.786 27374 4.8 21.075 296 148.9 179.8 25.3 0.016 1360 944 my8043_rel_o2nofp.cz12a_c8r32 100 1289 8967 140.1 1276.7 35.7 6.957 111.308 12.767 365.175 27189 5.7 21.093 354 148.9 179.8 25.3 0.025 1360 944 my8044_rel_o2nofp.cz12a_c8r32 100 1274 8856 138.4 1282.8 35.8 6.954 111.264 12.840 367.404 27167 4.9 21.333 308 148.8 217.5 25.3 0.014 1344 928 my8406_rel_o2nofp.cz12a_c8r32 100 1279 8908 139.2 1276.0 35.6 6.966 111.449 12.760 364.706 26681 5.6 20.864 350 148.9 217.5 25.4 0.014 1344 928 my8407_rel_o2nofp.cz12a_c8r32 100 1283 8932 139.6 1127.7 18.2 6.964 111.430 11.289 186.309 26434 5.6 20.610 349 148.8 217.4 25.3 0.016 1344 944 my8407_rel_o2nofp.cz12a_dw0_c8r32 100 1269 8827 137.9 1280.7 35.7 6.956 111.299 12.807 366.041 26933 5.0 21.224 315 148.9 217.5 24.5 0.016 1344 928 my9400_rel_o2nofp.cz12a_c8r32 100 1275 8882 138.8 1280.4 35.6 6.964 111.425 12.816 365.242 27116 5.6 21.260 351 148.8 217.5 25.5 0.018 1344 944 my9500_rel_o2nofp.cz12a_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 11348 2408 37.4 2379.5 68.5 0.212 3.379 4.762 140.294 72992 15.0 6.432 106 144.5 175.0 24.7 0.011 11439 9999 my5651_rel_o2nofp.cz12a_c8r32 500 9902 2377 37.1 2346.4 67.7 0.240 3.841 4.693 138.577 61762 14.3 6.237 116 144.6 175.1 25.1 0.011 9967 8383 my5744_rel_o2nofp.cz12a_c8r32 500 8951 2416 37.7 2466.0 71.0 0.270 4.318 4.935 145.491 61084 14.9 6.824 133 148.9 179.8 25.3 0.010 8959 8799 my8043_rel_o2nofp.cz12a_c8r32 500 9012 2412 37.7 2470.5 71.2 0.268 4.282 4.944 145.851 61428 15.4 6.816 137 148.9 179.8 25.3 0.010 9023 8879 my8044_rel_o2nofp.cz12a_c8r32 500 8658 2412 37.7 2461.5 71.0 0.279 4.457 4.923 145.412 59504 15.4 6.872 142 148.8 217.5 25.3 0.009 8671 8527 my8406_rel_o2nofp.cz12a_c8r32 500 8759 2413 37.7 2480.6 71.3 0.275 4.407 4.961 146.097 60016 15.4 6.852 141 148.9 217.6 25.3 0.009 8767 8639 my8407_rel_o2nofp.cz12a_c8r32 500 8673 2419 37.8 2198.2 37.5 0.279 4.462 4.396 76.755 59831 15.4 6.899 142 148.8 217.5 25.3 0.012 8687 8527 my8407_rel_o2nofp.cz12a_dw0_c8r32 500 9059 2412 37.7 2468.4 71.1 0.266 4.261 4.937 145.635 61885 15.2 6.831 134 148.9 217.6 24.5 0.011 9071 8927 my9400_rel_o2nofp.cz12a_c8r32 500 8965 2412 37.7 2478.9 71.2 0.269 4.304 4.961 145.920 61793 15.6 6.893 139 148.8 217.5 25.5 0.011 8975 8815 my9500_rel_o2nofp.cz12a_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 1145 11219 175.1 4112.1 113.2 9.798 156.577 8.229 232.056 32298 9.2 28.208 643 144.5 175.0 24.7 0.020 1168 800 my5651_rel_o2nofp.cz12a_c8r32 500 1110 11052 172.7 4533.6 111.1 9.953 159.251 9.073 227.608 33894 6.7 30.524 483 144.6 175.1 25.1 0.024 1120 832 my5744_rel_o2nofp.cz12a_c8r32 500 1130 11197 175.0 4024.7 113.8 9.906 158.503 8.049 233.163 38177 7.6 33.776 538 148.9 179.8 25.3 0.023 1168 944 my8043_rel_o2nofp.cz12a_c8r32 500 1128 11173 174.6 4026.6 114.0 9.909 158.548 8.058 233.597 38289 7.8 33.960 553 148.9 179.8 25.3 0.038 1152 928 my8044_rel_o2nofp.cz12a_c8r32 500 1110 11059 172.8 4017.2 113.9 9.963 159.413 8.034 233.258 38510 7.7 34.694 555 148.8 217.6 25.3 0.025 1136 928 my8406_rel_o2nofp.cz12a_c8r32 500 1117 11089 173.3 4035.6 114.1 9.928 158.851 8.071 233.686 38611 7.8 34.570 559 148.9 217.7 25.3 0.023 1152 928 my8407_rel_o2nofp.cz12a_c8r32 500 1137 11242 175.7 3566.2 58.8 9.888 158.201 7.132 120.400 37253 7.7 32.764 542 148.8 217.6 25.3 0.022 1168 928 my8407_rel_o2nofp.cz12a_dw0_c8r32 500 1112 11078 173.1 4021.7 113.9 9.958 159.336 8.043 233.222 38227 7.7 34.364 554 148.9 217.7 24.5 0.029 1136 928 my9400_rel_o2nofp.cz12a_c8r32 500 1115 11082 173.2 4037.5 114.0 9.935 158.965 8.075 233.436 38360 7.8 34.391 559 148.8 217.6 25.5 0.128 1152 912 my9500_rel_o2nofp.cz12a_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 10547 4290 66.6 5092.2 145.5 0.407 6.467 5.095 149.086 75136 17.7 7.124 134 144.5 175.0 24.7 0.016 10687 7775 my5651_rel_o2nofp.cz12a_c8r32 999 9779 4240 66.2 5157.8 147.4 0.434 6.937 5.161 151.017 66282 17.2 6.778 141 144.6 175.1 25.1 0.012 9855 8415 my5744_rel_o2nofp.cz12a_c8r32 1000 8896 4245 66.3 5217.8 149.3 0.477 7.635 5.218 152.881 70492 17.7 7.924 159 148.9 179.8 25.3 0.010 8911 8735 my8043_rel_o2nofp.cz12a_c8r32 1000 8965 4244 66.3 5206.1 149.1 0.473 7.574 5.206 152.674 70734 18.5 7.890 165 148.9 179.8 25.3 0.010 8975 8799 my8044_rel_o2nofp.cz12a_c8r32 1000 8618 4247 66.4 5205.3 149.2 0.493 7.885 5.205 152.773 68785 17.9 7.982 166 148.8 217.8 25.3 0.010 8623 8447 my8406_rel_o2nofp.cz12a_c8r32 1000 8612 4250 66.4 5226.2 149.4 0.493 7.895 5.226 153.028 68764 18.4 7.985 171 148.9 217.9 25.3 0.009 8623 8463 my8407_rel_o2nofp.cz12a_c8r32 1000 8622 4246 66.3 4622.3 77.7 0.492 7.878 4.622 79.572 69043 18.2 8.007 169 148.8 217.8 25.3 0.011 8639 8447 my8407_rel_o2nofp.cz12a_dw0_c8r32 1000 8953 4247 66.4 5213.8 149.3 0.474 7.590 5.214 152.871 71036 17.9 7.935 160 148.9 217.8 24.5 0.036 8959 8783 my9400_rel_o2nofp.cz12a_c8r32 1000 8894 4248 66.4 5222.1 149.2 0.478 7.642 5.222 152.800 70301 18.6 7.904 167 148.8 217.8 25.5 0.009 8911 8735 my9500_rel_o2nofp.cz12a_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 856 12077 188.3 8946.4 180.6 14.107 225.216 8.952 185.090 45697 12.0 53.379 1121 144.5 175.0 24.7 0.033 848 720 my5651_rel_o2nofp.cz12a_c8r32 999 1001 13212 206.4 6860.8 181.9 13.204 211.259 6.865 186.377 37070 9.2 37.048 736 144.6 175.1 25.1 0.026 1008 864 my5744_rel_o2nofp.cz12a_c8r32 1000 1011 13266 207.3 6535.6 185.0 13.123 209.967 6.536 189.467 50566 10.5 50.021 831 148.9 179.8 25.3 0.029 1024 912 my8043_rel_o2nofp.cz12a_c8r32 1000 1010 13257 207.1 6532.4 185.1 13.132 210.115 6.532 189.574 50222 10.5 49.749 832 148.9 179.8 25.3 0.028 1024 928 my8044_rel_o2nofp.cz12a_c8r32 1000 996 13148 205.4 6510.7 184.8 13.207 211.317 6.511 189.209 51788 10.7 52.023 860 148.8 218.0 25.3 0.069 1008 912 my8406_rel_o2nofp.cz12a_c8r32 1000 999 13171 205.8 6531.0 184.8 13.190 211.034 6.531 189.258 50854 10.6 50.925 849 148.9 218.0 25.3 0.027 1008 912 my8407_rel_o2nofp.cz12a_c8r32 1000 1035 13451 210.2 5805.9 95.7 12.997 207.952 5.806 98.016 49490 10.5 47.821 812 148.8 217.9 25.3 0.045 1040 928 my8407_rel_o2nofp.cz12a_dw0_c8r32 1000 997 13162 205.7 6516.9 184.7 13.201 211.222 6.517 189.130 50715 10.6 50.867 851 148.9 218.0 24.5 0.041 1008 912 my9400_rel_o2nofp.cz12a_c8r32 1000 999 13174 205.8 6545.3 185.0 13.188 211.015 6.545 189.391 50819 10.7 50.875 857 148.8 218.0 25.5 0.122 1008 912 my9500_rel_o2nofp.cz12a_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.555 0.380 0.022 0.041 0.002 0.000 0.000 0.000 0.000 0.222 my5651_rel_o2nofp.cz12a_c8r32 0.000 99.711 0.115 0.059 0.114 0.001 0.000 0.000 0.000 0.000 0.161 my5744_rel_o2nofp.cz12a_c8r32 0.000 99.571 0.253 0.054 0.121 0.001 nonzero 0.000 0.000 0.000 0.341 my8043_rel_o2nofp.cz12a_c8r32 0.000 99.574 0.250 0.056 0.118 0.001 nonzero 0.000 0.000 0.000 0.334 my8044_rel_o2nofp.cz12a_c8r32 0.000 99.565 0.258 0.053 0.122 0.002 nonzero 0.000 0.000 0.000 0.340 my8406_rel_o2nofp.cz12a_c8r32 0.000 99.551 0.271 0.053 0.123 0.002 nonzero 0.000 0.000 0.000 0.337 my8407_rel_o2nofp.cz12a_c8r32 0.000 99.578 0.245 0.055 0.121 0.002 nonzero 0.000 0.000 0.000 0.347 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 99.569 0.256 0.116 0.057 0.001 nonzero 0.000 0.000 0.000 0.318 my9400_rel_o2nofp.cz12a_c8r32 0.000 99.494 0.330 0.085 0.089 0.002 nonzero 0.000 0.000 0.000 0.325 my9500_rel_o2nofp.cz12a_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 0.000 0.000 14.247 84.720 1.031 0.001 0.000 0.000 0.000 0.697 my5651_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 64.752 34.836 0.411 0.000 0.000 0.000 0.000 0.113 my5744_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.001 67.993 30.679 1.325 0.003 0.000 0.000 0.000 0.432 my8043_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 68.450 30.118 1.430 0.003 0.000 0.000 0.000 0.474 my8044_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.003 67.681 30.976 1.337 0.003 0.000 0.000 0.000 0.506 my8406_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.001 67.840 30.610 1.546 0.003 0.000 0.000 0.000 0.500 my8407_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.001 70.641 28.075 1.280 0.003 0.000 0.000 0.000 0.431 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 0.000 0.000 67.406 30.990 1.601 0.003 0.000 0.000 0.000 0.477 my9400_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 68.093 30.406 1.499 0.003 0.000 0.000 0.000 0.493 my9500_rel_o2nofp.cz12a_c8r32
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.024 94.983 4.772 0.219 0.001 0.001 0.000 0.000 0.000 0.574 my5651_rel_o2nofp.cz12a_c8r32 0.000 0.004 99.677 0.285 0.034 0.000 0.000 0.000 0.000 0.000 0.049 my5744_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.361 0.594 0.042 0.000 0.003 0.000 0.000 0.000 0.431 my8043_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.404 0.544 0.051 0.000 0.001 0.000 0.000 0.000 0.466 my8044_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.321 0.632 0.045 0.000 0.001 0.000 0.000 0.000 0.440 my8406_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.369 0.585 0.044 0.001 0.001 0.000 0.000 0.000 0.468 my8407_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.710 0.249 0.039 0.000 0.003 0.000 0.000 0.000 0.430 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 0.000 99.350 0.599 0.046 0.005 0.000 0.000 0.000 0.000 0.104 my9400_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.364 0.583 0.051 0.000 0.003 0.000 0.000 0.000 0.492 my9500_rel_o2nofp.cz12a_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 0.386 16.956 72.162 10.281 0.215 0.000 0.000 0.000 0.000 0.000 0.035 my5651_rel_o2nofp.cz12a_c8r32 0.789 56.744 38.871 3.562 0.034 0.000 0.000 0.000 0.000 0.000 0.039 my5744_rel_o2nofp.cz12a_c8r32 0.001 53.487 43.280 3.153 0.079 0.000 0.000 0.000 0.000 0.000 0.050 my8043_rel_o2nofp.cz12a_c8r32 0.001 55.420 41.381 3.159 0.039 0.000 0.000 0.000 0.000 0.000 0.048 my8044_rel_o2nofp.cz12a_c8r32 0.001 53.582 43.169 3.185 0.064 0.000 0.000 0.000 0.000 0.000 0.041 my8406_rel_o2nofp.cz12a_c8r32 0.000 55.695 41.160 3.110 0.036 0.000 0.000 0.000 0.000 0.000 0.044 my8407_rel_o2nofp.cz12a_c8r32 0.000 57.135 41.555 1.087 0.222 0.001 0.000 0.000 0.000 0.000 0.106 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 53.611 43.108 3.228 0.053 0.000 0.000 0.000 0.000 0.000 0.052 my9400_rel_o2nofp.cz12a_c8r32 0.000 50.318 46.282 3.349 0.051 0.000 0.000 0.000 0.000 0.000 0.031 my9500_rel_o2nofp.cz12a_c8r32
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 4.109 74.066 20.787 0.988 0.051 0.000 0.000 0.000 0.000 0.000 0.031 my5651_rel_o2nofp.cz12a_c8r32 38.399 61.453 0.122 0.025 0.001 0.000 0.000 0.000 0.000 0.000 0.024 my5744_rel_o2nofp.cz12a_c8r32 0.000 98.043 1.830 0.122 0.005 0.000 0.000 0.000 0.000 0.000 0.051 my8043_rel_o2nofp.cz12a_c8r32 0.000 98.119 1.758 0.113 0.009 0.000 0.000 0.000 0.000 0.000 0.029 my8044_rel_o2nofp.cz12a_c8r32 0.000 98.155 1.728 0.108 0.007 0.001 0.000 0.000 0.000 0.000 0.068 my8406_rel_o2nofp.cz12a_c8r32 0.001 98.276 1.615 0.102 0.006 0.000 0.000 0.000 0.000 0.000 0.032 my8407_rel_o2nofp.cz12a_c8r32 0.000 99.141 0.758 0.091 0.009 0.001 0.000 0.000 0.000 0.000 0.102 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 98.145 1.720 0.127 0.009 0.000 0.000 0.000 0.000 0.000 0.040 my9400_rel_o2nofp.cz12a_c8r32 0.000 97.744 2.097 0.149 0.010 0.000 0.000 0.000 0.000 0.000 0.062 my9500_rel_o2nofp.cz12a_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.759 0.205 0.026 0.009 nonzero 0.000 0.000 0.000 0.000 0.000 0.032 my5651_rel_o2nofp.cz12a_c8r32 99.917 0.074 0.004 0.005 0.000 0.000 0.000 0.000 0.000 0.000 0.011 my5744_rel_o2nofp.cz12a_c8r32 99.980 0.019 nonzero 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.012 my8043_rel_o2nofp.cz12a_c8r32 99.981 0.018 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.009 my8044_rel_o2nofp.cz12a_c8r32 99.978 0.021 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.012 my8406_rel_o2nofp.cz12a_c8r32 99.979 0.020 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.010 my8407_rel_o2nofp.cz12a_c8r32 99.976 0.022 nonzero 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.011 my8407_rel_o2nofp.cz12a_dw0_c8r32 99.979 0.020 nonzero 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.012 my9400_rel_o2nofp.cz12a_c8r32 99.980 0.020 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.012 my9500_rel_o2nofp.cz12a_c8r32
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 47.500 51.083 1.417 0.000 0.000 0.000 0.000 0.131 my5651_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 78.778 21.222 0.000 0.000 0.000 0.000 0.000 0.022 my5744_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 55.306 44.694 0.000 0.000 0.000 0.000 0.000 0.025 my8043_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 65.722 34.278 0.000 0.000 0.000 0.000 0.000 0.027 my8044_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 55.750 44.250 0.000 0.000 0.000 0.000 0.000 0.028 my8406_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 68.194 31.806 0.000 0.000 0.000 0.000 0.000 0.027 my8407_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 58.722 41.278 0.000 0.000 0.000 0.000 0.000 0.027 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 0.000 0.000 58.889 41.111 0.000 0.000 0.000 0.000 0.000 0.027 my9400_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 57.111 42.889 0.000 0.000 0.000 0.000 0.000 0.027 my9500_rel_o2nofp.cz12a_c8r32
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 1.250 14.972 75.611 7.889 0.278 0.000 0.000 0.000 0.000 0.101 my5651_rel_o2nofp.cz12a_c8r32 0.000 31.917 67.333 0.750 0.000 0.000 0.000 0.000 0.000 0.000 0.012 my5744_rel_o2nofp.cz12a_c8r32 0.000 0.000 90.083 9.917 0.000 0.000 0.000 0.000 0.000 0.000 0.012 my8043_rel_o2nofp.cz12a_c8r32 0.000 0.000 92.194 7.806 0.000 0.000 0.000 0.000 0.000 0.000 0.012 my8044_rel_o2nofp.cz12a_c8r32 0.000 0.000 90.139 9.861 0.000 0.000 0.000 0.000 0.000 0.000 0.011 my8406_rel_o2nofp.cz12a_c8r32 0.000 0.000 92.972 7.028 0.000 0.000 0.000 0.000 0.000 0.000 0.011 my8407_rel_o2nofp.cz12a_c8r32 0.000 0.000 90.500 9.500 0.000 0.000 0.000 0.000 0.000 0.000 0.011 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 0.000 90.583 9.417 0.000 0.000 0.000 0.000 0.000 0.000 0.012 my9400_rel_o2nofp.cz12a_c8r32 0.000 0.000 90.861 9.111 0.028 0.000 0.000 0.000 0.000 0.000 0.021 my9500_rel_o2nofp.cz12a_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 0.159 98.393 1.442 0.005 0.000 0.000 0.000 0.000 0.000 0.000 0.011 my5651_rel_o2nofp.cz12a_c8r32 0.118 94.857 4.981 0.044 0.000 0.000 0.000 0.000 0.000 0.000 0.015 my5744_rel_o2nofp.cz12a_c8r32 0.009 94.497 5.379 0.115 0.000 0.000 0.000 0.000 0.000 0.000 0.016 my8043_rel_o2nofp.cz12a_c8r32 0.010 93.790 6.098 0.103 nonzero 0.000 0.000 0.000 0.000 0.000 0.025 my8044_rel_o2nofp.cz12a_c8r32 0.009 92.716 7.155 0.121 0.000 0.000 0.000 0.000 0.000 0.000 0.014 my8406_rel_o2nofp.cz12a_c8r32 0.008 92.662 7.275 0.056 0.000 0.000 0.000 0.000 0.000 0.000 0.014 my8407_rel_o2nofp.cz12a_c8r32 0.010 92.718 7.264 0.009 0.000 0.000 0.000 0.000 0.000 0.000 0.016 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.009 91.696 8.173 0.123 nonzero 0.000 0.000 0.000 0.000 0.000 0.016 my9400_rel_o2nofp.cz12a_c8r32 0.008 92.875 6.996 0.120 nonzero 0.000 0.000 0.000 0.000 0.000 0.018 my9500_rel_o2nofp.cz12a_c8r32
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 47.611 52.389 0.000 0.000 0.000 0.000 0.000 0.054 my5651_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 75.250 24.750 0.000 0.000 0.000 0.000 0.000 0.039 my5744_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 92.944 7.056 0.000 0.000 0.000 0.000 0.000 0.031 my8043_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 97.694 2.306 0.000 0.000 0.000 0.000 0.000 0.022 my8044_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 92.111 7.889 0.000 0.000 0.000 0.000 0.000 0.049 my8406_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 98.944 1.056 0.000 0.000 0.000 0.000 0.000 0.038 my8407_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 99.611 0.389 0.000 0.000 0.000 0.000 0.000 0.034 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 0.000 0.000 92.778 7.222 0.000 0.000 0.000 0.000 0.000 0.049 my9400_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 94.361 5.639 0.000 0.000 0.000 0.000 0.000 0.045 my9500_rel_o2nofp.cz12a_c8r32
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.222 88.167 11.056 0.556 0.000 0.000 0.000 0.000 0.000 0.025 my5651_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.917 0.083 0.000 0.000 0.000 0.000 0.000 0.000 0.005 my5744_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.833 0.167 0.000 0.000 0.000 0.000 0.000 0.000 0.007 my8043_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.750 0.250 0.000 0.000 0.000 0.000 0.000 0.000 0.005 my8044_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.750 0.250 0.000 0.000 0.000 0.000 0.000 0.000 0.006 my8406_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.750 0.250 0.000 0.000 0.000 0.000 0.000 0.000 0.010 my8407_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.944 0.028 0.028 0.000 0.000 0.000 0.000 0.000 0.036 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 0.000 99.694 0.306 0.000 0.000 0.000 0.000 0.000 0.000 0.006 my9400_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.750 0.222 0.028 0.000 0.000 0.000 0.000 0.000 0.046 my9500_rel_o2nofp.cz12a_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.061 0.826 0.101 0.013 0.000 0.000 0.000 0.000 0.000 0.000 0.011 my5651_rel_o2nofp.cz12a_c8r32 99.892 0.079 0.018 0.011 0.000 0.000 0.000 0.000 0.000 0.000 0.011 my5744_rel_o2nofp.cz12a_c8r32 99.965 0.033 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.010 my8043_rel_o2nofp.cz12a_c8r32 99.967 0.032 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.010 my8044_rel_o2nofp.cz12a_c8r32 99.959 0.039 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.009 my8406_rel_o2nofp.cz12a_c8r32 99.964 0.035 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.009 my8407_rel_o2nofp.cz12a_c8r32 99.958 0.041 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.012 my8407_rel_o2nofp.cz12a_dw0_c8r32 99.963 0.035 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.011 my9400_rel_o2nofp.cz12a_c8r32 99.964 0.034 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.011 my9500_rel_o2nofp.cz12a_c8r32
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.067 61.700 38.233 0.000 0.000 0.000 0.000 0.000 0.056 my5651_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.167 96.978 2.856 0.000 0.000 0.000 0.000 0.000 0.028 my5744_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 92.800 7.200 0.000 0.000 0.000 0.000 0.000 0.030 my8043_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 93.511 6.483 0.000 0.006 0.000 0.000 0.000 0.318 my8044_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 92.667 7.328 0.000 0.006 0.000 0.000 0.000 0.309 my8406_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 99.839 0.161 0.000 0.000 0.000 0.000 0.000 0.053 my8407_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.011 91.733 8.250 0.000 0.006 0.000 0.000 0.000 0.326 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 0.000 0.000 91.844 8.156 0.000 0.000 0.000 0.000 0.000 0.027 my9400_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 92.144 7.850 0.000 0.006 0.000 0.000 0.000 0.345 my9500_rel_o2nofp.cz12a_c8r32
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 2.672 7.344 88.867 1.117 0.000 0.000 0.000 0.000 0.000 0.028 my5651_rel_o2nofp.cz12a_c8r32 0.000 30.089 69.678 0.233 0.000 0.000 0.000 0.000 0.000 0.000 0.013 my5744_rel_o2nofp.cz12a_c8r32 0.000 0.000 98.972 1.028 0.000 0.000 0.000 0.000 0.000 0.000 0.012 my8043_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.117 0.883 0.000 0.000 0.000 0.000 0.000 0.000 0.014 my8044_rel_o2nofp.cz12a_c8r32 0.000 0.000 98.878 1.122 0.000 0.000 0.000 0.000 0.000 0.000 0.011 my8406_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.967 0.028 0.006 0.000 0.000 0.000 0.000 0.000 0.052 my8407_rel_o2nofp.cz12a_c8r32 0.000 0.000 98.578 1.422 0.000 0.000 0.000 0.000 0.000 0.000 0.014 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 0.000 99.283 0.717 0.000 0.000 0.000 0.000 0.000 0.000 0.011 my9400_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.000 0.994 0.006 0.000 0.000 0.000 0.000 0.000 0.022 my9500_rel_o2nofp.cz12a_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 0.011 81.780 17.988 0.220 nonzero 0.000 0.000 0.000 0.000 0.000 0.020 my5651_rel_o2nofp.cz12a_c8r32 0.005 82.675 17.012 0.308 0.001 0.000 0.000 0.000 0.000 0.000 0.024 my5744_rel_o2nofp.cz12a_c8r32 nonzero 88.377 11.038 0.583 0.002 0.000 0.000 0.000 0.000 0.000 0.023 my8043_rel_o2nofp.cz12a_c8r32 nonzero 87.710 11.708 0.581 0.001 0.000 0.000 0.000 0.000 0.000 0.038 my8044_rel_o2nofp.cz12a_c8r32 0.001 85.183 14.224 0.591 0.002 0.000 0.000 0.000 0.000 0.000 0.025 my8406_rel_o2nofp.cz12a_c8r32 nonzero 85.994 13.403 0.601 0.001 0.000 0.000 0.000 0.000 0.000 0.023 my8407_rel_o2nofp.cz12a_c8r32 nonzero 85.806 13.889 0.303 0.001 0.000 0.000 0.000 0.000 0.000 0.022 my8407_rel_o2nofp.cz12a_dw0_c8r32 nonzero 85.694 13.697 0.607 0.002 0.000 0.000 0.000 0.000 0.000 0.029 my9400_rel_o2nofp.cz12a_c8r32 nonzero 85.798 13.601 0.599 0.002 nonzero 0.000 0.000 0.000 0.000 0.128 my9500_rel_o2nofp.cz12a_c8r32
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.006 53.756 44.156 2.083 0.000 0.000 0.000 0.000 0.095 my5651_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.006 89.361 10.628 0.006 0.000 0.000 0.000 0.000 0.077 my5744_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 98.439 1.561 0.000 0.000 0.000 0.000 0.000 0.059 my8043_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 89.972 10.028 0.000 0.000 0.000 0.000 0.000 0.057 my8044_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 93.133 6.867 0.000 0.000 0.000 0.000 0.000 0.047 my8406_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 93.217 6.783 0.000 0.000 0.000 0.000 0.000 0.046 my8407_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 93.572 6.428 0.000 0.000 0.000 0.000 0.000 0.035 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 0.000 0.000 94.839 5.161 0.000 0.000 0.000 0.000 0.000 0.058 my9400_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 93.239 6.761 0.000 0.000 0.000 0.000 0.000 0.047 my9500_rel_o2nofp.cz12a_c8r32
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.067 21.783 62.294 15.844 0.011 0.000 0.000 0.000 0.000 0.065 my5651_rel_o2nofp.cz12a_c8r32 0.000 0.644 99.056 0.300 0.000 0.000 0.000 0.000 0.000 0.000 0.012 my5744_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.861 0.139 0.000 0.000 0.000 0.000 0.000 0.000 0.015 my8043_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.917 0.078 0.006 0.000 0.000 0.000 0.000 0.000 0.017 my8044_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.889 0.111 0.000 0.000 0.000 0.000 0.000 0.000 0.009 my8406_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.617 0.378 0.006 0.000 0.000 0.000 0.000 0.000 0.017 my8407_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.417 0.578 0.006 0.000 0.000 0.000 0.000 0.000 0.021 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 0.000 99.867 0.128 0.006 0.000 0.000 0.000 0.000 0.000 0.019 my9400_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.883 0.111 0.006 0.000 0.000 0.000 0.000 0.000 0.022 my9500_rel_o2nofp.cz12a_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 98.144 1.650 0.192 0.014 0.000 0.000 0.000 0.000 0.000 0.000 0.016 my5651_rel_o2nofp.cz12a_c8r32 99.877 0.098 0.014 0.011 0.000 0.000 0.000 0.000 0.000 0.000 0.012 my5744_rel_o2nofp.cz12a_c8r32 99.946 0.052 0.002 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.010 my8043_rel_o2nofp.cz12a_c8r32 99.948 0.050 0.002 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.010 my8044_rel_o2nofp.cz12a_c8r32 99.937 0.061 0.002 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.010 my8406_rel_o2nofp.cz12a_c8r32 99.940 0.058 0.002 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.009 my8407_rel_o2nofp.cz12a_c8r32 99.938 0.059 0.002 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.011 my8407_rel_o2nofp.cz12a_dw0_c8r32 99.945 0.053 0.002 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.036 my9400_rel_o2nofp.cz12a_c8r32 99.943 0.055 0.002 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.009 my9500_rel_o2nofp.cz12a_c8r32
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.239 73.417 26.311 0.033 0.000 0.000 0.000 0.000 0.094 my5651_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.775 98.764 0.461 0.000 0.000 0.000 0.000 0.000 0.036 my5744_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.067 97.589 2.344 0.000 0.000 0.000 0.000 0.000 0.050 my8043_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.053 98.231 1.717 0.000 0.000 0.000 0.000 0.000 0.032 my8044_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.044 98.106 1.850 0.000 0.000 0.000 0.000 0.000 0.035 my8406_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.022 97.731 2.247 0.000 0.000 0.000 0.000 0.000 0.033 my8407_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.061 97.378 2.561 0.000 0.000 0.000 0.000 0.000 0.046 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 0.000 0.022 98.494 1.483 0.000 0.000 0.000 0.000 0.000 0.041 my9400_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.044 98.469 1.486 0.000 0.000 0.000 0.000 0.000 0.035 my9500_rel_o2nofp.cz12a_c8r32
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.450 28.556 69.825 1.169 0.000 0.000 0.000 0.000 0.000 0.041 my5651_rel_o2nofp.cz12a_c8r32 0.000 13.308 84.708 1.983 0.000 0.000 0.000 0.000 0.000 0.000 0.015 my5744_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.606 0.394 0.000 0.000 0.000 0.000 0.000 0.000 0.012 my8043_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.667 0.333 0.000 0.000 0.000 0.000 0.000 0.000 0.011 my8044_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.775 0.225 0.000 0.000 0.000 0.000 0.000 0.000 0.011 my8406_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.744 0.256 0.000 0.000 0.000 0.000 0.000 0.000 0.011 my8407_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.617 0.375 0.008 0.000 0.000 0.000 0.000 0.000 0.034 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 0.000 99.639 0.353 0.008 0.000 0.000 0.000 0.000 0.000 0.039 my9400_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.775 0.219 0.006 0.000 0.000 0.000 0.000 0.000 0.038 my9500_rel_o2nofp.cz12a_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 nonzero 48.812 50.301 0.885 0.001 0.000 0.000 0.000 0.000 0.000 0.033 my5651_rel_o2nofp.cz12a_c8r32 nonzero 75.463 23.835 0.700 0.001 0.000 0.000 0.000 0.000 0.000 0.026 my5744_rel_o2nofp.cz12a_c8r32 nonzero 77.005 21.917 1.070 0.008 0.000 0.000 0.000 0.000 0.000 0.029 my8043_rel_o2nofp.cz12a_c8r32 0.000 75.943 22.987 1.063 0.007 0.000 0.000 0.000 0.000 0.000 0.028 my8044_rel_o2nofp.cz12a_c8r32 0.000 72.457 26.454 1.080 0.008 nonzero 0.000 0.000 0.000 0.000 0.069 my8406_rel_o2nofp.cz12a_c8r32 0.000 72.709 26.208 1.078 0.005 0.000 0.000 0.000 0.000 0.000 0.027 my8407_rel_o2nofp.cz12a_c8r32 0.000 73.019 26.498 0.475 0.008 0.000 0.000 0.000 0.000 0.000 0.045 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 72.755 26.150 1.087 0.008 0.000 0.000 0.000 0.000 0.000 0.041 my9400_rel_o2nofp.cz12a_c8r32 0.000 72.809 26.106 1.079 0.006 nonzero 0.000 0.000 0.000 0.000 0.122 my9500_rel_o2nofp.cz12a_c8r32
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.006 56.381 40.925 2.689 0.000 0.000 0.000 0.000 0.172 my5651_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.006 91.736 8.258 0.000 0.000 0.000 0.000 0.000 0.055 my5744_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.003 93.578 6.414 0.006 0.000 0.000 0.000 0.000 0.065 my8043_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 93.872 6.128 0.000 0.000 0.000 0.000 0.000 0.057 my8044_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 95.122 4.875 0.000 0.003 0.000 0.000 0.000 0.258 my8406_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 94.661 5.336 0.000 0.003 0.000 0.000 0.000 0.300 my8407_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 97.792 2.208 0.000 0.000 0.000 0.000 0.000 0.049 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 0.000 0.000 94.944 5.047 0.006 0.003 0.000 0.000 0.000 0.444 my9400_rel_o2nofp.cz12a_c8r32 0.000 0.000 0.000 95.133 4.864 0.003 0.000 0.000 0.000 0.000 0.245 my9500_rel_o2nofp.cz12a_c8r32
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.303 33.011 49.806 16.850 0.031 0.000 0.000 0.000 0.000 0.090 my5651_rel_o2nofp.cz12a_c8r32 0.000 0.217 97.244 2.536 0.003 0.000 0.000 0.000 0.000 0.000 0.018 my5744_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.850 0.147 0.003 0.000 0.000 0.000 0.000 0.000 0.016 my8043_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.803 0.197 0.000 0.000 0.000 0.000 0.000 0.000 0.016 my8044_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.725 0.264 0.008 0.000 0.003 0.000 0.000 0.000 0.257 my8406_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.814 0.181 0.003 0.000 0.003 0.000 0.000 0.000 0.300 my8407_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.842 0.153 0.006 0.000 0.000 0.000 0.000 0.000 0.041 my8407_rel_o2nofp.cz12a_dw0_c8r32 0.000 0.000 99.772 0.225 0.003 0.000 0.000 0.000 0.000 0.000 0.026 my9400_rel_o2nofp.cz12a_c8r32 0.000 0.000 99.864 0.128 0.008 0.000 0.000 0.000 0.000 0.000 0.046 my9500_rel_o2nofp.cz12a_c8r32