Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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)
--- 1 query client, 1 load client, maxid1=10m
--- 48 HW-threads, 50g RAM, 5t SSD
- load
ips r/i rkb/i wkb/i Mcpu/i size rss rMB/s wMB/s cpu engine
55881 0 0.03 0.85 85 14 0.4 1.7 47.6 4.8 myrocks.feb10
55861 0 0.03 0.79 81 14 0.4 1.6 43.9 4.5 myrocks.apr14
51789 0 0.03 0.80 84 14 0.3 1.4 41.5 4.3 myrocks.jun16
54034 0 0.02 0.81 94 14 0.3 1.2 43.4 5.1 myrocks.aug15
49986 0 0.02 0.80 98 14 0.3 1.1 40.1 4.9 myrocks.oct16
62224 0 0.02 0.98 72 15 20.8 1.6 61.1 4.5 fbinno5635.jun16
63891 0 0.01 1.03 74 16 18.3 0.9 65.7 4.7 inno5635
56383 0 0.01 1.03 85 16 16.5 0.8 58.3 4.8 inno5717
55173 0 0.01 1.04 78 16 16.4 0.8 57.6 4.3 inno801.latin1sw
41815 0 0.01 1.05 103 16 15.9 0.6 44.0 4.3 inno802.latin1sw
43590 0 0.01 1.06 101 16 16.3 0.6 46.4 4.4 inno803.latin1sw
23664 0 0.01 1.34 160 14 24.8 0.3 31.7 3.8 toku5717.none
- query @ 12h, mysql
tps r/t rkb/t wkb/t Mcpu/t size rss un gn ul gl r/s rMB/s wMB/s cpu engine
5848 0 0.06 0.93 610 15 55.7 0.3 0.1 0.5 0.5 23 0.4 5.4 3.6 myrocks.feb10
5692 0 0.06 0.39 621 16 55.5 0.3 0.1 0.5 0.5 22 0.3 2.2 3.5 myrocks.apr14
5472 0 0.06 0.38 651 15 54.1 0.4 0.1 0.5 0.6 21 0.3 2.1 3.6 myrocks.jun16
5607 0 0.05 0.39 695 16 57.3 0.3 0.1 0.5 0.5 16 0.3 2.2 3.9 myrocks.aug15
5753 0 0.04 0.44 677 16 58.3 0.3 0.1 0.5 0.5 15 0.2 2.5 3.9 myrocks.oct16
7065 0 0.04 5.11 624 23 32.0 0.3 0.1 0.4 0.3 20 0.3 36.1 3.7 fbinno5635.jun16
7420 0 0.02 5.17 562 26 29.9 0.3 0.1 0.4 0.2 15 0.2 38.4 4.2 inno5635
6616 0 0.03 5.20 628 26 26.6 0.3 0.1 0.5 0.3 15 0.2 34.4 4.2 inno5717
6313 0 0.03 5.16 654 25 26.0 0.3 0.1 0.5 0.3 14 0.2 32.6 4.1 inno801.latin1sw
5978 0 0.03 5.38 682 25 25.7 0.3 0.1 0.6 0.3 14 0.2 32.2 4.1 inno802.latin1sw
6070 0 0.03 5.39 669 25 25.8 0.3 0.1 0.6 0.3 25 0.2 32.7 4.1 inno803.latin1sw
4234 0 0.04 2.92 814 19 33.4 0.5 0.2 1 0.6 5 0.2 12.4 3.4 toku5717.none
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.