{"version":"1.0","provider_name":"Le blog de Jean-Mich","provider_url":"https:\/\/jm.garreta.eu\/blog","author_name":"jeanmich","author_url":"https:\/\/jm.garreta.eu\/blog\/author\/jeanmich\/","title":"Ton MySQL est trop slow - Le blog de Jean-Mich","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"GLaerXpRTx\"><a href=\"https:\/\/jm.garreta.eu\/blog\/ton-mysql-est-trop-slow\/\">Ton MySQL est trop slow<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/jm.garreta.eu\/blog\/ton-mysql-est-trop-slow\/embed\/#?secret=GLaerXpRTx\" width=\"600\" height=\"338\" title=\"\u00ab\u00a0Ton MySQL est trop slow\u00a0\u00bb &#8212; Le blog de Jean-Mich\" data-secret=\"GLaerXpRTx\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/jm.garreta.eu\/blog\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","description":"On me dit dans l&rsquo;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 &hellip; Continuer la lecture de  &rarr;"}