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:

 

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

mysqlscaling_myisam_readonly_all_tn

mysqlscaling_myisam_readonly_cfq_tn

mysqlscaling_myisam_readonly_deadline_tn

mysqlscaling_myisam_readonly_noop_tn

Pages: 1 2 3 4 5 6 7


Previous:
Next:



MaxCDN Site Acceleration

Get Cost Effective Content Delivery
Unbeatable speed, stats, & price
http://www.maxcdn.com



3 Comments

  1. Hi,

    Sorry for OOT but could you tell me how did you create this fancy graphs. Did you use redirection from “sysbench” command. What software have you used for graphs.

    Thank you
    Regards

  2. Hi I used Microsoft Excel spreadsheet charts :)

  3. Hi, could it be possible to change the colors, and use only one color for each specific database (the first bench is very herd to read)?

    And, if possible, use totally opposed colors (GREEN, RED, BLUE) to be able to distinguish easily who is who?

    That would be perfect!

    Thanks again for your bench, very useful!

Trackbacks/Pingbacks

  1. MySQL Benchmarks: MySQL 5.5.11 vs Percona 5.5.10-20.1 vs MariaDB 5.2.5 - InnoDB and MyISAM | vbtechsupport.com - [...] 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 …
  2. vBulletin 4.x upgrade / installs - MyISAM and InnoDB tables database size | vbtechsupport.com - [...] vBulletin owner/server administrator must be aware of. I’ve touched on this in my blog post here.Also smaller vBulletin forums …
  3. MySQL Benchmarks: MariaDB 5.2.5 custom CentOS 64bit RPM binaries - Intel optimized | vbtechsupport.com - [...] –with-atomic-ops=smp and GCC compiler –mtune option set as nocona.As I still have access to the Quad Intel Xeon L7555 …
  4. vBulletin 3.x to vBulletin 4.x/4.1.x upgrade process for large vBulletin forums | vbtechsupport.com - [...] I’d also look at upgrading your MySQL version to a better performing MySQL version such as MySQL 5.5.12, Percona …
  5. How many CPUs, RAMs can MySQL Community edition use? - SitePoint Forums - [...] cores for myisam and innodb. While 5.5.x myisam scales to 8 cpu cores and innodb to 32 cpu cores …
  6. WHM / Cpanel MySQL 5.5 support in WHM 11.32 | vbtechsupport.com - [...] option for MySQL Community releases unless you want to migrate over to better performing forks, MariaDB 5.2 or Percona …
  7. MySQL on New server, licensing? - SitePoint Forums - [...] vBulletin and wordpress sites without problems. MariaDB 5.2.x is faster though from benchmarks MySQL Benchmarks - MySQL …
  8. BuyVM OpenVZ VPS Review: Centmin Nginx installed | vbtechsupport.com - [...] 5.2.7 default MySQL server – uses more memory but faster than MySQL community versions. BenchmarksMemcached 1.4.7 server – 2x …
  9. (whatever happened to) MySQLTuner 2.0 « _ck_ says… - [...] about MySQL 5.5 finally being pushed to the newest cpanel releases – until I noticed that MyIASM benchmarks for …
  10. Optimizing My.CNF for a large forum wth a large database help - Bizzteams - [...] as it's the only performance fork to continue improve MyISAM performance as well see benchmarks at MySQL Benchmarks - …
  11. mysql 5.0.23 vs 5.5 performance benefits and upgrade issues? - Just just easy answers - [...] huge performance improvements from mysql 5.0.x to 5.5.x. Check out these benchmarks http://vbtechsupport.com/606/ and http://vbtechsupport.com/657/. Most of the focus …
Add Comment Register

Leave a Comment