Mysqlslap是官方的一款做压力
测试的
工具，可以模拟多个客户端进行
并发测试。
比如可以模拟多少并发，执行多少次，针对某个存储引擎……等等
比如对myisam引擎做并发量为100，查询次数为1000
--concurrency用于指定并发量，--number-of-queries=1000用于指定查询次数，--engine用于指定存储引擎
-a则是自动生成
sql（当未提供file或command时）
-
[op@sAno1y ~]$ mysqlslap -a --concurrency=100 --number-of-queries=1000 --engine=myisam -uroot -proot
-
Warning: Using a password on the command line interface can be insecure.
-
Benchmark
-
Running for engine myisam
-
Average number of seconds to run all queries: 0.167 seconds
-
Minimum number of seconds to run all queries: 0.167 seconds
-
Maximum number of seconds to run all queries: 0.167 seconds
-
Number of clients running queries: 100
-
Average number of queries per client: 10
-
-
Benchmark
-
Running for engine myisam
-
Average number of seconds to run all queries: 0.170 seconds
-
Minimum number of seconds to run all queries: 0.170 seconds
-
Maximum number of seconds to run all queries: 0.170 seconds
-
Number of clients running queries: 200
-
Average number of queries per client: 5
--结束END--
本文标题: 官方压测工具mysqlslap介绍及使用
本文链接: https://www.lsjlt.com/news/47098.html(转载时请注明来源链接)
有问题或投稿请发送至:
邮箱/279061341@qq.com QQ/279061341
0