« May 2009 | Main

Wednesday, 22 April, 2009

dbSTRESS Benchmark kit updated!

In case you also want to replay the same dbSTRESS test scenarios I've posted results yesterday, I've added into the test kit a shell script which may be used as a Reference Scenario.

More details on how to use it is here .
As well dbSTRESS kit and User Guide are available for download from http://dimitrik.free.fr

Tuesday, 21 April, 2009

MySQL Performance: 5.4 outperforms PostgreSQL 8.3.7 @dbSTRESS !

Forget to say, I've also tested PostgreSQL 8.3.7 during the last benchmark serie with dbSTRESS!

A big surprise - if two years ago on the same workload PostgreSQL was two times faster (see: http://dimitrik.free.fr/db_STRESS_BMK_Part2_ZFS.html ), now it's MySQL 5.4 outperforming PostgreSQL!

  • Read-Only workload: MySQL is near two times faster now! (13.500 TPS vs ~7.000 TPS for PostgreSQL)

  • Read+Write workload: MySQL performs as well or better (7.000-8.000 TPS vs 6.000-7.000 TPS for PostgreSQL)

For more details: http://dimitrik.free.fr/db_STRESS_MySQL_540_and_others_Apr2009.html#note_5443

Posted by Dimitri at 18:36 - Comments...
Categories: MySQL, PostgreSQL, Tools/ IObench

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 - Comments...
Categories: MySQL, Tools/ dbSTRESS

Sunday, 19 April, 2009

Hello World! :-)

Did not expected to write any blog until today, but seems it's the most adapted news sharing solution :-)
Will try to adapt it now...

My main home page is http://dimitrik.free.fr
And blog entries will be used as news feeds rather to tell you my life :-)

Posted by Dimitri at 14:21 - Comments...
Categories: x-files...