Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created December 4, 2017 20:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mdcallag/b63ad8763fbeaa12c6f7d9bbe906a83a to your computer and use it in GitHub Desktop.
Save mdcallag/b63ad8763fbeaa12c6f7d9bbe906a83a to your computer and use it in GitHub Desktop.
- load
ips r/i rkb/i wkb/i Mcpu/i size rss rMB/s wMB/s cpu engine
43099 0 0 1.28 981 78 0.8 0.2 55.2 42.3 MyRocks.none
42588 0 0 1.40 1098 39 0.5 0.1 59.5 46.7 MyRocks.zstd
51138 0 0 2.70 626 119 14.0 0 138.1 32.0 Inno5096
50134 0 0 2.43 646 119 13.8 0 121.7 32.4 Inno5172
42327 0 0 2.54 778 119 13.9 0 107.3 32.9 Inno5551
50482 0 0 2.11 686 118 13.9 0 106.4 34.6 Inno5635
44534 0 0 2.12 735 118 13.3 0 94.6 32.7 Inno5717
37804 0 0 2.17 868 118 13.4 0 82.1 32.8 Inno802
legend:
* ips - inserts/second
* r/i - iostat reads per insert
* rkb/i, wkb/i - iostat KB written per insert
* Mcpu/i - normalized CPU time per insert
* size - database size in GB at test end
* rss - mysqld RSS at test end
* rMB/s, wMB/s - iostat read and write MB/s, average
* cpu - average value of vmstat us + sy columns
- 12th hour of transactions
tps r/t rkb/t wkb/t Mcpu/t size rss un gn ul gl r/s rMB/s wMB/s cpu engine
2734 0.76 14.92 0.48 6319 81 14.1 0.6 0.4 1 0.7 2085 40.8 1.3 17.3 MyRocks.none
2760 0.76 9.29 0.45 7110 40 14.1 0.5 0.4 0.9 0.6 2103 25.6 1.3 19.6 MyRocks.zstd
1732 1.01 16.49 15.73 9848 133 14.0 2 2 23 2 1752 28.6 27.2 17.1 Inno5096
1793 0.91 14.80 15.70 9614 133 13.8 2 2 23 2 1628 26.5 28.2 17.2 Inno5172
2355 0.93 14.89 15.99 7768 135 13.9 3 2 7 2 2192 35.1 37.7 18.3 Inno5551
2399 0.92 14.79 13.50 7583 134 13.7 2 1 4 1 2218 35.5 32.4 18.2 Inno5635
2244 0.93 14.85 15.08 8357 134 13.3 2 1 3 1 2082 33.3 33.8 18.8 Inno5717
2167 0.92 14.65 16.58 8687 133 13.3 2 2 5 1 1985 31.8 35.9 18.8 Inno802
legend:
* tps - transactions/second
* r/t - iostat reads per transaction
* rkb/t, wkb/t - iostat KB read and written per transaction
* Mcpu/t - normalized CPU time per transaction
* size - database size in GB at test end
* rss - mysqld RSS at test end
* un, gn, ul, gl - 99th percentile response time in millisecs for UpdateNode, GetNode, UpdateList and GetLinkedList transactions
* r/s - iostat reads/second
* rMB/s, wMB/s - iostat read and write MB/s
* cpu - average CPU utilization from vmstat us + sy
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment