{"id":817,"date":"2009-11-09T16:04:45","date_gmt":"2009-11-09T15:04:45","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=817"},"modified":"2019-04-08T13:10:44","modified_gmt":"2019-04-08T12:10:44","slug":"audit-et-optimisation-mysql-5","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2009\/11\/09\/audit-et-optimisation-mysql-5\/","title":{"rendered":"Audit et optimisation MySQL 5"},"content":{"rendered":"<p><strong>Arnaud Gadal<\/strong> DBA MySQL \u00e0 <a title=\"Virgin Mobile\" href=\"http:\/\/www.virginmobile.fr\/\" target=\"_blank\" rel=\"noopener noreferrer\">Virgin Mobile<\/a>, <strong>Pascal Borghino<\/strong> architecte base de donn\u00e9es \u00e0 <a title=\"yahoo!\" href=\"http:\/\/m.fr.yahoo.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Yahoo<\/a>! (mes potos de <a title=\"Dbnews\" href=\"http:\/\/www.dbnewz.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">dbnewz<\/a>) et moi, venons juste de terminer l&rsquo;\u00e9criture d&rsquo;un livre consacr\u00e9 \u00e0 l&rsquo;audit et \u00e0 l&rsquo;optimisation d&rsquo;un serveur MySQL.<br \/>\nA travers cet ouvrage, nous avons essay\u00e9 de synth\u00e9tiser nos diff\u00e9rentes exp\u00e9riences pour vous aider \u00e0 tirer le meilleur de votre base de donn\u00e9es. Dans le livre nous abordons des sujets comme les architectures de r\u00e9plication, le tuning du serveur, les moteurs de stockage, les logs&#8230;<br \/>\n<strong><span style=\"color: #ff0000;\">Audit &amp; optimisation MySQL 5<\/span> <\/strong>est \u00e9dit\u00e9 par <a title=\"Eyrolles\" href=\"http:\/\/www.eyrolles.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">eyrolles<\/a> et devrait \u00eatre disponible d&rsquo;ici 4 \u00e0 6 semaines<\/p>\n<p>\u00e0 suivre&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Arnaud Gadal DBA MySQL \u00e0 Virgin Mobile, Pascal Borghino architecte base de donn\u00e9es \u00e0 Yahoo! (mes potos de dbnewz) et moi, venons juste de terminer l&rsquo;\u00e9criture d&rsquo;un livre consacr\u00e9 \u00e0 l&rsquo;audit et \u00e0 l&rsquo;optimisation d&rsquo;un serveur MySQL.<br \/>\nA travers cet ouvrage, nous avons essay\u00e9s de synth\u00e9tiser nos diff\u00e9rentes exp\u00e9riences pour vous aider \u00e0 tirer le meilleur de votre base de donn\u00e9es. Dans le livre nous abordons des sujets comme les architectures de r\u00e9plication, le tuning du serveur, les moteurs de stockage, les logs&#8230;<br \/>\nAudit &#038; optimisation MySQL 5 eet \u00e9dit\u00e9 par eyrolles et devrait \u00eatre disponible d&rsquo;ici 4 \u00e0 6 semaines<\/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":[3,8],"tags":[154,155],"class_list":["post-817","post","type-post","status-publish","format-standard","hentry","category-divers","category-mysql","tag-audit-optimisation-mysql-5","tag-livre"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-db","jetpack-related-posts":[{"id":857,"url":"https:\/\/dasini.net\/blog\/2010\/03\/09\/audit-et-optimisation-mysql-5-2\/","url_meta":{"origin":817,"position":0},"title":"Sortie du livre: Audit et optimisation &#8211; MySQL 5","author":"Olivier DASINI","date":"9 mars 2010","format":false,"excerpt":"Pascal Borghino, Olivier Dasini, Arnaud Gadal et Eyrolles sont heureux de vous annoncer la sortie du livre Audit et optimisation MySQL 5. A l'occasion du salon Solutions Linux\/Open Source qui se tiendra du 16 au 18 mars \u00e0 Paris Expo-Porte de Versailles, cet ouvrage sera disponible en exclusivit\u00e9 et en\u2026","rel":"","context":"Dans &quot;Divers&quot;","block_context":{"text":"Divers","link":"https:\/\/dasini.net\/blog\/category\/divers\/"},"img":{"alt_text":"Bonnes pratiques pour l'administrateur","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-includes\/images\/blog\/OptimiMySQL5_400x238.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":887,"url":"https:\/\/dasini.net\/blog\/2010\/03\/24\/extraits-du-livre-audit-et-optimisation-%e2%80%93-mysql-5\/","url_meta":{"origin":817,"position":1},"title":"Extraits du livre Audit et optimisation \u2013 MySQL 5","author":"Olivier DASINI","date":"24 mars 2010","format":false,"excerpt":"A l'occasion de la sortie du livre \"Audit et optimisation MySQL 5\", Arnaud Gadal et Pascal Borghino blogueurs sur dbnewz et Olivier Dasini vous offrent 3 extraits du livre: L'avant propos: Avant-propos Le sommaire: Table des mati\u00e8res le chapitre 1 (int\u00e9gral): G\u00e9rer une situation d'urgence avec MySQL","rel":"","context":"Dans &quot;Divers&quot;","block_context":{"text":"Divers","link":"https:\/\/dasini.net\/blog\/category\/divers\/"},"img":{"alt_text":"Bonnes pratiques pour l'administrateur","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-includes\/images\/blog\/OptimiMySQL5_c1_130x158.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":839,"url":"https:\/\/dasini.net\/blog\/2010\/01\/08\/resolutions-pour-l%e2%80%99annee-2010\/","url_meta":{"origin":817,"position":2},"title":"R\u00e9solutions pour l\u2019ann\u00e9e 2010","author":"Olivier DASINI","date":"8 janvier 2010","format":false,"excerpt":"Une ann\u00e9e 2009 tr\u00e8s riche pour moi o\u00f9 j\u2019ai d\u00e9couvert la Croatie, la Turquie (que je vous recommande d\u2019ailleurs) et red\u00e9couvert la Hongrie (ses thermes... que du bonheur !), mais qui m\u2019a surtout permis d\u2019\u00e9voluer professionnellement. En effet apr\u00e8s 5 ann\u00e9es de bons et loyaux services j\u2019ai quitt\u00e9 Anaska (Alter\u2026","rel":"","context":"Dans &quot;Divers&quot;","block_context":{"text":"Divers","link":"https:\/\/dasini.net\/blog\/category\/divers\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":912,"url":"https:\/\/dasini.net\/blog\/2010\/05\/28\/audit-mysql-tmp_table_size-max_heap_table_size\/","url_meta":{"origin":817,"position":3},"title":"Audit MySQL &#8211; tmp_table_size &#038; max_heap_table_size","author":"Olivier DASINI","date":"28 mai 2010","format":false,"excerpt":"Je suis amen\u00e9 \u00e0 r\u00e9aliser r\u00e9guli\u00e8rement des audits de serveurs MySQL.Voici le premier volet d'une s\u00e9rie d'articles o\u00f9 je vais essayer de vous donner quelques points cl\u00e9s pour mieux comprendre le fonctionnement de MySQL. La configuration du serveur est un des points que je regarde, et l'une des erreurs les\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":147,"url":"https:\/\/dasini.net\/blog\/2008\/11\/17\/presentation-optimiser-mysql\/","url_meta":{"origin":817,"position":4},"title":"Pr\u00e9sentation : Optimiser MySQL","author":"Olivier DASINI","date":"17 novembre 2008","format":false,"excerpt":"Optimiser sa base de donn\u00e9e est l'obsession principale du DBA. Savoir identifier, anticiper et r\u00e9gler les probl\u00e8mes de performances constituent une vrai valeur ajout\u00e9e et cela n'est pas donn\u00e9 \u00e0 tout le monde. Satisfaction personnelle, satisfaction des d\u00e9cideurs maissurtout satisfaction du client... http:\/\/dasini.net\/blog\/presentations\/?#optimiser_mysql","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":1557,"url":"https:\/\/dasini.net\/blog\/2015\/11\/30\/json-et-colonnes-generees-avec-mysql\/","url_meta":{"origin":817,"position":5},"title":"JSON et colonnes g\u00e9n\u00e9r\u00e9es avec MySQL","author":"Olivier DASINI","date":"30 novembre 2015","format":false,"excerpt":"Le 24 novembre dernier, lors du Forum PHP, Tomas Ulin (Oracle's MySQL VP of Engineering) a parl\u00e9 de l'utilisation de JSON dans MySQL \"MySQL 5.7 & JSON: New opportunities for developers\". Voici les r\u00e9ponses \u00e0 quelques questions qui m'ont \u00e9t\u00e9 pos\u00e9es: Comment se comporte mysqldump avec les colonnes g\u00e9n\u00e9r\u00e9es ?\u2026","rel":"","context":"Dans &quot;json&quot;","block_context":{"text":"json","link":"https:\/\/dasini.net\/blog\/category\/json-fr\/"},"img":{"alt_text":"JSON","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/json_icon.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\/817","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=817"}],"version-history":[{"count":5,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/817\/revisions"}],"predecessor-version":[{"id":2979,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/817\/revisions\/2979"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=817"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}