{"id":1088,"date":"2011-07-27T11:40:49","date_gmt":"2011-07-27T10:40:49","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=1088"},"modified":"2011-07-27T11:40:49","modified_gmt":"2011-07-27T10:40:49","slug":"mariadb-5-3-en-beta","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2011\/07\/27\/mariadb-5-3-en-beta\/","title":{"rendered":"MariaDB 5.3 en beta"},"content":{"rendered":"<p>Cette version est bas\u00e9e sur MySQL 5.1 &amp; MariaDB 5.2.<\/p>\n<p>Ses points forts :<\/p>\n<ul>\n<li>Am\u00e9liorations sensibles des sous-requ\u00eates<\/li>\n<li>Am\u00e9liorations de l&rsquo;optimiseur avec notamment l&rsquo;impl\u00e9mentation de l&rsquo;algorithme hash join<\/li>\n<li>Support du group commit avec XtraDB<\/li>\n<li>Plugin HandlerSocket, qui permet d&rsquo;utiliser MySQL comme une base NoSQL<\/li>\n<\/ul>\n<p>je ne l&rsquo;ai pas encore essay\u00e9, mais cela ne saurait tarder \ud83d\ude42<\/p>\n<p>&nbsp;<\/p>\n<p>Plus d&rsquo;info sur <a title=\"What is MariaDB 5.3\" href=\"http:\/\/kb.askmonty.org\/en\/what-is-mariadb-53\" target=\"_blank\">Askmonty<\/a>.<\/p>\n<p><a title=\"MariaDB 5.3.0 Beta\" href=\"http:\/\/downloads.askmonty.org\/mariadb\/5.3\/\" target=\"_blank\">T\u00e9l\u00e9chargement de MariaDB 5.3.0 Beta<\/a>.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The MariaDB project would like to announce the availability of MariaDB 5.3.0 Beta, the latest addition to our growing lineup of supported software. MariaDB 5.3.0 beta includes all features in MariaDB 5.2 and is based on MySQL 5.1. Some highlights of new features include:<\/p>\n<p>&#8211; subquery optimizations that finally make subqueries usable<br \/>\n&#8211; many optimizer changes, including Classic Hash Join, Batched Key Access, a new implementation of Multi-Range-Read optimizations as well as Index Condition Pushdown<br \/>\n&#8211; NoSQL-style interfaces via the HandlerSocket plugin as well as dynamic columns<br \/>\n&#8211; group commit in XtraDB when the binary log is enabled<br \/>\n&#8211; Microsoft Windows performance improvements<\/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":[167],"tags":[250],"class_list":["post-1088","post","type-post","status-publish","format-standard","hentry","category-mariadb","tag-mariadb"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-hy","jetpack-related-posts":[{"id":1024,"url":"https:\/\/dasini.net\/blog\/2010\/12\/09\/mariadb-5-2-4-et-5-1-53-sont-disponibles\/","url_meta":{"origin":1088,"position":0},"title":"MariaDB 5.2.4 et 5.1.53 sont disponibles","author":"Olivier DASINI","date":"9 d\u00e9cembre 2010","format":false,"excerpt":"The MariaDB community is happy to announce two new releases hot off the compiler! MariaDB is a branch of the MySQL database which includes all major open source storage engines, myriad bug fixes, and many community patches. The MariaDB 5.1 release continues with MariaDB 5.1.53, while the 5.2 series moves\u2026","rel":"","context":"Dans &quot;MariaDB&quot;","block_context":{"text":"MariaDB","link":"https:\/\/dasini.net\/blog\/category\/mariadb\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1180,"url":"https:\/\/dasini.net\/blog\/2012\/02\/10\/retour-sur-le-meetup-mariadb-skysql-lemug-fr\/","url_meta":{"origin":1088,"position":1},"title":"Retour sur le Meetup MariaDB SkySQL \/ LeMUG.fr","author":"Olivier DASINI","date":"10 f\u00e9vrier 2012","format":false,"excerpt":"Voici le support de la conf\u00e9rence de Colin Charles (Monty Program Ab) du Meetup MariaDB SkySQL \/ LeMUG.fr du 1er f\u00e9vrier 2012 \u00e0 Paris. MariaDB: The new M in LAMP enjoy :)","rel":"","context":"Dans &quot;Conf\u00e9rence&quot;","block_context":{"text":"Conf\u00e9rence","link":"https:\/\/dasini.net\/blog\/category\/conference\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1169,"url":"https:\/\/dasini.net\/blog\/2012\/01\/17\/meetup-mariadb-skysql-lemug-fr\/","url_meta":{"origin":1088,"position":2},"title":"Meetup MariaDB SkySQL \/ LeMUG.fr","author":"Olivier DASINI","date":"17 janvier 2012","format":false,"excerpt":"SkySQL et Le MySQL User Group Francophone (lemug.fr) vous invitent \u00e0 une rencontre MariaDB le 1 f\u00e9vrier 2012 \u00e0 Paris, afin de d\u00e9couvrir ou approfondir vos connaissances de MariaDB, le SGBD 100% compatible avec MySQL d\u00e9velopp\u00e9 par Michael \u00ab Monty \u00bb Widenius, le p\u00e8re fondateur de MySQL. A cette occasion\u2026","rel":"","context":"Dans &quot;Conf\u00e9rence&quot;","block_context":{"text":"Conf\u00e9rence","link":"https:\/\/dasini.net\/blog\/category\/conference\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1093,"url":"https:\/\/dasini.net\/blog\/2011\/08\/01\/mariadb-5-3-progress-reporting\/","url_meta":{"origin":1088,"position":3},"title":"MariaDB 5.3, Progress reporting","author":"Olivier DASINI","date":"1 ao\u00fbt 2011","format":false,"excerpt":"Parmi les nouveaut\u00e9s de MariaDB 5.3, l'une bien pratique est le \"progress reporting\", qui permet de savoir o\u00f9 le serveur en est dans l'ex\u00e9cution d'une commande. Le principe est simple, j'ex\u00e9cute une commande et MariaDB m'indique \u00e0 le pourcentage effectu\u00e9 pour une \u00e9tape donn\u00e9e. Un exemple: MariaDB-5.3> ALTER TABLE client\u2026","rel":"","context":"Dans &quot;Astuce&quot;","block_context":{"text":"Astuce","link":"https:\/\/dasini.net\/blog\/category\/astuce\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1487,"url":"https:\/\/dasini.net\/blog\/2014\/01\/07\/update-db-set-age-age-1-where-productmysql\/","url_meta":{"origin":1088,"position":4},"title":"UPDATE db SET age = age + 1 WHERE product=&rsquo;MySQL&rsquo;","author":"Olivier DASINI","date":"7 janvier 2014","format":false,"excerpt":"2013 \u00e0 \u00e9t\u00e9 une ann\u00e9e tr\u00e8s riche en ce qui concerne l\u2019\u00e9cosyst\u00e8me MySQL \/ MariaDB \/ Percona Server. Voici un petit r\u00e9cap technique (incomplet) pour les 3 acteurs majeurs: MySQL @Oracle MariaDB & SkySQL Percona","rel":"","context":"Dans &quot;MariaDB&quot;","block_context":{"text":"MariaDB","link":"https:\/\/dasini.net\/blog\/category\/mariadb\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1163,"url":"https:\/\/dasini.net\/blog\/2012\/01\/09\/ameliorations-de-loptimiseur-dans-mariadb\/","url_meta":{"origin":1088,"position":5},"title":"Am\u00e9liorations de l&rsquo;optimiseur dans MariaDB","author":"Olivier DASINI","date":"9 janvier 2012","format":false,"excerpt":"Les \u00e9quipes de MariaDB ont \u00e9norm\u00e9ment travaill\u00e9es sur l'optimiseur de la version 5.3, notamment en permettant une r\u00e9elle utilisation des sous-requ\u00eates. Voici un effet visuel de ces optimisations: Avec MySQL 5.5, l'utilisation de tables d\u00e9riv\u00e9es (type de sous-requ\u00eates dans la clause FROM d'un SELECT), donne le plan d'ex\u00e9cution suivant:","rel":"","context":"Dans &quot;bench&quot;","block_context":{"text":"bench","link":"https:\/\/dasini.net\/blog\/category\/bench\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/1088","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=1088"}],"version-history":[{"count":3,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/1088\/revisions"}],"predecessor-version":[{"id":1091,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/1088\/revisions\/1091"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=1088"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=1088"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=1088"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}