MySQL Benchmarks: MySQL 5.5.11 vs Percona 5.5.10-20.1 vs MariaDB 5.2.5 – InnoDB and MyISAM
Updated MySQL benchmark results for MySQL 5.5.11 vs Percona 5.5.10-20.1 vs MariaDB 5.2.5 were made possible as I managed to gain further access to the Quad Intel Xeon Nehalem-EX L7555 Octo-Core 1.86Ghz, 64GB memory server. Apparently, it sat untouched for nearly 3 weeks after I last used the server as the owner is switching to Dual Intel Xeon X5690 Hexa-Core 3.46Ghz Westmere based server with 2x 6 = 12 physical cpu cores and 12 virtual cores via Hyperthreading = 24 CPU cores total. I’ll update blog post and the charts here later on to add Percona 5.5.10-20.1 and MySQL 5.5.11 results to the mix.
For now, here’s summary of the MySQL benchmark comparison between MariaDB 5.2.5, Percona 5.5.10-20.1 and MySQL 5.5.11 using Sysbench v0.4.1.2 OLTP tests on both MyISAM and InnoDB storage engine configurations. The Sysbench test configuration settings and my.cnf settings used were all the same as listed in the original tests here.
Benchmark Tests:
- Sysbench v0.4.12 – OLTP 10,000,000 row table read only and
- Sysbench v0.4.12 – OLTP 10,000,000 row table read/write (73.7% read / 26.3% write)
Server Hardware Specifications:
- Quad Intel Xeon Nehalem-EX L7555 Octo-Core 1.86GHz (4x8x2 = 64 cpu cores)
- 64GB RAM DDR3 (16x 4GB DDR3)
- Supermicro X8QB6
- 6 x 64GB Intel X25-E Extreme SSD (SSDSA2SH064G1GC) – RAID 10
- Adaptec 5805 SAS/SATA PCI-E Raid controller 512 MB cache + BBU Write Back cache
- CentOS 5.5 64bit with WHM/Cpanel
- 2.6.18-194.32.1.el5 SMP Kernel
Charts
Below are two sets of charts where horizontal axis is the number of cpu cores/threads tested and laid out as follows:
Set 1
- Sysbench MyISAM read only results for all MySQL versions
- Sysbench MyISAM read/write results for all MySQL versions
Set 2
- Sysbench InnoDB read only results for all MySQL versions
- Sysbench InnoDB read/write results for all MySQL versions
Sysbench MyISAM Read Only
Sysbench MyISAM Read/Write
