Today from the OPS colleague that heard the MySQL stress test tool mysqlslap. After understanding the fact that MySQL comes with a pressure test tool called Mysqlslap, or a good simulation. Let me give you an example. Mysqlslap is an official MySQL-provided stress testing tool starting with version 5.1.4. Perform stress testing by simulating multiple concurrent client access to MySQL, while providing detailed data performance reports on "High-load attack MySQL". And it is very good to compare the concurrency pressure performance difference of multiple storage engines in the same environment. The available options can be obtained through MYSQLSLAP–HELP, where the main parameters are listed, and the official manuals are described in more detail. If the system comes with or uses the RPM package installs the MySQL, installs the mysql-client side the package to have mysqlslap this tool.
Advantages: Query data, simple syntax, flexible and easy to use. The tool can simulate multiple clients concurrently issuing query updates to the server, giving performance test data and providing performance comparisons for multiple engines. MSQLSLAP provides an intuitive verification basis before and after MySQL performance optimization, It is suggested that the system operation and DBA personnel should master some common stress testing tools in order to accurately grasp the limit of user traffic and the pressure resistance of the online database support. ( when testing, you can specify the number of concurrent connections and you can specify SQL statements.) If no SQL statement is specified, Mysqlslap automatically generates a SELECT statement for the query schema. )
To be continued ....... .....
Mysqlslap Stress Test Use summary