Sep 19, 2018

MySQL comes with a handy little diagnostic tool called mysqlslap

mysqlslap can emulate a large number of client connections hitting the database server at the same time. The load testing parameters are fully configurable and the results from different test runs can be used to fine-tune database design or hardware resources.