Wednesday, 22 April, 2009
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.
Tuesday, 21 April, 2009
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)
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)
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!
Sunday, 19 April, 2009
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 :-)