mysql压测命令

sysbench  io压测
sysbench --test=fileio --file-num=4 --file-block-size=16384 --file-total-size=20G --file-test-mode=rndrd --file-extra-flags=direct prepare
sysbench --test=fileio --file-num=4 --file-block-size=16384 --file-total-size=20G --file-test-mode=rndrd --file-extra-flags=direct --max-time=300 --max-requests=0 --file-fsync-freq=1 --num-threads=16 --report-interval=2 run

iostat  -mx 3

iotop

 

tpcc压测

# cat /etc/ld.so.conf
      include ld.so.conf.d/*.conf
      /usr/local/mysqldb/lib

# /sbin/ldconfig -v

 

mysqladmin extended-status -i 1 -r |grep  -i Questions

 

mysqlslap压测

sbtest_select.sql 脚本
mysqlslap --query=sbtest_select.sql -c 4 --number-of-queries=10000000

mysqladmin extended-status -i 1 -r |grep  -i Questions