3
août

Benchmark MySQL 5.4

   Posted by: freshdaz   in bench, MySQL

Dimitri KRAVTCHUK nous démontre, avec une batterie de tests, les évolutions en matière de performance apportées par MySQL 5.4:

  • Huge performance improvement on InnoDB engine!
  • MySQL 5.4.0 /Perf Version seems to be the most performant InnoDB implementation for the moment! (only except on the Read-Only workload @8cores where InnoDB plugin-1.0.3 is leading!)
  • MySQL is outperforming PostgreSQL on my tests now!
  • Regarding scalability, get a look at 8 vs 16 cores graphs, and you’ll see it’s the big step forward – no performance degradation on 16 cores is a very positive sign! and there is only 3 months distance between tests!
  • LOCK_open needs a fix ASAP! :-)
  • Analyzing my test results, it’s too early to say InnoDB is scaling up to 16 cores, but the test results on 16 cores are already outperforming 8 cores, and I’m absolutely sure now – very quickly it’ll perform even better! so see you soon! :-) )

http://dimitrik.free.fr/db_STRESS_MySQL_540_and_others_Apr2009.html

Tags: ,

This entry was posted on Lundi, août 3rd, 2009 at 10:05 and is filed under bench, MySQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 comments so far

Dimitri
 1 

Ce n’est pas Dimitri Kozma mais Dimitri KRAVTCHUK :-)

Rgds,
-Dimitri

août 7th, 2009 at 12:40
freshdaz
 2 

ouppsss
désolé, je me doutais qu’il y avait un truc de bizarre, mais mes recherches ne m’ont pas permises de trouver la faille :(
Merci Dimitri KRAVTCHUK, je rectifie ;)
P.S. J’en profite pour te remercier également pour les benchs !

août 7th, 2009 at 12:44
Dimitri
 3 

Merci! :-)

août 7th, 2009 at 15:23

Leave a reply

Name (*)
Mail (will not be published) (*)
URI
Comment