Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created December 4, 2017 19:48
Show Gist options
  • Save mdcallag/0d6991b0a5d2f84d144a4ddbcb5deb7b to your computer and use it in GitHub Desktop.
Save mdcallag/0d6991b0a5d2f84d144a4ddbcb5deb7b to your computer and use it in GitHub Desktop.
- from load
ips wkb/i Mcpu/i size wMB/s cpu engine
44605 0.77 816 5.4 34.2 36.4 MyRocks
38746 5.70 695 4.5 220.7 26.9 Inno5096
37408 5.57 725 4.5 208.3 27.1 Inno5172
33703 5.70 842 4.5 192.2 28.4 Inno5551
52463 2.63 637 4.5 138.2 33.4 Inno5635
44598 2.73 686 4.6 121.8 30.6 Inno5717
41744 2.69 766 4.6 112.4 32.0 Inno802
legend:
* ips - inserts/second
* wkb/i - iostat KB written per insert
* Mcpu/i - normalized CPU time per insert
* size - database size in GB at test end
* wMB/s - iostat write MB/s, average
* cpu - average value of vmstat us + sy columns
- from 12th hour of the transaction test
tps wkb/t Mcpu/t size un gn ul gl wMB/s cpu engine
5387 0.38 4812 6.6 0.3 0.1 0.6 0.5 2.1 25.9 MyRocks
7485 11.06 3536 11 0.2 0.1 11 0.3 82.8 26.5 Inno5096
7116 10.87 3628 11 0.2 0.1 11 0.3 77.4 25.8 Inno5172
7156 11.30 4189 11 0.2 0.1 0.6 0.3 80.9 30.0 Inno5551
7310 8.67 4232 11 0.2 0.1 0.4 0.3 63.4 30.9 Inno5635
6378 8.66 4510 10 0.3 0.1 0.6 0.3 55.3 28.8 Inno5717
5879 9.04 4856 9.7 0.3 0.1 0.6 0.4 53.1 28.5 Inno802
legend:
* tps - transactions/second
* wkb/t - iostat KB written per transaction
* Mcpu/t - normalized CPU time per transaction
* size - database size in GB at test end
* un, gn, ul, gl - 99th percentile response time in millisecs for UpdateNode, GetNode, UpdateList and GetLinkedList transactions
* wMB/s - iostat write MB/s, average
* 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