{"id":887,"date":"2010-03-24T19:32:42","date_gmt":"2010-03-24T18:32:42","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=887"},"modified":"2010-03-29T13:45:18","modified_gmt":"2010-03-29T12:45:18","slug":"extraits-du-livre-audit-et-optimisation-%e2%80%93-mysql-5","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2010\/03\/24\/extraits-du-livre-audit-et-optimisation-%e2%80%93-mysql-5\/","title":{"rendered":"Extraits du livre Audit et optimisation \u2013 MySQL 5"},"content":{"rendered":"<div style=\"width: 140px\" class=\"wp-caption alignright\"><a href=\"http:\/\/dasini.net\/blog\/bibliotheque\/#audit_optimisation_mysql5\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" title=\"Audit et optimisation - MySQL 5\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-includes\/images\/blog\/OptimiMySQL5_c1_130x158.png?resize=130%2C158\" alt=\"Bonnes pratiques pour l'administrateur\" width=\"130\" height=\"158\" \/><\/a><p class=\"wp-caption-text\">Audit &amp; optimisation MySQL 5<\/p><\/div>\n<p>A l&rsquo;occasion de la sortie du livre \u00ab\u00a0<a title=\"Audit et optimisation MySQL 5, bonnes pratiques pour l'administrateur\" href=\"http:\/\/dasini.net\/blog\/bibliotheque\/#audit_optimisation_mysql5\" target=\"_self\">Audit et optimisation MySQL 5<\/a>\u00ab\u00a0, <strong>Arnaud Gadal<\/strong> et <strong>Pascal Borghino<\/strong> blogueurs sur <a title=\"dbnewz\" href=\"http:\/\/www.dbnewz.com\/\" target=\"_blank\">dbnewz<\/a> et <strong>Olivier Dasini<\/strong> vous offrent 3 extraits du livre:<\/p>\n<ul>\n<li>L&rsquo;avant propos: <a title=\"Audit et optimisation MySQL 5, avant-propos\" href=\"http:\/\/www.dbnewz.com\/2010\/03\/24\/trois-pdf-de-mysql-5-audit-et-optimisation-a-telecharger\" target=\"_blank\">Avant-propos<\/a><\/li>\n<li>Le sommaire: <a title=\"Audit et optimisation MySQL 5, Table des mati\u00e8res\" href=\"http:\/\/www.dbnewz.com\/2010\/03\/24\/trois-pdf-de-mysql-5-audit-et-optimisation-a-telecharger\" target=\"_blank\">Table des mati\u00e8res<\/a><\/li>\n<li>le chapitre 1 (int\u00e9gral): <a title=\"Audit et optimisation MySQL 5, chapitre 1\" href=\"http:\/\/dasini.net\/blog\/wp-includes\/pdf\/chap1_mysql5_audit_optimisation.pdf\" target=\"_blank\">G\u00e9rer une situation d&rsquo;urgence avec MySQL<\/a><\/li>\n<\/ul>\n<p>Enjoy !<\/p>\n<p><em><span style=\"color: #0000ff;\">Le 29\/03\/2010<\/span><\/em><\/p>\n<div id=\"_mcePaste\"><em><span style=\"color: #0000ff;\">Classement parmi les ventes Amazon.fr : 1.305 en Livres<\/span><\/em><\/div>\n<p style=\"text-align: left;\"><em><span style=\"color: #0000ff;\">\u00ab\u00a0<\/span><\/em><span style=\"color: #ff0000;\"><em><span style=\"color: #ff0000;\"><strong>Audit et optimisation &#8211; MySQL 5<\/strong><\/span><\/em><\/span><em><span style=\"color: #0000ff;\">\u00a0\u00bb est tr\u00e8s appr\u00e9ci\u00e9 dans ces rubriques :<\/span><\/em><\/p>\n<p style=\"text-align: left;\"><em><span style=\"color: #0000ff;\">n\u00b0<\/span><\/em><span style=\"color: #ff0000;\"><em><span style=\"color: #ff0000;\"><strong>1<\/strong><\/span><\/em><\/span><em><span style=\"color: #0000ff;\"> dans la rubrique Livres &gt; Informatique et Internet &gt; Bases de donn\u00e9es &gt; SQL<\/span><\/em><\/p>\n<p style=\"text-align: left;\"><em><span style=\"color: #0000ff;\">n\u00b0<\/span><\/em><span style=\"color: #ff0000;\"><em><span style=\"color: #ff0000;\"><strong>1<\/strong><\/span><\/em><\/span><em><span style=\"color: #0000ff;\"> dans la rubrique Livres &gt; Informatique et Internet &gt; Bases de donn\u00e9es &gt; Logiciels &gt; MySQL<\/span><\/em><\/p>\n<p style=\"text-align: left;\"><em><span style=\"color: #0000ff;\">n\u00b0<\/span><\/em><span style=\"color: #ff0000;\"><em><span style=\"color: #ff0000;\"><strong>1<\/strong><\/span><\/em><\/span><em><span style=\"color: #0000ff;\"> dans la rubrique Livres &gt; Informatique et Internet &gt; Linux et logiciels libres &gt; MySQL<\/span><\/em><\/p>\n<p><a title=\"Audit et optimisation - MySQL 5, bonnes pratiques pour l'administrateur\" href=\"http:\/\/www.amazon.fr\/Audit-optimisation-Bonnes-pratiques-ladministrateur\/dp\/2212126344\" target=\"_blank\"><span style=\"color: #0000ff;\">http:\/\/www.amazon.fr\/Audit-optimisation-Bonnes-pratiques-ladministrateur\/dp\/2212126344<\/span><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A l&rsquo;occasion de la sortie du livre \u00ab\u00a0Audit et optimisation MySQL 5\u00a0\u00bb, Arnaud Gadal et Pascal Borghino blogueurs sur dbnewz et Olivier Dasini vous offrent 3 extraits du livre:<\/p>\n<p>L&rsquo;avant propos: Avant-propos<br \/>\nLe sommaire: Table des mati\u00e8res<br \/>\nle chapitre 1 (int\u00e9gral): G\u00e9rer une situation d&rsquo;urgence avec MySQL<\/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],"class_list":["post-887","post","type-post","status-publish","format-standard","hentry","category-divers","category-mysql","tag-audit-optimisation-mysql-5"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-ej","jetpack-related-posts":[{"id":857,"url":"https:\/\/dasini.net\/blog\/2010\/03\/09\/audit-et-optimisation-mysql-5-2\/","url_meta":{"origin":887,"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":817,"url":"https:\/\/dasini.net\/blog\/2009\/11\/09\/audit-et-optimisation-mysql-5\/","url_meta":{"origin":887,"position":1},"title":"Audit et optimisation MySQL 5","author":"Olivier DASINI","date":"9 novembre 2009","format":false,"excerpt":"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'\u00e9criture d'un livre consacr\u00e9 \u00e0 l'audit et \u00e0 l'optimisation d'un serveur MySQL. A travers cet ouvrage, nous avons essay\u00e9s de synth\u00e9tiser nos diff\u00e9rentes exp\u00e9riences pour\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":839,"url":"https:\/\/dasini.net\/blog\/2010\/01\/08\/resolutions-pour-l%e2%80%99annee-2010\/","url_meta":{"origin":887,"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":887,"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":1269,"url":"https:\/\/dasini.net\/blog\/2012\/06\/04\/php-day-le-04-juin-2012\/","url_meta":{"origin":887,"position":4},"title":"PHP DAY le 04 juin 2012","author":"Olivier DASINI","date":"4 juin 2012","format":false,"excerpt":"Ce lundi 04 juin 2012, SUP\u2019INTERNET et EPITECH organisent le PHP DAY, avec en guest star Rasmus Lerdorf, au CAMPUS TECHNOLOGIQUE DE IONIS EPITECH-SUP'INTERNET 14-16 rue Voltaire 94276 Kremlin Bic\u00eatre Cedex","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":887,"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\/887","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=887"}],"version-history":[{"count":11,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/887\/revisions"}],"predecessor-version":[{"id":890,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/887\/revisions\/890"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=887"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=887"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=887"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}