{"id":304,"date":"2017-05-22T11:59:59","date_gmt":"2017-05-22T09:59:59","guid":{"rendered":"https:\/\/jm.garreta.eu\/blog\/?p=304"},"modified":"2017-05-22T11:59:59","modified_gmt":"2017-05-22T09:59:59","slug":"ton-mysql-est-trop-slow","status":"publish","type":"post","link":"https:\/\/jm.garreta.eu\/blog\/ton-mysql-est-trop-slow\/","title":{"rendered":"Ton MySQL est trop slow"},"content":{"rendered":"

On me dit dans l’oreillette que des gens utilisent encore MySQL.<\/p>\n

Alors pour ces personnes, il faut savoir que MySQL met \u00e0 disposition un outil pour voir les requ\u00eates les plus lentes en \u00e9ditant le fichier \/etc\/mysql\/my.cnf<\/em> et en d\u00e9commentant les lignes suivantes :<\/p>\n

slow_query_log_file = \/var\/log\/mysql\/mysql-slow.log
\nslow_query_log = 1
\nlong_query_time = 1<\/code><\/p>\n

A votre disposition ensuite la commande mysqldumpslow \/var\/log\/mysql\/mysql-slow.log<\/code> pour analyser tout cela.<\/p>\n

Source<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

On me dit dans l’oreillette que des gens utilisent encore MySQL. Alors pour ces personnes, il faut savoir que MySQL met \u00e0 disposition un outil pour voir les requ\u00eates les plus lentes en \u00e9ditant le fichier \/etc\/mysql\/my.cnf et en d\u00e9commentant les lignes suivantes : slow_query_log_file = \/var\/log\/mysql\/mysql-slow.log slow_query_log = 1 long_query_time = 1 A votre … Continuer la lecture de Ton MySQL est trop slow<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"blog_gen_system_prompt":"","blog_gen_user_prompt":"","blog_gen_featured_img_prompt":"","blog_gen_inline_img_prompts":"","blog_gen_model":"","blog_gen_image_model":"","blog_gen_timestamp":"","blog_gen_type_article":"","blog_gen_longueur_cible":"","footnotes":""},"categories":[3],"tags":[117],"class_list":["post-304","post","type-post","status-publish","format-standard","hentry","category-informatique","tag-mysql"],"yoast_head":"\nTon MySQL est trop slow - Le blog de Jean-Mich<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jm.garreta.eu\/blog\/ton-mysql-est-trop-slow\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ton MySQL est trop slow - Le blog de Jean-Mich\" \/>\n<meta property=\"og:description\" content=\"On me dit dans l’oreillette que des gens utilisent encore MySQL. Alors pour ces personnes, il faut savoir que MySQL met \u00e0 disposition un outil pour voir les requ\u00eates les plus lentes en \u00e9ditant le fichier \/etc\/mysql\/my.cnf et en d\u00e9commentant les lignes suivantes : slow_query_log_file = \/var\/log\/mysql\/mysql-slow.log slow_query_log = 1 long_query_time = 1 A votre … Continuer la lecture de Ton MySQL est trop slow →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jm.garreta.eu\/blog\/ton-mysql-est-trop-slow\/\" \/>\n<meta property=\"og:site_name\" content=\"Le blog de Jean-Mich\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-22T09:59:59+00:00\" \/>\n<meta name=\"author\" content=\"jeanmich\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"jeanmich\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/ton-mysql-est-trop-slow\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/ton-mysql-est-trop-slow\\\/\"},\"author\":{\"name\":\"jeanmich\",\"@id\":\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/#\\\/schema\\\/person\\\/5ed151f48f77a878fc9d3868c8a1ed7d\"},\"headline\":\"Ton MySQL est trop slow\",\"datePublished\":\"2017-05-22T09:59:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/ton-mysql-est-trop-slow\\\/\"},\"wordCount\":64,\"commentCount\":0,\"keywords\":[\"mysql\"],\"articleSection\":[\"Informatique\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/ton-mysql-est-trop-slow\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/ton-mysql-est-trop-slow\\\/\",\"url\":\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/ton-mysql-est-trop-slow\\\/\",\"name\":\"Ton MySQL est trop slow - Le blog de Jean-Mich\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/#website\"},\"datePublished\":\"2017-05-22T09:59:59+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/#\\\/schema\\\/person\\\/5ed151f48f77a878fc9d3868c8a1ed7d\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/ton-mysql-est-trop-slow\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/ton-mysql-est-trop-slow\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/ton-mysql-est-trop-slow\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ton MySQL est trop slow\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/\",\"name\":\"Le blog de Jean-Mich\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/#\\\/schema\\\/person\\\/5ed151f48f77a878fc9d3868c8a1ed7d\",\"name\":\"jeanmich\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/816266d852c4595a2bfa578a991fa68bb8ed5e0217f3565158ca20c139873bda?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/816266d852c4595a2bfa578a991fa68bb8ed5e0217f3565158ca20c139873bda?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/816266d852c4595a2bfa578a991fa68bb8ed5e0217f3565158ca20c139873bda?s=96&d=mm&r=g\",\"caption\":\"jeanmich\"},\"url\":\"https:\\\/\\\/jm.garreta.eu\\\/blog\\\/author\\\/jeanmich\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Ton MySQL est trop slow - Le blog de Jean-Mich","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jm.garreta.eu\/blog\/ton-mysql-est-trop-slow\/","og_locale":"fr_FR","og_type":"article","og_title":"Ton MySQL est trop slow - Le blog de Jean-Mich","og_description":"On me dit dans l’oreillette que des gens utilisent encore MySQL. Alors pour ces personnes, il faut savoir que MySQL met \u00e0 disposition un outil pour voir les requ\u00eates les plus lentes en \u00e9ditant le fichier \/etc\/mysql\/my.cnf et en d\u00e9commentant les lignes suivantes : slow_query_log_file = \/var\/log\/mysql\/mysql-slow.log slow_query_log = 1 long_query_time = 1 A votre … Continuer la lecture de Ton MySQL est trop slow →","og_url":"https:\/\/jm.garreta.eu\/blog\/ton-mysql-est-trop-slow\/","og_site_name":"Le blog de Jean-Mich","article_published_time":"2017-05-22T09:59:59+00:00","author":"jeanmich","twitter_misc":{"\u00c9crit par":"jeanmich"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jm.garreta.eu\/blog\/ton-mysql-est-trop-slow\/#article","isPartOf":{"@id":"https:\/\/jm.garreta.eu\/blog\/ton-mysql-est-trop-slow\/"},"author":{"name":"jeanmich","@id":"https:\/\/jm.garreta.eu\/blog\/#\/schema\/person\/5ed151f48f77a878fc9d3868c8a1ed7d"},"headline":"Ton MySQL est trop slow","datePublished":"2017-05-22T09:59:59+00:00","mainEntityOfPage":{"@id":"https:\/\/jm.garreta.eu\/blog\/ton-mysql-est-trop-slow\/"},"wordCount":64,"commentCount":0,"keywords":["mysql"],"articleSection":["Informatique"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/jm.garreta.eu\/blog\/ton-mysql-est-trop-slow\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/jm.garreta.eu\/blog\/ton-mysql-est-trop-slow\/","url":"https:\/\/jm.garreta.eu\/blog\/ton-mysql-est-trop-slow\/","name":"Ton MySQL est trop slow - Le blog de Jean-Mich","isPartOf":{"@id":"https:\/\/jm.garreta.eu\/blog\/#website"},"datePublished":"2017-05-22T09:59:59+00:00","author":{"@id":"https:\/\/jm.garreta.eu\/blog\/#\/schema\/person\/5ed151f48f77a878fc9d3868c8a1ed7d"},"breadcrumb":{"@id":"https:\/\/jm.garreta.eu\/blog\/ton-mysql-est-trop-slow\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jm.garreta.eu\/blog\/ton-mysql-est-trop-slow\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jm.garreta.eu\/blog\/ton-mysql-est-trop-slow\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/jm.garreta.eu\/blog\/"},{"@type":"ListItem","position":2,"name":"Ton MySQL est trop slow"}]},{"@type":"WebSite","@id":"https:\/\/jm.garreta.eu\/blog\/#website","url":"https:\/\/jm.garreta.eu\/blog\/","name":"Le blog de Jean-Mich","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jm.garreta.eu\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/jm.garreta.eu\/blog\/#\/schema\/person\/5ed151f48f77a878fc9d3868c8a1ed7d","name":"jeanmich","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/816266d852c4595a2bfa578a991fa68bb8ed5e0217f3565158ca20c139873bda?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/816266d852c4595a2bfa578a991fa68bb8ed5e0217f3565158ca20c139873bda?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/816266d852c4595a2bfa578a991fa68bb8ed5e0217f3565158ca20c139873bda?s=96&d=mm&r=g","caption":"jeanmich"},"url":"https:\/\/jm.garreta.eu\/blog\/author\/jeanmich\/"}]}},"_links":{"self":[{"href":"https:\/\/jm.garreta.eu\/blog\/wp-json\/wp\/v2\/posts\/304","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jm.garreta.eu\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jm.garreta.eu\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jm.garreta.eu\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jm.garreta.eu\/blog\/wp-json\/wp\/v2\/comments?post=304"}],"version-history":[{"count":1,"href":"https:\/\/jm.garreta.eu\/blog\/wp-json\/wp\/v2\/posts\/304\/revisions"}],"predecessor-version":[{"id":305,"href":"https:\/\/jm.garreta.eu\/blog\/wp-json\/wp\/v2\/posts\/304\/revisions\/305"}],"wp:attachment":[{"href":"https:\/\/jm.garreta.eu\/blog\/wp-json\/wp\/v2\/media?parent=304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jm.garreta.eu\/blog\/wp-json\/wp\/v2\/categories?post=304"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jm.garreta.eu\/blog\/wp-json\/wp\/v2\/tags?post=304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}