{"id":1093,"date":"2011-08-01T11:09:53","date_gmt":"2011-08-01T10:09:53","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=1093"},"modified":"2011-08-01T11:09:53","modified_gmt":"2011-08-01T10:09:53","slug":"mariadb-5-3-progress-reporting","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2011\/08\/01\/mariadb-5-3-progress-reporting\/","title":{"rendered":"MariaDB 5.3, Progress reporting"},"content":{"rendered":"

Parmi les nouveaut\u00e9s de MariaDB 5.3, l’une d’entre elle, bien pratique est le \u00ab\u00a0progress reporting\u00a0\u00bb, qui permet de savoir o\u00f9 le serveur en est dans l’ex\u00e9cution d’une commande.<\/p>\n

Le principe est simple, j’ex\u00e9cute une commande et MariaDB m’indique le pourcentage effectu\u00e9 pour une \u00e9tape donn\u00e9e. Un exemple:<\/p>\n

MariaDB-5.3> ALTER TABLE client ENGINE=InnoDB;\r\nStage: 1 of 2 'copy to tmp table'\u00a0\u00a0 44.5% of stage done\r\n\r\nMariaDB-5.3> ALTER TABLE client ENGINE=InnoDB;\r\nStage: 2 of 2 'Enabling keys'\u00a0\u00a0\u00a0\u00a0\u00a0 0% of stage done\u00a0\u00a0 \u00a0\r\n\r\nMariaDB-5.3> ALTER TABLE client ENGINE=InnoDB;\r\nQuery OK, 3000000 rows affected (5 min 15.24 sec)\u00a0\u00a0\u00a0\u00a0 \u00a0\r\nRecords: 3000000\u00a0 Duplicates: 0\u00a0 Warnings: 0<\/pre>\n
Les commandes impl\u00e9mentant le \u00ab\u00a0progress reporting\u00a0\u00bb sont pour le moment:\u00a0ALTER TABLE, ADD INDEX, DROP INDEX, LOAD DATA INFILE.<\/p>\n
Le moteur Aria supporte \u00e9galement les commandes suivantes: CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, OPTIMIZE TABLE<\/p>\n
MariaDB-5.3> > CHECK TABLE aria_table;\r\nStage: 3 of 3 'Checking data'\u00a0\u00a0\u00a0\u00a0\u00a0 0% of stage done<\/pre>\n
Plus d’informations sur AskMonty.org<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
Parmi les nouveaut\u00e9s de MariaDB 5.3, l’une bien pratique est le \u00ab\u00a0progress reporting\u00a0\u00bb, qui permet de savoir o\u00f9 le serveur en est dans l’ex\u00e9cution d’une commande.<\/p>\n
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:<\/p>\n
MariaDB-5.3> ALTER TABLE client ENGINE=InnoDB;
\nStage: 1 of 2 ‘copy to tmp table’   44.5% of stage done<\/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":[88,167],"tags":[],"class_list":["post-1093","post","type-post","status-publish","format-standard","hentry","category-astuce","category-mariadb"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-hD","jetpack-related-posts":[{"id":1245,"url":"https:\/\/dasini.net\/blog\/2012\/04\/05\/mysql-5-6-rock-suite\/","url_meta":{"origin":1093,"position":0},"title":"MySQL 5.6 rock suite","author":"Olivier DASINI","date":"5 avril 2012","format":false,"excerpt":"Voici la suite du post MySQL 5.6 rock, dans lequel je test MySQL 5.5 & 5.6, MariaDB 5.3 & 5.5 et Percona server 5.5. Pour cet article, toujours un bench. Le contexte est assez proche, \u00e0 la diff\u00e9rence pr\u00e8s que cette fois les serveurs sont test\u00e9s en lecture (65%) et\u2026","rel":"","context":"Dans "bench"","block_context":{"text":"bench","link":"https:\/\/dasini.net\/blog\/category\/bench\/"},"img":{"alt_text":"dasini.net - 95 centile for R\/W i\/o bounds","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-includes\/images\/dasini.net_bench_mysql_95percentil.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1163,"url":"https:\/\/dasini.net\/blog\/2012\/01\/09\/ameliorations-de-loptimiseur-dans-mariadb\/","url_meta":{"origin":1093,"position":1},"title":"Am\u00e9liorations de l’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 "bench"","block_context":{"text":"bench","link":"https:\/\/dasini.net\/blog\/category\/bench\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1227,"url":"https:\/\/dasini.net\/blog\/2012\/03\/30\/mysql-5-6-rocks\/","url_meta":{"origin":1093,"position":2},"title":"MySQL 5.6 rock !","author":"Olivier DASINI","date":"30 mars 2012","format":false,"excerpt":"Comme d'habitude, mon but n'est pas de conna\u00eetre les possibilit\u00e9s maximales du serveur (d'autres le font mieux que moi), mais plut\u00f4t d'avoir une id\u00e9e assez pr\u00e9cise de leurs comportements respectifs dans un environnement le plus proche possible de ma prod. pour ce test, les candidats sont, Percona 5.5, MariaDB 5.3\u2026","rel":"","context":"Dans "bench"","block_context":{"text":"bench","link":"https:\/\/dasini.net\/blog\/category\/bench\/"},"img":{"alt_text":"dasini.net - 95 centile","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-includes\/images\/percentil.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1088,"url":"https:\/\/dasini.net\/blog\/2011\/07\/27\/mariadb-5-3-en-beta\/","url_meta":{"origin":1093,"position":3},"title":"MariaDB 5.3 en beta","author":"Olivier DASINI","date":"27 juillet 2011","format":false,"excerpt":"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: - subquery optimizations that finally make\u2026","rel":"","context":"Dans "MariaDB"","block_context":{"text":"MariaDB","link":"https:\/\/dasini.net\/blog\/category\/mariadb\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1413,"url":"https:\/\/dasini.net\/blog\/2013\/04\/23\/utiliser-une-sous-requete-cest-mal\/","url_meta":{"origin":1093,"position":4},"title":"Utiliser une sous-requ\u00eate c’est mal ?","author":"Olivier DASINI","date":"23 avril 2013","format":false,"excerpt":"Jusqu\u2019en MySQL 5.5 inclus, l\u2019utilisation de sous-requ\u00eates peut, dans certain cas, \u00eatre la cause de probl\u00e8mes de performances (l\u2019optimiseur est bien meilleur en MySQL 5.6, MariaDB 5.5 et MariaDB 10). R\u00e9cemment j\u2019ai eu un souci en prod, apr\u00e8s une MEP, avec une requ\u00eate qui durait en moyenne plus de 1000\u2026","rel":"","context":"Dans "MySQL"","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1261,"url":"https:\/\/dasini.net\/blog\/2012\/05\/30\/optimiser-un-alter\/","url_meta":{"origin":1093,"position":5},"title":"Optimiser un ALTER","author":"Olivier DASINI","date":"30 mai 2012","format":false,"excerpt":"Lors d'une discussion \u00e0 la caf\u00e8t, la question suivante fut pos\u00e9e : \u00ab Faire un ALTER TABLE avec plusieurs instructions est il plus rapide qu'un ALTER TABLE par instruction \u00bb ? Les 2 protagonistes n'\u00e9tant pas d'accord entre eux, c'est tout naturellement que je fus invit\u00e9 \u00e0 donner mon avis.\u2026","rel":"","context":"Dans "Astuce"","block_context":{"text":"Astuce","link":"https:\/\/dasini.net\/blog\/category\/astuce\/"},"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\/1093","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=1093"}],"version-history":[{"count":2,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/1093\/revisions"}],"predecessor-version":[{"id":1095,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/1093\/revisions\/1095"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=1093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=1093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=1093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}