Introduction of mysqlslap, a stress testing tool included in mysql

Let's learn about the introduction of the built-in stress testing tool mysqlslap in mysql. I believe you will benefit a lot after reading it. I hope that mysql has its own stress testing tool mysqlslap. This short article is what you want.

test

Example 1

300 queries and 50 concurrency

Mysqlslap-a-concurrency=50-- number-of-queries 300-hlocalhost-uroot-proot

Benchmark Average number of seconds to run all queries: 19.286 seconds Minimum number of seconds to run all queries: 19.286 seconds Maximum number of seconds to run all queries: 19.286 seconds Number of clients running queries: 1 Average number of queries per client: 300Benchmark Average number of seconds to run all queries: 16.868 seconds Minimum number of seconds to run all queries: 16.868 seconds Maximum number of seconds to run all queries: 16.868 seconds Number of clients running queries: 2 Average number of queries per client: 150Benchmark Average number of seconds to run all queries: 13.614 seconds Minimum number of seconds to run all queries: 13.614 seconds Maximum number of seconds to run all queries: 13.614 seconds Number of clients running queries: 3

Average number of queries per client: 100

After reading the article of mysqlslap, the stress testing tool in mysql, many readers will want to know more about it. For more industry information, you can follow our industry information section.