mysql 读写性能_mysql读写性能测试-调优案例参考

docker pull mysql:5.7mkdir/data/mysql/logs /data/mysql/conf /data/mysql/data -p

docker run --name mysql5.7 -p 3306:3306\-m 2g \-v /data/mysql/data:/var/lib/mysql -v /data/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7

mysql -uroot -p123456 -h 172.17.0.1#因为mysql运行在docker里需要这样登录

不然报错ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

mysql -uroot -p123456

yum install -y mysql

mysqlslap -a -c 500 -i 10 -uroot -p123456 -h 172.17.0.1

mysqlslap -a --concurrency=50,100 --number-of-queries 100 --iterations=5 --engine=myisam,innodb --debug-info -uroot -p123456 -h 172.17.0.1

mysqlslap -a --concurrency=50,100 --number-of-queries 1000 --debug-info -uroot -p123456 -h 172.17.0.1

显示详细过程的测试，如果报错Option 'debug-info' used, but is disabled 请取消 debug-info参数

mysql