{"id":1532,"date":"2013-01-25T11:50:46","date_gmt":"2013-01-25T03:50:46","guid":{"rendered":"http:\/\/www.huzs.top\/?p=1532"},"modified":"2013-01-26T09:57:48","modified_gmt":"2013-01-26T01:57:48","slug":"mysql-%e6%9f%a5%e7%9c%8b%e8%bf%9e%e6%8e%a5%e6%95%b0%e7%8a%b6%e6%80%81","status":"publish","type":"post","link":"https:\/\/www.huzs.top\/?p=1532","title":{"rendered":"Mysql \u67e5\u770b\u8fde\u63a5\u6570,\u72b6\u6001"},"content":{"rendered":"<p>\u6709\u4e9b\u65f6\u5019\uff0c\u6211\u4eec\u9700\u8981\u67e5\u770bMYSQL\u5f53\u524d\u6709\u54ea\u4e9b\u8fde\u63a5\uff0c\u6bd4\u5982IP\uff0c\u7528\u6237\u7b49\u4fe1\u606f\u3002\u5728\u547d\u4ee4\u884c\u548cphpmyadmin\u4e0a\u6267\u884c\u5982\u4e0bSQL\u547d\u4ee4\u5373\u53ef\u3002<\/p>\n<p>\u547d\u4ee4\uff1a show processlist;<br \/>\u5982\u679c\u662froot\u5e10\u53f7\uff0c\u4f60\u80fd\u770b\u5230\u6240\u6709\u7528\u6237\u7684\u5f53\u524d\u8fde\u63a5\u3002\u5982\u679c\u662f\u5176\u5b83\u666e\u901a\u5e10\u53f7\uff0c\u53ea\u80fd\u770b\u5230\u81ea\u5df1\u5360\u7528\u7684\u8fde\u63a5\u3002<\/p>\n<p>\u5217\u51fa\u5f53\u524d\u8fde\u63a5\u548c\u72b6\u6001\uff08\u9ed8\u8ba4\u53ea\u5217\u51fa\u524d100\u6761\uff09<\/p>\n<pre>mysql&gt; show processlist;<\/pre>\n<p>\u5217\u51fa\u6240\u6709\u8fde\u63a5<\/p>\n<pre>mysql&gt; show full processlist;<!--more--><\/pre>\n<p>\u547d\u4ee4\uff1a show status;<\/p>\n<p>\u547d\u4ee4\uff1ashow status like &#8216;%\u4e0b\u9762\u53d8\u91cf%&#8217;;<\/p>\n<p>Aborted_clients \u7531\u4e8e\u5ba2\u6237\u6ca1\u6709\u6b63\u786e\u5173\u95ed\u8fde\u63a5\u5df2\u7ecf\u6b7b\u6389\uff0c\u5df2\u7ecf\u653e\u5f03\u7684\u8fde\u63a5\u6570\u91cf\u3002<br \/>Aborted_connects \u5c1d\u8bd5\u5df2\u7ecf\u5931\u8d25\u7684MySQL\u670d\u52a1\u5668\u7684\u8fde\u63a5\u7684\u6b21\u6570\u3002<br \/>Connections \u8bd5\u56fe\u8fde\u63a5MySQL\u670d\u52a1\u5668\u7684\u6b21\u6570\u3002<br \/>Created_tmp_tables \u5f53\u6267\u884c\u8bed\u53e5\u65f6\uff0c\u5df2\u7ecf\u88ab\u521b\u9020\u4e86\u7684\u9690\u542b\u4e34\u65f6\u8868\u7684\u6570\u91cf\u3002<br \/>Delayed_insert_threads \u6b63\u5728\u4f7f\u7528\u7684\u5ef6\u8fdf\u63d2\u5165\u5904\u7406\u5668\u7ebf\u7a0b\u7684\u6570\u91cf\u3002<br \/>Delayed_writes \u7528INSERT DELAYED\u5199\u5165\u7684\u884c\u6570\u3002<br \/>Delayed_errors \u7528INSERT DELAYED\u5199\u5165\u7684\u53d1\u751f\u67d0\u4e9b\u9519\u8bef(\u53ef\u80fd\u91cd\u590d\u952e\u503c)\u7684\u884c\u6570\u3002<br \/>Flush_commands \u6267\u884cFLUSH\u547d\u4ee4\u7684\u6b21\u6570\u3002<br \/>Handler_delete \u8bf7\u6c42\u4ece\u4e00\u5f20\u8868\u4e2d\u5220\u9664\u884c\u7684\u6b21\u6570\u3002<br \/>Handler_read_first \u8bf7\u6c42\u8bfb\u5165\u8868\u4e2d\u7b2c\u4e00\u884c\u7684\u6b21\u6570\u3002<br \/>Handler_read_key \u8bf7\u6c42\u6570\u5b57\u57fa\u4e8e\u952e\u8bfb\u884c\u3002<br \/>Handler_read_next \u8bf7\u6c42\u8bfb\u5165\u57fa\u4e8e\u4e00\u4e2a\u952e\u7684\u4e00\u884c\u7684\u6b21\u6570\u3002<br \/>Handler_read_rnd \u8bf7\u6c42\u8bfb\u5165\u57fa\u4e8e\u4e00\u4e2a\u56fa\u5b9a\u4f4d\u7f6e\u7684\u4e00\u884c\u7684\u6b21\u6570\u3002<br \/>Handler_update \u8bf7\u6c42\u66f4\u65b0\u8868\u4e2d\u4e00\u884c\u7684\u6b21\u6570\u3002<br \/>Handler_write \u8bf7\u6c42\u5411\u8868\u4e2d\u63d2\u5165\u4e00\u884c\u7684\u6b21\u6570\u3002<br \/>Key_blocks_used \u7528\u4e8e\u5173\u952e\u5b57\u7f13\u5b58\u7684\u5757\u7684\u6570\u91cf\u3002<br \/>Key_read_requests \u8bf7\u6c42\u4ece\u7f13\u5b58\u8bfb\u5165\u4e00\u4e2a\u952e\u503c\u7684\u6b21\u6570\u3002<br \/>Key_reads \u4ece\u78c1\u76d8\u7269\u7406\u8bfb\u5165\u4e00\u4e2a\u952e\u503c\u7684\u6b21\u6570\u3002<br \/>Key_write_requests \u8bf7\u6c42\u5c06\u4e00\u4e2a\u5173\u952e\u5b57\u5757\u5199\u5165\u7f13\u5b58\u6b21\u6570\u3002<br \/>Key_writes \u5c06\u4e00\u4e2a\u952e\u503c\u5757\u7269\u7406\u5199\u5165\u78c1\u76d8\u7684\u6b21\u6570\u3002<br \/>Max_used_connections \u540c\u65f6\u4f7f\u7528\u7684\u8fde\u63a5\u7684\u6700\u5927\u6570\u76ee\u3002<br \/>Not_flushed_key_blocks \u5728\u952e\u7f13\u5b58\u4e2d\u5df2\u7ecf\u6539\u53d8\u4f46\u662f\u8fd8\u6ca1\u88ab\u6e05\u7a7a\u5230\u78c1\u76d8\u4e0a\u7684\u952e\u5757\u3002<br \/>Not_flushed_delayed_rows \u5728INSERT DELAY\u961f\u5217\u4e2d\u7b49\u5f85\u5199\u5165\u7684\u884c\u7684\u6570\u91cf\u3002<br \/>Open_tables \u6253\u5f00\u8868\u7684\u6570\u91cf\u3002<br \/>Open_files \u6253\u5f00\u6587\u4ef6\u7684\u6570\u91cf\u3002<br \/>Open_streams \u6253\u5f00\u6d41\u7684\u6570\u91cf(\u4e3b\u8981\u7528\u4e8e\u65e5\u5fd7\u8bb0\u8f7d\uff09<br \/>Opened_tables \u5df2\u7ecf\u6253\u5f00\u7684\u8868\u7684\u6570\u91cf\u3002<br \/>Questions \u53d1\u5f80\u670d\u52a1\u5668\u7684\u67e5\u8be2\u7684\u6570\u91cf\u3002<br \/>Slow_queries \u8981\u82b1\u8d85\u8fc7long_query_time\u65f6\u95f4\u7684\u67e5\u8be2\u6570\u91cf\u3002<br \/>Threads_connected \u5f53\u524d\u6253\u5f00\u7684\u8fde\u63a5\u7684\u6570\u91cf\u3002<br \/>Threads_running \u4e0d\u5728\u7761\u7720\u7684\u7ebf\u7a0b\u6570\u91cf\u3002<br \/>Uptime \u670d\u52a1\u5668\u5de5\u4f5c\u4e86\u591a\u5c11\u79d2\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6709\u4e9b\u65f6\u5019\uff0c\u6211\u4eec\u9700\u8981\u67e5\u770bMYSQL\u5f53\u524d\u6709\u54ea\u4e9b\u8fde\u63a5\uff0c\u6bd4\u5982IP\uff0c\u7528\u6237\u7b49\u4fe1\u606f\u3002\u5728\u547d\u4ee4\u884c\u548cphpmyadmin\u4e0a\u6267\u884c\u5982\u4e0b [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-1532","post","type-post","status-publish","format-standard","hentry","category-8"],"_links":{"self":[{"href":"https:\/\/www.huzs.top\/index.php?rest_route=\/wp\/v2\/posts\/1532","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.huzs.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.huzs.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.huzs.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.huzs.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1532"}],"version-history":[{"count":0,"href":"https:\/\/www.huzs.top\/index.php?rest_route=\/wp\/v2\/posts\/1532\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.huzs.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.huzs.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.huzs.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}