测试环境
:MySQL 5.7.26
测试数据:10张表,每张表500万行数据,共12G的数据。
innodb_buffer_pool_size=24576M不变,修改innodb_buffer_pool_instances大小测试对性能的影响,分别为1,2,4,8,16,24,32。
测试脚本如下:
/usr/local/bin/sysbench /tmp/sysbench-master/src/lua/oltp_read_write.lua --mysql-user=sysbenchuser --mysql-password=sysbenchuser --mysql-port=3307 --mysql-host=localhost --mysql-socket=/tmp/mysqld.sock --mysql-db=sysbenchtest --tables=10 --table-size=5000000 --threads=30 --report-interval=5 --time=180 run
sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 30
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 30 tps: 1075.60 qps: 21612.05 (r/w/o: 15142.28/4312.58/2157.19) lat (ms,95%): 37.56 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 30 tps: 780.79 qps: 15613.80 (r/w/o: 10931.06/3121.16/1561.58) lat (ms,95%): 82.96 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 30 tps: 684.47 qps: 13674.92 (r/w/o: 9566.52/2739.47/1368.93) lat (ms,95%): 54.83 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 30 tps: 549.18 qps: 10998.35 (r/w/o: 7704.48/2195.51/1098.36) lat (ms,95%): 118.92 err/s: 0.00 reconn/s: 0.00
[ 25s ] thds: 30 tps: 912.10 qps: 18247.49 (r/w/o: 12765.26/3658.02/1824.21) lat (ms,9