本文共 2045 字,大约阅读时间需要 6 分钟。
DOCKCER MySQL.0.13 OLTP性能测试
测试环境
主机IP | 操作系统 | 内存 | 文件系统 | 数据库版本 | Docker版本 |
10.64.197.101 | Centos7.4 | 94G | xfs | Mysql8.0.13 | 17.09.0-ce |
10.40.195.64 | Centos6.5 | 94G |
| sysbench1.0.9 | 无 |
说明:1.MySQL和Docker下Mysql均使用xfs文件系统存放数据文件。
2.本次测试数据:--oltp-tables-count=20 --oltp-table-size=1000000
测试结果统计
Threads | innodb_buffer_pool_size | 测试环境 | TPS/s | QPS/s |
1 | 8 | 非docker | 83.71 | 1674.12 |
Docker | 84.63 | 1692.69 | ||
16 | 非docker | 68.37 | 1367.36 | |
Docker | 85.40 | 1707.99 | ||
32 | 非docker | 118.48 | 2369.61 | |
Docker | 96.87 | 1937.32 | ||
2 | 8 | 非docker | 299.01 | 5980.18 |
Docker | 280.56 | 5611.30 | ||
16 | 非docker | 279.56 | 5591.24 | |
Docker | 297.00 | 5939.99 | ||
32 | 非docker | 311.03 | 6220.59 | |
Docker | 319.66 | 6393.11 | ||
4 | 8 | 非docker | 634.45 | 12688.90 |
Docker | 577.08 | 11541.71 | ||
16 | 非docker | 598.95 | 11978.94 | |
Docker | 610.16 | 12203.16 | ||
32 | 非docker | 639.55 | 12791.05 | |
Docker | 592.96 | 11859.21 | ||
8 | 8 | 非docker | 1197.16 | 23943.37 |
Docker | 1140.88 | 22817.63 | ||
16 | 非docker | 1176.84 | 23536.84 | |
Docker | 1129.88 | 22597.80 | ||
32 | 非docker | 1190.47 | 23809.48 | |
Docker | 1143.14 | 22862.84 | ||
16 | 8 | 非docker | 1965.68 | 39313.99 |
Docker | 1876.98 | 37539.71 | ||
16 | 非docker | 1956.83 | 39136.74 | |
Docker | 1892.16 | 37843.34 | ||
32 | 非docker | 1966.70 | 39334.28 | |
Docker | 1883.15 | 37663.52 | ||
32 | 8 | 非docker | 2616.10 | 52322.98 |
Docker | 2579.08 | 51582.31 | ||
16 | 非docker | 2628.03 | 52561.38 | |
Docker | 2580.71 | 51614.92 | ||
32 | 非docker | 2629.43 | 52589.11 | |
Docker | 2581.19 | 51624.53 | ||
64 | 8 | 非docker | 2844.36 | 56888.80 |
Docker | 2844.32 | 56888.36 | ||
16 | 非docker | 2842.09 | 56843.20 | |
Docker | 2841.96 | 56840.66 | ||
32 | 非docker | 2834.19 | 56685.58 | |
Docker | 2843.88 | 56879.21 | ||
128 | 8 | 非docker | 2870.06 | 57404.22 |
Docker | 2867.28 | 57349.24 | ||
16 | 非docker | 2870.00 | 57403.08 | |
Docker | 2866.65 | 57336.92 | ||
32 | 非docker | 2870.01 | 57403.51 | |
Docker | 2866.88 | 57341.28 | ||
256 | 8 | 非docker | 2869.93 | 57404.65 |
Docker | 2868.12 | 57369.04 | ||
16 | 非docker | 2869.97 | 57404.84 | |
Docker | 2868.05 | 57368.46 | ||
32 | 非docker | 2869.79 | 57402.66 | |
Docker | 2868.10 | 57368.77 | ||
512 | 8 | 非docker | 2868.56 | 57388.63 |
Docker | 2867.53 | 57364.05 | ||
16 | 非docker | 2869.13 | 57398.98 | |
Docker | 2867.47 | 57362.87 | ||
32 | 非docker | 2869.25 | 57400.02 | |
Docker | 2867.39 | 57361.84 | ||
1024 | 8 | 非docker | 2863.08 | 57286.60 |
Docker | 2862.00 | 57263.69 | ||
16 | 非docker | 2863.53 | 57293.71 | |
Docker | 2861.44 | 57251.93 | ||
32 | 非docker | 2864.14 | 57305.42 | |
Docker | 2861.03 | 57244.37 |
以上数据绘制成折线图如下:
TPS:
QPS
转载地址:http://ijhji.baihongyu.com/