A quite common benchmark for MySQL is sysbench. It was written nearly 10 years ago by Alexey Kopytov.
Sysbench has modes to benchmark raw CPU performance, mutex speed,
scheduler overhead and file IO performance. The probably most
often used sysbench mode is OLTP. This benchmark mimics a OLTP
scenario with small transactions hitting an optimized database.
There are many variables to play with, most important is the
number of simulated application threads (option
--num-threads). The OLTP benchmark can be run
read-only, then it does 14 SELECT queries per transaction. Or it
can be run read-write …