单节点mysql数据库压测脚本(使用前要确认mysql的bin目录配置到环境变量PATH中):
脚本一(精简版):
mysqlslap -hlocalhost -uroot -proot -P3306 --concurrency=500 --number-of-queries=500 --iterations=1 --auto-generate-sql
脚本二(完整版):
mysqlslap -hlocalhost -uroot -proot -P3306 --concurrency=100 --iterations=1 --auto-generate-sql --auto-generate-sql-load-type=mixed --auto-generate-sql-add-autoincrement --engine=innodb --number-of-queries=100
说明:
--concurrency=500 //并发量
--number-of-queries=500 //执行次数
执行结果:
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 2.653 seconds
Minimum number of seconds to run all queries: 2.653 seconds
Maximum number of seconds to run all queries: 2.653 seconds
Number of clients running queries: 100
Average number of queries per client: 1
加餐:
mysq数据库瓶颈:单表数据量超过2000万,它的的性能就会非常差劲
瓶颈解决方案:
参考:https://www.cnblogs.com/liugx/p/9935749.html
数据切片方案: