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 which adds 2 UPDATEs and one INSERT and
The latest release of this official sysbench tree is
0.4.12. Many Linux distributions ship a package for this.
However there is also a newer version of sysbench, that comes as
version number 0.5.[Read more]