Benchmarks For Percona Server
We frequently benchmark Percona Server. Benchmarks, when done scientifically, are a good way to help identify performance bottlenecks and validate the results of changes to software. We design ethical, apples-to-apples benchmarks that are as relevant as possible to real-world use cases.
MySQL 5.5.8 versus Percona Server 5.5.7
December 2010 Vadim Tkachenko benchmarked MySQL 5.5.8, the newest high-performance release from Oracle, against Percona Server 5.5.7 beta in an OLTP workload similar to TPC-C. Key results:
- Percona Server is more than 40% faster than MySQL in overall throughput.
- Percona Server performance remains more stable over time than MySQL, which still experiences sharp drops in throughput due to checkpointing activity.
MySQL 5.5.4 versus Percona Server 5.1
April 2010 Vadim Tkachenko benchmarked MySQL 5.5.4, the newest high-performance release from Oracle, against Percona Server 5.1.54 in an OLTP workload similar to TPC-C. Key results:
- Percona Server is more than 10% faster than MySQL in overall throughput.
- Percona Server's performance is much more stable over time than MySQL's, which experiences sharp drops due to checkpointing activity when the data is larger than the buffer pool.
- MySQL's performance is much better than previous releases.
MySQL 5.1.42 with InnoDB, InnoDB Plugin, and XtraDB on FusionIO
January 2010 Vadim Tkachenko benchmarked the standard InnoDB that ships with MySQL 5.1, the newer InnoDB Plugin, and XtraDB in a workload similar to TPC-C on fast FusionIO storage devices. Key results:
- Standard InnoDB achieves 9.4k new-order transactions per minute, InnoDB plugin reaches 15.3k, and XtraDB reaches 26.1k. On this benchmark, XtraDB is up to 275% faster than InnoDB.
- There is still heavy mutex contention, and much more improvement is possible even in XtraDB.