MySQL Benchmarks – MySQL 5.0.92 vs 5.1.55 vs 5.5.10 vs Percona 5.1.55 vs Percona 5.5.8 vs MariaDB 5.2.5
It’s not everyday that I get the opportunity and access to a 64 cpu core monster server with Quad Intel Xeon L7555 1.86Ghz Nehalem-EX processors and 64GB DDR3 memory! Yes, technically it’s 4×8 = 32 physical cpu cores with additional 32 virtual cores via Intel Hyperthreading. I’d like to thank Stewart (woostar) for allowing me access to his new server for a few days.
So I decided to run some MySQL server performance benchmarks to see how different MySQL versions and forks performed in terms of cpu core scaling. Most MySQL benchmarks I have seen only focus on InnoDB storage engine performance, but in the context of vBulletin and wordpress usage where most users are still predominantly using MyISAM tables, I decided to also test MyISAM storage engine performance as well.
Given that I only had ~4 days of access on this server, there’s only a limited number of tests and configurations I could test so ended up with two Sysbench tests to run:
- 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 four 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 only results for CFQ scheduler only
- Sysbench MyISAM read only results for DEADLINE scheduler only
- Sysbench MyISAM read only results for NOOP scheduler only
Set 2
- Sysbench MyISAM read/write results for all MySQL versions
- Sysbench MyISAM read/write results for CFQ scheduler only
- Sysbench MyISAM read/write results for DEADLINE scheduler only
- Sysbench MyISAM read/write results for NOOP scheduler only
Set 3
- Sysbench InnoDB read only results for all MySQL versions
- Sysbench InnoDB read only results for CFQ scheduler only
- Sysbench InnoDB read only results for DEADLINE scheduler only
- Sysbench InnoDB read only results for NOOP scheduler only
Set 4
- Sysbench InnoDB read/write results for all MySQL versions
- Sysbench InnoDB read/write results for CFQ scheduler only
- Sysbench InnoDB read/write results for DEADLINE scheduler only
- Sysbench InnoDB read/write results for NOOP scheduler only
Sysbench MyISAM Read Only
