{"id":211,"date":"2011-05-31T18:01:56","date_gmt":"2011-05-31T09:01:56","guid":{"rendered":"http:\/\/www.mogumagu.com\/wp\/wordpress\/?p=211"},"modified":"2011-05-31T18:08:37","modified_gmt":"2011-05-31T09:08:37","slug":"mysql-show-processlist-%e3%81%be%e3%81%a8%e3%82%81%e3%81%a6%e3%83%97%e3%83%ad%e3%82%bb%e3%82%b9%e6%b6%88%e3%81%99","status":"publish","type":"post","link":"https:\/\/www.mogumagu.com\/wp\/wordpress\/archives\/211","title":{"rendered":"MySQL: SHOW PROCESSLIST \u307e\u3068\u3081\u3066\u30d7\u30ed\u30bb\u30b9\u6d88\u3059"},"content":{"rendered":"<div class=\"65a9d09a7d046572b7ae2e4674a406ee\" data-index=\"1\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<script type=\"text\/javascript\"><!--\r\ngoogle_ad_client = \"ca-pub-0496250084394782\";\r\ngoogle_ad_slot = \"5624605187\";\r\ngoogle_ad_width = 300;\r\ngoogle_ad_height = 250;\r\n\/\/-->\r\n<\/script>\r\n<script type=\"text\/javascript\"\r\nsrc=\"https:\/\/pagead2.googlesyndication.com\/pagead\/show_ads.js\">\r\n<\/script>\n<\/div>\n<p>CI\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u304c\u3053\u3051\u3066\u30ed\u30c3\u30af\u304c\u304b\u304b\u3063\u305f\u3068\u304d\u306b<br \/>\n\u81ea\u5206\u306eMySQL\u306e\u30d7\u30ed\u30bb\u30b9\u3060\u3051\u3092\u4e00\u6c17\u306b\u6d88\u3057\u305f\u304f\u306a\u3063\u305f\u306e\u3067\u8abf\u3079\u305f\u3002<\/p>\n<p><a href=\"http:\/\/techblog.crooz.jp\/?p=3282\" target=\"_blank\">\u3061\u3087\u3063\u3074\u308a\u4e0a\u884c\u304f SHOW PROCESSLIST \u306e\u4f7f\u3044\u65b9<\/a><\/p>\n<p>\u2191\u3053\u3053\u306b\u8a73\u3057\u304f\u66f8\u304b\u308c\u3066\u3044\u308b\u3002<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nSHOW PROCESSLIST;\r\n<\/pre>\n<p>\u2191\u304c\u2193\u3068\u540c\u3058\u610f\u5473\u3068\u3044\u3046\u3053\u3068\u306a\u306e\u3067<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nSELECT * FROM information_schema.PROCESSLIST;\r\n<\/pre>\n<p>\u81ea\u5206\u306e\u5834\u5408\u306f\u3053\u3093\u306a\u611f\u3058\u3067\u3002<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\n&gt; SELECT group_concat(id) FROM information_schema.PROCESSLIST WHERE User='name';\r\n+--------------------------------------------------------------+\r\n| group_concat(id)                                             |\r\n+--------------------------------------------------------------+\r\n| 508,506,503,502,500,400,399,398,397,372,299,297,279,261,66,2 |\r\n+--------------------------------------------------------------+\r\n1 row in set (0.00 sec)\r\n<\/pre>\n<p>\u30ef\u30f3\u30e9\u30a4\u30ca\u30fc\u3067\u6d88\u3059\u306e\u306b\u30d3\u30d3\u3063\u305f\u306e\u3067\u4ee5\u4e0b\u306e\u65b9\u6cd5\u3067\u3002<br \/>\n\u203b\u3053\u306e\u65b9\u6cd5\u306b\u3059\u308b\u70ba\u306bgroup_concat()\u4f7f\u3063\u305f\u3068\u3044\u3046\u30fb\u30fb\u30fb\u3002<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ mysqladmin kill 508,506,503,502,500,400,399,398,397,372,299,297,279,261,2 -u name -p\r\n<\/pre>\n<p>\u53c2\u8003<br \/>\n<a href=\"http:\/\/mysql.javarou.com\/dat\/000411.html\" target=\"_blank\"> \u30d7\u30ed\u30bb\u30b9\u3092\u5f37\u5236\u7684\u306b\u505c\u6b62\u3059\u308b(mysqladmin)<\/a><\/p>\n<div class=\"65a9d09a7d046572b7ae2e4674a406ee\" data-index=\"3\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<script type=\"text\/javascript\"><!--\r\namazon_ad_tag = \"lax34weddojp-22\"; amazon_ad_width = \"468\"; amazon_ad_height = \"60\"; amazon_ad_link_target = \"new\"; amazon_ad_border = \"hide\";\/\/--><\/script>\r\n<script type=\"text\/javascript\" src=\"https:\/\/www.assoc-amazon.jp\/s\/ads.js\"><\/script>\n<\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>CI\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u304c\u3053\u3051\u3066\u30ed\u30c3\u30af\u304c\u304b\u304b\u3063\u305f\u3068\u304d\u306b \u81ea\u5206\u306eMySQL\u306e\u30d7\u30ed\u30bb\u30b9\u3060\u3051\u3092\u4e00\u6c17\u306b\u6d88\u3057\u305f\u304f\u306a\u3063\u305f\u306e\u3067\u8abf\u3079\u305f\u3002 \u3061\u3087\u3063\u3074\u308a\u4e0a\u884c\u304f SHOW PROCESSLIST \u306e\u4f7f\u3044\u65b9 \u2191\u3053\u3053\u306b\u8a73\u3057\u304f\u66f8\u304b\u308c\u3066\u3044\u308b\u3002 \u2191\u304c\u2193\u3068 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[9,25],"tags":[30,6],"_links":{"self":[{"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/posts\/211"}],"collection":[{"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/comments?post=211"}],"version-history":[{"count":5,"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/posts\/211\/revisions"}],"predecessor-version":[{"id":215,"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/posts\/211\/revisions\/215"}],"wp:attachment":[{"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/media?parent=211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/categories?post=211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/tags?post=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}