导航：首页 > 数据库 >

官方压测工具mysqlslap介绍及使用

发表于：2025-11-07 作者：千家信息网编辑

千家信息网最后更新 2025年11月07日，mysqlslap是官方的一款做压力测试的工具，可以模拟多个客户端进行并发测试。比如可以模拟多少并发，执行多少次，针对某个存储引擎……等等比如对myisam引擎做并发量为100，查询次数为1000--

千家信息网最后更新 2025年11月07日官方压测工具mysqlslap介绍及使用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

当然可以做迭代，在一次测试中输出：
其中--concurrency可以写作--concurrency=128,256,512诸如此类，而--engine也可以迭代写作--engine=innodb,myisam,memory等。
比如：
多加了的--debug-info参数可以使测试结果变得更加详尽。

[op@sAno1y ~]$ mysqlslap -a --concurrency=100,200 --iterations=1 --number-of-queries=1000 --engine=myisam,innodb,memory --debug-info -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.160 seconds
Minimum number of seconds to run all queries: 0.160 seconds
Maximum number of seconds to run all queries: 0.160 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.164 seconds
Minimum number of seconds to run all queries: 0.164 seconds
Maximum number of seconds to run all queries: 0.164 seconds
Number of clients running queries: 200
Average number of queries per client: 5
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 0.787 seconds
Minimum number of seconds to run all queries: 0.787 seconds
Maximum number of seconds to run all queries: 0.787 seconds
Number of clients running queries: 100
Average number of queries per client: 10
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 1.154 seconds
Minimum number of seconds to run all queries: 1.154 seconds
Maximum number of seconds to run all queries: 1.154 seconds
Number of clients running queries: 200
Average number of queries per client: 5
Benchmark
Running for engine memory
Average number of seconds to run all queries: 0.140 seconds
Minimum number of seconds to run all queries: 0.140 seconds
Maximum number of seconds to run all queries: 0.140 seconds
Number of clients running queries: 100
Average number of queries per client: 10
Benchmark
Running for engine memory
Average number of seconds to run all queries: 0.159 seconds
Minimum number of seconds to run all queries: 0.159 seconds
Maximum number of seconds to run all queries: 0.159 seconds
Number of clients running queries: 200
Average number of queries per client: 5
User time 0.23, System time 0.25
Maximum resident set size 12788, Integral resident set size 0
Non-physical pagefaults 11916, Physical pagefaults 0, Swaps 0
Blocks in 0 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 25055, Involuntary context switches 99

其中Average number of queries per client = number-of-queries / concurrency
即平均一个client的查询 = 总查询 ÷ 并发

另外--auto-general-sql-load-type这个参数也可以选填，默认为mixed。
其他可选项为：update、write、key、read。

附录：
mysqlslap option：