{"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":2959,"url":"https:\/\/dasini.net\/blog\/2019\/04\/08\/200\/","url_meta":{"origin":147,"position":5},"title":"200 !!","author":"Olivier DASINI","date":"8 avril 2019","format":false,"excerpt":"Cet article est en fait mon 200 \u00e8me \\o\/ Pour marquer le coup, j'ai d\u00e9cid\u00e9 de faire une petite pause et de regarder dans le r\u00e9troviseur...","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":[]}],"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}]}}