MySQL’s mysqlslap
utility helps you visualize how your database performance will improve with more hardware, new tuning, or different indexes.
The trouble is, it’s designed to use fake data. You can tune the fake data to look increasingly like your real data, and that will help you get a feel for changes like bigger hardware. But fake data teaches you almost nothing for deep changes like altering your schema, adding new indexes, or tweaking memory and cache parameters.
So we’re going to get completely authentic data from your database so you can plan and test performance changes with higher confidence.