{"id":496,"date":"2012-04-19T11:55:08","date_gmt":"2012-04-19T09:55:08","guid":{"rendered":"http:\/\/blog.jeremm.fr\/?p=496"},"modified":"2014-09-24T21:21:19","modified_gmt":"2014-09-24T19:21:19","slug":"mysql-kill-les-longs-sleep-ou-select","status":"publish","type":"post","link":"https:\/\/blog.jeremm.fr\/?p=496","title":{"rendered":"Mysql : kill les longs Sleep ou Select"},"content":{"rendered":"<p>Cr\u00e9ez ce script et lancez le r\u00e9guli\u00e8rement avec un cron :<\/p>\n<pre lang=\"bash\">#!\/bin\/bash\r\n\r\nUSER=root\r\nPASS=XXXXXX\r\nTIME=120\r\nmysql=\/usr\/bin\/mysql\r\ngrep=\/bin\/grep\r\nmysqladmin=\/usr\/bin\/mysqladmin\r\n\r\n## KILL SLEEP > $TIME\r\nfor requete in $($mysql -u$USER -p$PASS INFORMATION_SCHEMA -B -e'select id from PROCESSLIST where Command like \"Sleep\" and TIME >= \"'$TIME'\"'| $grep -v id); do \r\n       $mysqladmin -u$USER -p$PASS kill $requete \r\ndone\r\n\r\n## KILL SELECT > $TIME\r\nfor requete in $($mysql -u$USER -p$PASS INFORMATION_SCHEMA -B -e'select id from PROCESSLIST where INFO like \"select%\" and TIME >= \"'$TIME'\"'| $grep -v id); do \r\n       $mysqladmin -u$USER -p$PASS kill $requete \r\ndone\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Cr\u00e9ez ce script et lancez le r\u00e9guli\u00e8rement avec un cron : #!\/bin\/bash USER=root PASS=XXXXXX TIME=120 mysql=\/usr\/bin\/mysql grep=\/bin\/grep mysqladmin=\/usr\/bin\/mysqladmin ## KILL SLEEP > $TIME for requete in $($mysql -u$USER -p$PASS INFORMATION_SCHEMA -B -e&rsquo;select id from PROCESSLIST where Command like \u00ab\u00a0Sleep\u00a0\u00bb and TIME >= \u00ab\u00a0&lsquo;$TIME'\u00a0\u00bb&lsquo;| $grep -v id); do $mysqladmin -u$USER -p$PASS kill $requete done ## KILL <a href='https:\/\/blog.jeremm.fr\/?p=496' 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,61],"_links":{"self":[{"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/posts\/496"}],"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=496"}],"version-history":[{"count":10,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/posts\/496\/revisions"}],"predecessor-version":[{"id":899,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/posts\/496\/revisions\/899"}],"wp:attachment":[{"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=496"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}