Created
June 1, 2017 18:24
-
-
Save mdcallag/20c8ab38431747cf3805fcabc10a484a to your computer and use it in GitHub Desktop.
This file contains 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
1 processes, 5000000 rows-per-process, 5005 seconds, 999.0 rows-per-second, 999.0 rows-per-second-per-user, 4238448 queries, 846.8 queries-per-second | |
iostat, vmstat normalized by insert rate | |
samp r/s rkb/s wkb/s r/q rkb/q wkb/q ips spi | |
501 3406.8 54508 91964 3.410 54.563 92.057 999.0 0.100100 | |
samp cs/s cpu/c cs/q cpu/q | |
525 16228 17.3 16.244 0.017276 | |
iostat, vmstat normalized by query rate | |
samp r/s rkb/s wkb/s r/q rkb/q wkb/q qps spq | |
501 3406.8 54508 91964 4.023 64.370 108.602 846.8 0.118092 | |
samp cs/s cpu/c cs/q cpu/q | |
525 16228 17.3 19.164 0.020381 | |
91G /data/m/my/data | |
mdcallag 14055 93.0 81.6 14394640 13326704 pts/2 Sl May28 1494:01 ./bin/mysqld --basedir=. --datadir=/data/m/my/data --plugin-dir=./lib/plugin --log-error=/data/m/my/data/nuc71.err --pid-file=/data/m/my/data/nuc71.pid | |
Insert rt: 256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max | |
Insert rt: 0 0 5509 30394 11625 2472 0 0 0 0 0.162702 | |
Query rt: 256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max | |
Query rt: 1533183 1233734 1432488 12900 7962 18229 0 0 0 0 0.168406 | |
insert and query rate at nth percentile | |
50th, 250 / 501 = 999.2 insert, 912.5 query | |
75th, 376 / 501 = 997.7 insert, 759.4 query | |
90th, 451 / 501 = 995.5 insert, 558.4 query | |
95th, 476 / 501 = 992.3 insert, 308.9 query | |
99th, 496 / 501 = 986.0 insert, 106.6 query |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment