Last active
December 1, 2017 02:28
-
-
Save mdcallag/d5e67c3add074978362afe8c609feeea to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| legend for load: | |
| * ips - inserts/second for assoc & count tables | |
| * r/i, rkb/i, wkb/i - iostat reads/insert, read KB/insert and write KB/insert | |
| * Mcpu/i - relative CPU overhead / insert | |
| * size - database size in GB at load end | |
| * rss - mysqld RSS at test end | |
| * rMB/s, wMB/s - iostat read and write MB/s | |
| * cpu - vmstat cpu utilization (sy + us columns) | |
| legend for queries: | |
| * tps - transactions/second | |
| * r/t, rkb/t, wkb/t - iostat reads/transaction, read KB/transaction and write KB/transaction | |
| * Mcpu/t - relative CPU overhead /transaction | |
| * size - database size in GB at end | |
| * rss - mysqld RSS at test end | |
| * un, gn, ul, gl - p99 in millisecs for UpdateNode, GetNode, UpdateLink, GetLinkList transactions | |
| * r/s, rMB/s, wMB/s - iostat reads/s and then read and write MB/s | |
| * cpu - vmstat cpu utilization (sy + us columns) | |
| --- 16 query clients, 4 load clients, maxid1=1b | |
| --- 48 HW-threads, 50g RAM, 5t nvme ssd | |
| - load | |
| ips r/i rkb/i wkb/i Mcpu/i size rss rMB/s wMB/s cpu engine | |
| 144213 0 0 0.91 74 948 5.2 0.3 131.0 10.7 MyRocks.Feb10.none | |
| 142845 0 0 1.04 78 947 11.7 0.4 148.4 11.2 MyRocks.Apr14.none | |
| 141006 0 0 1.01 81 949 5.0 0.3 142.4 11.5 MyRocks.Jun16.none | |
| 142812 0 0 1.02 79 948 7.5 0.3 145.2 11.3 MyRocks.Aug15.none | |
| 135580 0 0 1.01 86 948 7.6 0.4 136.9 11.7 MyRocks.Oct16.none | |
| 145369 0 0.01 1.15 85 433 4.8 2.4 166.1 12.3 MyRocks.Feb10.zstd | |
| 145061 0 0.03 1.27 86 440 11.8 4.2 184.1 11.8 MyRocks.Apr14.zstd | |
| 139927 0 0.01 1.27 90 440 5.0 1.5 176.9 12.6 MyRocks.Jun16.zstd | |
| 144232 0 0.01 1.28 87 439 5.0 1.9 183.9 12.6 MyRocks.Aug15.zstd | |
| 136946 0 0.02 1.28 95 440 5.0 2.4 175.5 13.0 MyRocks.Oct16.zstd | |
| - | |
| 133385 0 0 1.00 79 13xx 38.0 0 133.2 10.6 FbInno.5635.Jun16 | |
| 130206 0 0 1.04 79 15xx 42.7 0.1 135.5 10.2 Inno.5635 | |
| 134997 0 0 1.04 84 15xx 39.4 0.1 140.6 11.4 Inno.5717 | |
| 132452 0 0 1.04 86 15xx 39.5 0.1 138.1 11.4 Inno.801 | |
| 121436 0 0 1.05 99 15xx 39.5 0.1 127.7 12.0 Inno.802 | |
| 127339 0 0 1.05 96 15xx 39.5 0.1 133.8 12.2 Inno.803 | |
| - from September | |
| 36737 0 0 1.68 246 12xx 11.1 0.1 61.6 9.0 Toku.5717.none | |
| 37032 0 0 1.18 257 442 11.6 1 43.8 9.5 Toku.5717.zlib | |
| - from November | |
| 37599 0 0 1.61 228 12xx 11.7 0.1 60.4 8.6 Toku.5717.none | |
| 37413 0 0 1.17 241 443 12.3 0 43.7 9.0 Toku.5717.zlib | |
| - query @ 12h | |
| tps r/t rkb/t wkb/t Mcpu/t size rss un gn ul gl r/s rMB/s wMB/s cpu engine | |
| 35431 1.15 22.04 2.14 643 987 12.2 0.6 0.5 1 0.9 40898 816.3 75.8 22.8 MyRocks.Feb10.none | |
| 35245 1.16 22.51 0.64 641 998 12.3 0.7 0.5 1 0.9 40851 793.4 22.6 22.6 MyRocks.Apr14.none | |
| 34710 1.15 22.35 0.63 656 997 11.7 0.7 0.5 1 0.9 39976 775.8 22.0 22.8 MyRocks.Jun16.none | |
| 34701 1.16 22.41 0.64 659 997 11.7 0.7 0.5 1 0.9 40070 777.7 22.1 22.9 MyRocks.Aug15.none | |
| 35380 1.16 22.42 0.63 641 998 11.7 0.6 0.5 1 0.9 40848 793.1 22.1 22.7 MyRocks.Oct16.none | |
| - | |
| 35297 1.10 13.46 1.59 761 465 12.1 0.6 0.5 1 0.8 38708 475.1 56.1 26.9 MyRocks.Feb10.zstd | |
| 35272 1.09 13.22 0.64 730 468 12.2 0.7 0.5 1 0.9 38253 466.3 22.6 25.7 MyRocks.Apr14.zstd | |
| 34866 1.08 13.10 0.65 745 468 11.6 0.7 0.5 1 0.9 37545 456.9 22.5 26.0 MyRocks.Jun16.zstd | |
| 34622 1.08 13.12 0.64 758 467 11.5 0.7 0.5 1 0.9 37379 454.4 22.1 26.2 MyRocks.Aug15.zstd | |
| 35293 1.08 13.22 0.65 740 469 11.7 0.7 0.5 1 0.9 38214 466.4 22.9 26.1 MyRocks.Oct16.zstd | |
| - | |
| 31119 1.15 18.41 11.86 572 15xx 38.6 2 2 6 3 35798 572.8 369.2 17.8 FbInno.5635.Jun16 | |
| 25501 1.16 18.52 12.06 702 16xx 43.2 3 2 6 4 29523 472.4 307.4 17.9 Inno.5635 | |
| 34406 1.15 18.39 11.90 615 17xx 40.0 2 2 3 2 39541 632.7 409.5 21.2 Inno.5717 | |
| 34055 1.14 18.21 11.92 627 17xx 40.1 2 2 3 2 38768 620.3 405.8 21.4 Inno.801 | |
| 33672 1.15 18.39 11.97 648 17xx 40.1 2 2 3 2 38703 619.2 403.2 21.8 Inno.802 | |
| 33849 1.14 18.23 11.96 645 17xx 40.1 2 2 3 2 38560 617.0 405.0 21.8 Inno.803 | |
| - from September | |
| 8982 3.07 18.97 5.64 2685 12xx 14.0 4 3 13 12 27610 1697.3 50.7 24.1 Toku.5717.none | |
| 12448 1.20 17.42 2.84 2644 466 13.3 3 2 6 3 14885 216.9 35.4 32.9 Toku.5717.zlib | |
| - from November | |
| 9055 3.01 181.79 5.38 2399 12xx 14.1 4 3 13 11 27273 1646.1 48.7 21.7 Toku.5717.none | |
| 12242 1.20 17.59 2.81 2442 469 13.6 3 2 7 3 14712 215.3 34.4 29.9 Toku.5717.zlib |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment