{"id":147,"date":"2008-11-17T12:57:39","date_gmt":"2008-11-17T11:57:39","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=147"},"modified":"2008-11-17T12:57:39","modified_gmt":"2008-11-17T11:57:39","slug":"presentation-optimiser-mysql","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2008\/11\/17\/presentation-optimiser-mysql\/","title":{"rendered":"Pr\u00e9sentation : Optimiser MySQL"},"content":{"rendered":"<p><strong>Optimiser <\/strong>sa base de donn\u00e9e est l&rsquo;obsession principale du DBA. Savoir identifier, anticiper et r\u00e9gler les probl\u00e8mes de performances constituent une vrai valeur ajout\u00e9e et cela n&rsquo;est pas donn\u00e9 \u00e0 tout le monde.\u00a0 Satisfaction personnelle, satisfaction des d\u00e9cideurs mais surtout <strong><span style=\"text-decoration: underline;\">satisfaction du client<\/span><\/strong>&#8230;<\/p>\n<p><strong><a title=\"Opimisation de MySQL\" href=\"http:\/\/dasini.net\/blog\/presentations\/?#optimiser_mysql\" target=\"_self\">http:\/\/dasini.net\/blog\/presentations\/?#optimiser_mysql<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Optimiser sa base de donn\u00e9e est l&rsquo;obsession principale du DBA. Savoir identifier, anticiper et r\u00e9gler les probl\u00e8mes de performances constituent une vrai valeur ajout\u00e9e et cela n&rsquo;est pas donn\u00e9 \u00e0 tout le monde.  Satisfaction personnelle, satisfaction des d\u00e9cideurs maissurtout satisfaction du client&#8230;<\/p>\n<p>http:\/\/dasini.net\/blog\/presentations\/?#optimiser_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":[25,8,39],"tags":[241,245],"class_list":["post-147","post","type-post","status-publish","format-standard","hentry","category-conference","category-mysql","category-presentation","tag-mysql","tag-optimisation"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-2n","jetpack-related-posts":[{"id":817,"url":"https:\/\/dasini.net\/blog\/2009\/11\/09\/audit-et-optimisation-mysql-5\/","url_meta":{"origin":147,"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 &quot;Divers&quot;","block_context":{"text":"Divers","link":"https:\/\/dasini.net\/blog\/category\/divers\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":72,"url":"https:\/\/dasini.net\/blog\/2008\/11\/06\/conference-mysql-sun-a-paris-mercredi-19-novembre-2008\/","url_meta":{"origin":147,"position":1},"title":"Conf\u00e9rence MySQL \/ SUN \u00e0 Paris, mercredi 19 novembre 2008","author":"Olivier DASINI","date":"6 novembre 2008","format":false,"excerpt":"Mercredi 19 novembre 2008, MySQL\/SUN organise sa deuxi\u00e8me conf\u00e9rence fran\u00e7aise. Pourquoi y aller ?","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":3978,"url":"https:\/\/dasini.net\/blog\/2020\/11\/13\/webinar-astuces-et-bonnes-pratiques-pour-la-performance-mysql\/","url_meta":{"origin":147,"position":2},"title":"Webinar \u2013 Astuces et bonnes pratiques pour la performance MySQL","author":"Olivier DASINI","date":"13 novembre 2020","format":false,"excerpt":"Ce jeudi 19 novembre 2020 \u00e0 11h (CET), l\u2019\u00e9quipe MySQL France organise un webinar en fran\u00e7ais intitul\u00e9 : Astuces et bonnes pratiques pour la performance MySQL","rel":"","context":"Dans &quot;Conf\u00e9rence&quot;","block_context":{"text":"Conf\u00e9rence","link":"https:\/\/dasini.net\/blog\/category\/conference\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/ikTMA8_Gukc\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":464,"url":"https:\/\/dasini.net\/blog\/2009\/02\/26\/im-certified-are-you\/","url_meta":{"origin":147,"position":3},"title":"I&rsquo;m certified &#8211; Are you ?","author":"Olivier DASINI","date":"26 f\u00e9vrier 2009","format":false,"excerpt":"Le format de l'examen de certification MySQL change. Actuellement l'examen se d\u00e9roule sur la version 5.0 (en anglais, chinois ou japonais). Les diff\u00e9rents niveaux sont:","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":1049,"url":"https:\/\/dasini.net\/blog\/2011\/02\/25\/percona-a-paris-le-7-mars-2011\/","url_meta":{"origin":147,"position":4},"title":"Percona \u00e0 Paris le 7 mars 2011","author":"Olivier DASINI","date":"25 f\u00e9vrier 2011","format":false,"excerpt":"Le MySQL User Group Francophone (LeMug.fr) en collaboration avec Openday, vous convient \u00e0 une conf\u00e9rence gratuite le 7 mars 2011. Morgan Tocker, consultant et formateur chez Percona (experts en technologies MySQL et performance InnoDB) nous parlera d'XtraDB (moteur de stockage fork d'InnoDB).","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":887,"url":"https:\/\/dasini.net\/blog\/2010\/03\/24\/extraits-du-livre-audit-et-optimisation-%e2%80%93-mysql-5\/","url_meta":{"origin":147,"position":5},"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":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/147","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=147"}],"version-history":[{"count":3,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/147\/revisions"}],"predecessor-version":[{"id":165,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/147\/revisions\/165"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}