View gist:34c36c82496da63937d781b75695d997
- load, mysql
ips.av ips.75 ips.95 ips.99 r/i rkb/i wkb/i Mcpu/i size rss r/s rmb/s wmb/s cpu engine
114168 6970 6833 6736 0.02 1.00 3.35 220 223 2.3 2140 114.3 382.0 25.2 myrocks.feb10.none
116083 7113 6919 6843 0 0.28 1.60 177 218 12.8 255 31.9 185.4 20.5 myrocks.apr14.none
96539 5947 5754 5647 0 0.18 1.61 189 218 2.9 142 17.7 155.0 18.2 myrocks.jun16.none
116381 7159 6978 6860 0 0.19 1.59 180 217 3.0 175 21.8 184.9 21.0 myrocks.aug15.none
123923 7615 7445 7359 0 0.18 1.59 176 217 3.1 184 22.8 196.6 21.9 myrocks.oct16.none
80900 4738 2224 1495 0.02 0.34 2.27 325 112 2.5 1599 27.4 183.8 26.3 myrocks.feb10.zstd
116043 7111 6947 6795 0 0.10 1.36 195 98 13.4 94 11.8 157.6 2
View gist:61da02844ebcbfba227162d929142483
- load
ips.av ips.75 ips.95 ips.99 r/i rkb/i wkb/i Mcpu/i size rss r/s rmb/s wmb/s cpu engine
123411 7699 7494 5879 0.03 1.47 4.84 244 230 4.7 3249 90.8 596.7 30.1 myrocks.feb10.none
129971 7992 7777 7661 0 0.40 1.99 180 225 13.0 410 25.7 258.2 23.4 myrocks.apr14.none
107596 6626 6419 6273 0 0.28 2.01 189 227 4.9 244 15.3 215.7 20.3 myrocks.jun16.none
129660 7971 7761 7602 0 0.30 1.98 184 225 4.8 307 19.1 256.3 23.8 myrocks.aug15.none
137760 8505 8282 8161 0 0.29 1.97 179 225 5.0 319 20.0 271.2 24.7 myrocks.oct16.none
67272 3293 1815 5678 0.03 0.68 3.42 365 114 4.4 1969 22.9 229.6 24.5 myrocks.feb10.zstd
128626 7940 7756 7625 0 0.16 1.64 218 103 14.3 166 10.4 210.1 28.1
View gist:c04f7604e43aaa4e017ea8a8aee30d43
- load, mysql
ips.av ips.75 ips.95 ips.99 wkb/i Mcpu/i size rss wmb/s cpu engine
117123 7162 7007 6870 2.41 185 60 1.1 282.2 21.6 myrocks.feb10
117925 7251 7098 6916 1.24 160 59 20.7 146.1 18.8 myrocks.apr14
98193 6069 5908 5816 1.26 169 60 1.2 123.5 16.6 myrocks.jun16
118399 7278 7124 6952 1.22 163 58 1.2 144.5 19.2 myrocks.aug15
126135 7825 7634 7511 1.23 159 58 1.1 154.2 20.1 myrocks.oct16
185805 11482 11183 10967 5.18 184 102 113.0 963.0 34.1 fbinno5635.jun16
107043 5514 4698 4614 4.48 197 116 121.6 480.0 21.1 inno5635
192308 11909 11569 11273 5.35 205 116 119.7 1028.2 39.4 inno5717
View gist:ac2455ebd5b24a058f60360f80855108
- load, mysql
ips.av ips.75 ips.95 ips.99 wkb/i Mcpu/i size rss wmb/s cpu engine
127584 7931 7655 6602 3.82 206 66 1.7 487.2 26.3 myrocks.feb10
132767 8187 7981 7800 1.54 161 61 21.8 203.6 21.3 myrocks.apr14
109409 6770 6612 6498 1.57 170 62 1.7 171.3 18.6 myrocks.jun16
132450 8153 7953 7783 1.51 164 61 1.7 200.0 21.7 myrocks.aug15
140647 8755 8514 8327 1.51 160 61 1.8 212.5 22.4 myrocks.oct16
179147 9902 8759 8297 5.48 195 90 100.1 982.2 35.0 fbinno5635.jun16
93179 4439 3752 3525 5.10 198 97 108.5 475.3 18.5 inno5635
230309 12149 10225 9868 5.31 178 98 106.8 1223.1 41.1 inno5717
View gist:c92e41dc067a9a802444064935c35ecb
- load
ips.av ips.75 ips.95 ips.99 wkb/i Mcpu/i size rss wmb/s cpu engine
43103 41809 39377 37744 1.80 159 12 0.6 77.4 6.8 myrocks.feb10
41806 40633 38557 36592 1.16 152 13 4.1 48.4 6.4 myrocks.apr14
37908 36817 34879 33327 1.16 164 13 0.6 43.9 6.2 myrocks.jun16
41237 39974 38105 35856 1.17 156 13 0.6 48.2 6.4 myrocks.aug15
40519 39490 37187 35086 1.16 156 13 0.7 47.0 6.3 myrocks.oct16
39139 38045 37159 35952 3.80 132 19 27.9 148.6 5.2 fbinno5635
38388 37390 36286 35148 3.84 135 21 36.1 147.2 5.2 inno5635
35625 34707 33930 33116 4.04 142 21 34.5 144.1 5.0 inno5717
View gist:9cff65c38309a391b1b62c9cb1972b9f
size after load in GB
size engine
73 MyRocks.feb10.none
48 MyRocks.feb10.zstd
87 FbInno5635.apr14
89 Inno5635
89 Inno5717
88 Inno801
88 Inno802
88 Inno803
View gist:b63ad8763fbeaa12c6f7d9bbe906a83a
- 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
View gist:0d6991b0a5d2f84d144a4ddbcb5deb7b
- 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
View gist:f5775ff5b4730fec44f349a469f8b7dc
-- w=100, c=1
load
size engine
11 MyRocks.feb10
11 MyRocks.apr14
11 MyRocks.jun16
11 MyRocks.jul14
9.2 FbInno5635.jun16
9.4 Inno5635
View gist:d5e67c3add074978362afe8c609feeea
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: