{"id":703,"date":"2009-08-03T10:05:57","date_gmt":"2009-08-03T09:05:57","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=703"},"modified":"2009-08-07T12:46:43","modified_gmt":"2009-08-07T11:46:43","slug":"benchmark-mysql-5-4","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2009\/08\/03\/benchmark-mysql-5-4\/","title":{"rendered":"Benchmark MySQL 5.4"},"content":{"rendered":"<p><a title=\"Dimitri Kozma\" href=\"http:\/\/dimitrik.free.fr\/blog\/index.html\" target=\"_blank\"><span>Dimitri KRAVTCHUK<\/span><\/a> nous d\u00e9montre, avec une batterie de tests, les \u00e9volutions en mati\u00e8re de performance apport\u00e9es par MySQL 5.4:<\/p>\n<ul>\n<li><strong>Huge performance<\/strong> improvement on <strong>InnoDB<\/strong> engine!<\/li>\n<li> MySQL 5.4.0 \/Perf Version seems to be the <strong>most performant InnoDB implementation<\/strong> for the moment! (only except on the Read-Only workload @8cores where InnoDB plugin-1.0.3 is leading!)<\/li>\n<li> <strong>MySQL is outperforming PostgreSQL<\/strong> on my tests now!<\/li>\n<li> Regarding scalability, get a look at 8 vs 16 cores graphs, and you&rsquo;ll see it&rsquo;s the big step forward &#8211; <strong>no performance degradation on 16 cores<\/strong> is a very positive sign! and there is only 3 months distance between tests!<\/li>\n<li> LOCK_open needs a fix ASAP! \ud83d\ude42<\/li>\n<li> Analyzing my test results, it&rsquo;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&rsquo;m absolutely sure now &#8211; very quickly it&rsquo;ll perform even better! so see you soon! :-))<\/li>\n<\/ul>\n<p><a title=\"    MySQL Performance: MySQL-5.4.0 and other InnoDB engines @dbSTRESS Benchmark (Apr.2009) \" href=\"http:\/\/dimitrik.free.fr\/db_STRESS_MySQL_540_and_others_Apr2009.html\" target=\"_blank\">http:\/\/dimitrik.free.fr\/db_STRESS_MySQL_540_and_others_Apr2009.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dimitri KRAVTCHUK nous d\u00e9montre avec une batterie de tests les \u00e9volutions en mati\u00e8re de performance apport\u00e9es par MySQL 5.4:<\/p>\n<p>    * Huge performance improvement on InnoDB engine!<br \/>\n    * 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!)<br \/>\n    * MySQL is outperforming PostgreSQL on my tests now!<br \/>\n    * Regarding scalability, get a look at 8 vs 16 cores graphs, and you&rsquo;ll see it&rsquo;s the big step forward &#8211; no performance degradation on 16 cores is a very positive sign! and there is only 3 months distance between tests!<br \/>\n    * LOCK_open needs a fix ASAP! \ud83d\ude42<br \/>\n    * Analyzing my test results, it&rsquo;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&rsquo;m absolutely sure now &#8211; very quickly it&rsquo;ll perform even better! so see you soon! :-))<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[81,8],"tags":[137,136],"class_list":["post-703","post","type-post","status-publish","format-standard","hentry","category-bench","category-mysql","tag-dimitri-kravtchuk","tag-mysql-5-4"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-bl","jetpack-related-posts":[{"id":1029,"url":"https:\/\/dasini.net\/blog\/2010\/12\/15\/mysql-5-5-est-disponible\/","url_meta":{"origin":703,"position":0},"title":"MySQL 5.5 est disponible","author":"Olivier DASINI","date":"15 d\u00e9cembre 2010","format":false,"excerpt":"Oracle annonce la sortie de la toute nouvelle version de la base de donn\u00e9es open source MySQL 5.5.8. Cette version est une G.A. ((Generally Available), en d'autre terme la version \u00e0 utiliser en production. Voici le communiqu\u00e9 en version originale: MySQL 5.5 Now Generally Available New Performance and Scalability Enhancements\u2026","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1832,"url":"https:\/\/dasini.net\/blog\/2017\/03\/13\/tester-mysql-innodb-cluster\/","url_meta":{"origin":703,"position":1},"title":"Tester MySQL InnoDB Cluster","author":"Olivier DASINI","date":"13 mars 2017","format":false,"excerpt":"MySQL InnoDB Cluster est la (future) solution out-of-the-box HA de MySQL (\u00e0 ne pas confondre avec MySQL NDB Cluster). Ce produit est compos\u00e9 de 3 \u00e9l\u00e9ments : MySQL Group Replication Plugin de r\u00e9plication multi-ma\u00eetre, avec r\u00e9solution de conflits et basculement (failover) automatique. MySQL Router Middleware l\u00e9ger et performant qui fournit\u2026","rel":"","context":"Dans &quot;Group Replication&quot;","block_context":{"text":"Group Replication","link":"https:\/\/dasini.net\/blog\/category\/group-replication\/"},"img":{"alt_text":"MySQL InnoDB Cluster Architecture","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/MySQL_InnoDB_Cluster_Architecture.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2549,"url":"https:\/\/dasini.net\/blog\/2018\/08\/21\/tutoriel-deployer-mysql-5-7-innodb-cluster\/","url_meta":{"origin":703,"position":2},"title":"Tutoriel \u2013 D\u00e9ployer MySQL 5.7 InnoDB Cluster","author":"Olivier DASINI","date":"21 ao\u00fbt 2018","format":false,"excerpt":"L'un des principaux besoins de mes clients est la\u00a0Haute Disponibilit\u00e9 avec MySQL. On va voir, dans cet article, comment d\u00e9ployer et g\u00e9rer un cluster MySQL 5.7 \"from scratch\"\u00a0, sous la forme d'un tutoriel, gr\u00e2ce \u00e0 la solution HA tout en un : MySQL 5.7 InnoDB Cluster.","rel":"","context":"Dans &quot;Group Replication&quot;","block_context":{"text":"Group Replication","link":"https:\/\/dasini.net\/blog\/category\/group-replication\/"},"img":{"alt_text":"MySQL InnoDB Cluster PoC Architecture","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/MySQL_InnoDB_Cluster_Production_post2.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/MySQL_InnoDB_Cluster_Production_post2.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/MySQL_InnoDB_Cluster_Production_post2.png?resize=525%2C300 1.5x"},"classes":[]},{"id":2731,"url":"https:\/\/dasini.net\/blog\/2018\/11\/23\/slides-du-mysql-day-paris-2018-nosql-sql-mysql\/","url_meta":{"origin":703,"position":3},"title":"Slides du MySQL Day Paris 2018 \u2013 NoSQL + SQL = MySQL","author":"Olivier DASINI","date":"23 novembre 2018","format":false,"excerpt":"Au nom de toute l'\u00e9quipe MySQL, je souhaite vous remercier pour votre pr\u00e9sence ! On a certes d\u00fb un peu pousser les murs (sorry for that), mais finalement cela n'a fait que contribuer \u00e0 rendre l'\u00e9v\u00e9nement encore plus convivial :) Et voici les slides:","rel":"","context":"Dans &quot;audit&quot;","block_context":{"text":"audit","link":"https:\/\/dasini.net\/blog\/category\/audit\/"},"img":{"alt_text":"MySQL 8 is Great","src":"https:\/\/i0.wp.com\/pbs.twimg.com\/media\/DsmMn7HXcAApacW.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/pbs.twimg.com\/media\/DsmMn7HXcAApacW.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/pbs.twimg.com\/media\/DsmMn7HXcAApacW.jpg?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":1044,"url":"https:\/\/dasini.net\/blog\/2011\/02\/01\/un-disque-ssd-comme-buffer-pour-innodb\/","url_meta":{"origin":703,"position":4},"title":"Un disque SSD comme buffer pour InnoDB","author":"Olivier DASINI","date":"1 f\u00e9vrier 2011","format":false,"excerpt":"MySQL, la base de donn\u00e9es open source la plus populaire, inspire toujours autant les d\u00e9veloppeurs. David, propose un patch qui permet de cr\u00e9er un buffer pool suppl\u00e9mentaire pour InnoDB, qui est stock\u00e9 sur un disque SSD ou de la m\u00e9moire flash. Cette fonctionnalit\u00e9 cr\u00e9\u00e9e un thread qui en tache de\u2026","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1654,"url":"https:\/\/dasini.net\/blog\/2016\/10\/05\/mysql-a-oracle-openworld-2016\/","url_meta":{"origin":703,"position":5},"title":"MySQL \u00e0 Oracle OpenWorld 2016","author":"Olivier DASINI","date":"5 octobre 2016","format":false,"excerpt":"R\u00e9sum\u00e9 des annonces MySQL \u00e0 Oracle OpenWorld: MySQL dans le cloud, MySQL Group Replication, MySQL InnoDB Cluster, MySQL 8,...","rel":"","context":"Dans &quot;Group Replication&quot;","block_context":{"text":"Group Replication","link":"https:\/\/dasini.net\/blog\/category\/group-replication\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/Oracle_MySQL_Cloud_Service.png?resize=350%2C200","width":350,"height":200},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/703","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/comments?post=703"}],"version-history":[{"count":4,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/703\/revisions"}],"predecessor-version":[{"id":712,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/703\/revisions\/712"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}