« Hello World! :-) | Main | MySQL Performance: 5.4 outperforms PostgreSQL 8.3.7 @dbSTRESS ! »

Tuesday, 21 April, 2009

MySQL Performance: MySQL 5.4 and other InnoDB engines @dbSTRESS Benchmark

As you may already know, today Sun announces MySQL 5.4. It's a big step forward and I hope you'll have enough time today to follow all blog posts and other interesting related publications! :-)

I leave my colleagues to tell you what is new in 5.4 and what will come with next releases! (start with Mikael's and Allan's blogs). As well you will not have a whole story if you miss Tim's, Neel's, Richard's, Vince's, David's and many other valuable blogs posts!

From my part I want to present you some "unofficial" dbSTRESS benchmark results comparing:

  • MySQL 5.1.32
  • InnoDB plugin 1.0.3
  • MySQL 5.4.0
  • MySQL 5.Perf (experimental)
  • XtraDB

This testing is following previously published performance studies with InnoDB and XtraDB, as well zero build of Perf Version (see: dbSTRESS@ http://dimitrik.free.fr) - several enormous performance improvements was done on MySQL during last months and it's a real pleasure to see them confirmed by the benchmark results! :-)

I'm presenting here just a few graphs, and invite you to read my full benchmark report (hope you'll find it useful :-))

Read-Only Workload on 8 and 16 cores:

Read+Write Workload on 8 and 16 cores:

Full Benchmark report is published here: http://dimitrik.free.fr/db_STRESS_MySQL_540_and_others_Apr2009.html

Any comment are welcome!

Posted by Dimitri at 18:17
Categories: MySQL, Tools/ dbSTRESS
blog comments powered by Disqus
Note: if you don't see any "comment" dialog above, try to access this page with another web browser, or google for known issues on your browser and DISQUS..