{"id":1418,"date":"2016-03-01T10:24:32","date_gmt":"2016-03-01T02:24:32","guid":{"rendered":"http:\/\/nick.txtcc.com\/?p=1418"},"modified":"2016-03-01T10:24:32","modified_gmt":"2016-03-01T02:24:32","slug":"killing-of-mysql-processlist%e6%b8%85%e7%90%86mysql%e6%89%80%e6%9c%89%e9%98%9f%e5%88%97","status":"publish","type":"post","link":"http:\/\/nick.txtcc.com\/index.php\/db\/1418","title":{"rendered":"killing of MySQL processlist(\u6e05\u7406mysql\u6240\u6709\u961f\u5217)"},"content":{"rendered":"<div class=\"crayon-pre\">\n<div id=\"crayon-56d43b1f0b39b395562170-10\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\"><span class=\"crayon-v\">mysql<\/span>\n<span class=\"crayon-o\">><\/span> select <\/span>\n<span class=\"crayon-e\">concat<\/span>\n<span class=\"crayon-sy\">(<\/span>\n<span class=\"crayon-s\">&#8216;KILL &#8216;<\/span>\n<span class=\"crayon-sy\">,<\/span>\n<span class=\"crayon-r\">id<\/span>\n<span class=\"crayon-sy\">,<\/span>\n<span class=\"crayon-s\">&#8216;;&#8217;<\/span>\n<span class=\"crayon-sy\">)<\/span> <span class=\"crayon-e\">from <\/span>\n<span class=\"crayon-v\">information_schema<\/span>\n<span class=\"crayon-e\">.processlist<\/span> <span class=\"crayon-e\">where <\/span>\n<span class=\"crayon-v\">user<\/span>\n<span class=\"crayon-o\">=<\/span>\n<span class=\"crayon-s\">&#8216;root&#8217;\u00a0and time > 3<\/span>\u00a0<span class=\"crayon-e\">into <\/span>\n<span class=\"crayon-i\">outfile<\/span> <span class=\"crayon-s\">&#8216;\/tmp\/a.txt&#8217;<\/span>\n<span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-56d43b1f0b39b395562170-13\" class=\"crayon-line\"><span class=\"crayon-v\">mysql<\/span>\n<span class=\"crayon-o\">><\/span> <span class=\"crayon-v\">source<\/span> <span class=\"crayon-o\">\/<\/span>\n<span class=\"crayon-v\">tmp<\/span>\n<span class=\"crayon-o\">\/<\/span>\n<span class=\"crayon-v\">a<\/span>\n<span class=\"crayon-e\">.txt<\/span>\n<span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\"><\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>mysql > select concat ( &#8216;KILL &#8216; , id , &#8216;;&#8217; ) from information_schema .proces&#46;&#46;&#46;<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[101],"tags":[450,100,451],"class_list":["post-1418","post","type-post","status-publish","format-standard","hentry","category-db","tag-kill","tag-mysql","tag-processlist"],"_links":{"self":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/1418","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/comments?post=1418"}],"version-history":[{"count":1,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/1418\/revisions"}],"predecessor-version":[{"id":1419,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/1418\/revisions\/1419"}],"wp:attachment":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/media?parent=1418"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/categories?post=1418"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/tags?post=1418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}