{"id":857,"date":"2010-03-09T17:16:41","date_gmt":"2010-03-09T16:16:41","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=857"},"modified":"2010-03-25T14:50:19","modified_gmt":"2010-03-25T13:50:19","slug":"audit-et-optimisation-mysql-5-2","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2010\/03\/09\/audit-et-optimisation-mysql-5-2\/","title":{"rendered":"Sortie du livre: Audit et optimisation – MySQL 5"},"content":{"rendered":"

Pascal Borghino, Olivier Dasini, Arnaud Gadal et Eyrolles ont l’honneur de vous annoncer la sortie du livre Audit et optimisation MySQL 5<\/span><\/strong>.<\/p>\n

\"Bonnes<\/a>

Pour la premi\u00e8re fois, les meilleurs experts de chez Yahoo!, Orange Business Services et Virgin mobile livrent leur exp\u00e9rience de terrain... en fran\u00e7ais <\/p><\/div>\n

Editeur : EYROLLES | Langue : Fran\u00e7ais | ISBN-10: 2212126344 | ISBN-13: 978-2212126341<\/span><\/p>\n

A l’occasion du salon Solutions Linux\/Open Source qui se tiendra du 16 au 18 mars \u00e0\u00a0Paris Expo-Porte de Versailles, cet ouvrage sera disponible en exclusivit\u00e9 et en avant-premi\u00e8re sur le stand Eyrolles (n\u00b0C35).<\/strong><\/span><\/p>\n

L’ouvrage sera disponible en librairie le 25 mars 2010<\/strong><\/span>. Vous pouvez cependant d\u00e9j\u00e0 le commander sur les sites sp\u00e9cialis\u00e9s (fnac<\/a>, amazon.fr<\/a>, eyrolles<\/a>,\u00a0Lavoisier<\/a>, decitre<\/a>. cine-memento.fr<\/a>,… )<\/p>\n

Au sommaire<\/span>:<\/p>\n

CHAPITRE 1<\/div>\n
G\u00e9rer une situation d’urgence avec MySQL ………………………….. 1<\/div>\n
CHAPITRE 2<\/div>\n
Choisir son serveur MySQL ………………………………………………… 19<\/div>\n
CHAPITRE 3<\/div>\n
Les moteurs de stockage …………………………………………………… 49<\/div>\n
CHAPITRE 4<\/div>\n
Surveiller son serveur MySQL…………………………………………….. 81<\/div>\n
CHAPITRE 5<\/div>\n
Exploiter les journaux de MySQL ……………………………………… 141<\/div>\n
CHAPITRE 6<\/div>\n
Optimiser sa base de donn\u00e9es : du sch\u00e9ma aux requ\u00eates ………. 163<\/div>\n
CHAPITRE 7<\/div>\n
Optimiser son serveur mySQL ………………………………………….. 193<\/div>\n
CHAPITRE 8<\/div>\n
La r\u00e9plication MySQL ………………………………………………………. 217<\/div>\n
CHAPITRE 9<\/div>\n
O\u00f9 trouver de l’aide ? ……………………………………………………… 253<\/div>\n","protected":false},"excerpt":{"rendered":"

Pascal Borghino, Olivier Dasini, Arnaud Gadal et Eyrolles sont heureux de vous annoncer la sortie du livre Audit et optimisation MySQL 5.<\/p>\n

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 avant-premi\u00e8re sur le stand Eyrolles (n\u00b0C35). <\/p>\n

L’ouvrage sera disponible en librairie le 25 mars 2010. Vous pouvez cependant d\u00e9j\u00e0 le commander sur les site sp\u00e9cialis\u00e9s.<\/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":[249,155,241,245],"class_list":["post-857","post","type-post","status-publish","format-standard","hentry","category-divers","category-mysql","tag-audit","tag-livre","tag-mysql","tag-optimisation"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-dP","jetpack-related-posts":[{"id":817,"url":"https:\/\/dasini.net\/blog\/2009\/11\/09\/audit-et-optimisation-mysql-5\/","url_meta":{"origin":857,"position":0},"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 "Divers"","block_context":{"text":"Divers","link":"https:\/\/dasini.net\/blog\/category\/divers\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"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":857,"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 "Divers"","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":857,"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 "Divers"","block_context":{"text":"Divers","link":"https:\/\/dasini.net\/blog\/category\/divers\/"},"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":857,"position":3},"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 "json"","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":[]},{"id":1269,"url":"https:\/\/dasini.net\/blog\/2012\/06\/04\/php-day-le-04-juin-2012\/","url_meta":{"origin":857,"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 "Conf\u00e9rence"","block_context":{"text":"Conf\u00e9rence","link":"https:\/\/dasini.net\/blog\/category\/conference\/"},"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":857,"position":5},"title":"Audit MySQL – tmp_table_size & 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 "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\/857","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=857"}],"version-history":[{"count":22,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/857\/revisions"}],"predecessor-version":[{"id":2980,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/857\/revisions\/2980"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}