{"id":57,"date":"2012-02-19T19:50:14","date_gmt":"2012-02-19T18:50:14","guid":{"rendered":"http:\/\/blog.jeremm.fr\/?p=57"},"modified":"2014-09-24T22:11:07","modified_gmt":"2014-09-24T20:11:07","slug":"commande-rapide-mysql","status":"publish","type":"post","link":"https:\/\/blog.jeremm.fr\/?p=57","title":{"rendered":"Commande rapide mysql"},"content":{"rendered":"<p>Kill tous les sleeps de plus de 10s :<\/p>\n<pre lang=\"bash\">for requete in $(mysql INFORMATION_SCHEMA -B -e'select id from PROCESSLIST where Command like \"Sleep\" and TIME >= \"10\"'| grep -v id); do \/usr\/bin\/mysqladmin kill $requete ; done<\/pre>\n<p>Kill tous les selects de plus de 10s :<\/p>\n<pre lang=\"bash\">for requete in $(mysql INFORMATION_SCHEMA -B -e'select id from PROCESSLIST where INFO like \"select%\" and TIME >= \"10\"'| grep -v id); do \/usr\/bin\/mysqladmin kill $requete ; done<\/pre>\n<p>Voir les requ\u00eates en cours :<\/p>\n<pre lang=\"bash\">mysqladmin pro<\/pre>\n<p>ou<\/p>\n<pre lang=\"bash\"> mysql -e\"show processlist\" <\/pre>\n<p>Voir les requ\u00eates en cours en entier :<\/p>\n<pre lang=\"bash\"> mysql -e\"show full processlist\" <\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Kill tous les sleeps de plus de 10s : for requete in $(mysql INFORMATION_SCHEMA -B -e&rsquo;select id from PROCESSLIST where Command like \u00ab\u00a0Sleep\u00a0\u00bb and TIME >= \u00ab\u00a010\u00a0\u00bb&lsquo;| grep -v id); do \/usr\/bin\/mysqladmin kill $requete ; done Kill tous les selects de plus de 10s : for requete in $(mysql INFORMATION_SCHEMA -B -e&rsquo;select id from PROCESSLIST <a href='https:\/\/blog.jeremm.fr\/?p=57' class='excerpt-more'>[&#8230;]<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[16,15,17],"_links":{"self":[{"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/posts\/57"}],"collection":[{"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=57"}],"version-history":[{"count":9,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/posts\/57\/revisions"}],"predecessor-version":[{"id":939,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/posts\/57\/revisions\/939"}],"wp:attachment":[{"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=57"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=57"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=57"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}