The mysqlslap utility makes it possible to benchmark and compare MySQL performance on different hardware, as well as accurately quantify the effect of a change in database design. This tutorial shows how you can use mysqlslap to run tests involving multiple clients, custom queries, different table engines, and much more.
This is a great article that explains the usage of mysqlslap. It’s good for testing changes to your database and getting an idea of what adding and removing indexes can affect for performance.














