processlist\u547d\u4ee4\u7684\u8f93\u51fa\u7ed3\u679c\u663e\u793a\u4e86\u6709\u54ea\u4e9b\u7ebf\u7a0b\u5728\u8fd0\u884c\uff0c\u53ef\u4ee5\u5e2e\u52a9\u8bc6\u522b\u51fa\u6709\u95ee\u9898\u7684\u67e5\u8be2\u8bed\u53e5\uff0c\u4e24\u79cd\u65b9\u5f0f\u4f7f\u7528\u8fd9\u4e2a\u547d\u4ee4\u3002
\n1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u8fdb\u5165mysql\/bin\u76ee\u5f55\u4e0b\u8f93\u5165mysqladmin processlist;
\n2.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u542f\u52a8mysql\uff0c\u8f93\u5165show processlist;
\n\u5982\u679c\u6709SUPER\u6743\u9650\uff0c\u5219\u53ef\u4ee5\u770b\u5230\u5168\u90e8\u7684\u7ebf\u7a0b\uff0c\u5426\u5219\uff0c\u53ea\u80fd\u770b\u5230\u81ea\u5df1\u53d1\u8d77\u7684\u7ebf\u7a0b\uff08\u8fd9\u662f\u6307\uff0c\u5f53\u524d\u5bf9\u5e94\u7684MySQL\u5e10\u6237\u8fd0\u884c\u7684\u7ebf\u7a0b\uff09\u3002<\/p>\n
mysql> show processlist<\/p>\n
-> ;<\/p>\n
+—-+——-+———————-+——+———+——+——-+——————+<\/p>\n
| Id | User\u00a0 | Host \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | db \u00a0 | Command | Time | State | Info \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |<\/p>\n
+—-+——-+———————-+——+———+——+——-+——————+<\/p>\n
| 34 | ucjmh | 192.168.56.101:54031 | NULL | Query \u00a0 |\u00a0 \u00a0 0 | NULL\u00a0 | show processlist |<\/p>\n
+—-+——-+———————-+——+———+——+——-+——————+<\/p>\n
1 row in set (0.00 sec)<\/p>\n
mysql> exit<\/p>\n
Bye<\/p>\n
[root@ucjmh ~]# mysql -uroot -poracle<\/p>\n
Welcome to the MySQL monitor.\u00a0 Commands end with ; or \\g.<\/p>\n
Your MySQL connection id is 35<\/p>\n
Server version: 5.5.41-log Source distribution<\/p>\n
Copyright (c) 2000, 2014, Oracle and\/or its affiliates. All rights reserved.<\/p>\n
Oracle is a registered trademark of Oracle Corporation and\/or its<\/p>\n
affiliates. Other names may be trademarks of their respective<\/p>\n
owners.<\/p>\n
Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/p>\n
mysql> show processlist;<\/p>\n
+—-+——+———–+——+———+——+——-+——————+<\/p>\n
| Id | User | Host\u00a0 \u00a0 \u00a0 | db \u00a0 | Command | Time | State | Info \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |<\/p>\n
+—-+——+———–+——+———+——+——-+——————+<\/p>\n
| 35 | root | localhost | NULL | Query \u00a0 |\u00a0 \u00a0 0 | NULL\u00a0 | show processlist |<\/p>\n
+—-+——+———–+——+———+——+——-+——————+<\/p>\n
1 row in set (0.00 sec)<\/p>\n
\u5404\u5217\u7684\u542b\u4e49\u548c\u7528\u9014:<\/p>\n
id\uff0c\u6807\u8bc6\u4f1a\u8bddid \u7c7b\u4f3c\u4e8eoracle\u4e2d\u7684sid\uff0c\u4f60\u8981kill\u4e00\u4e2a\u8bed\u53e5\u7684\u65f6\u5019\u5f88\u6709\u7528\u3002<\/p>\n
user\u5217\uff0c\u663e\u793a\u5355\u524d\u7528\u6237\uff0c\u5982\u679c\u4e0d\u662froot\uff0c\u8fd9\u4e2a\u547d\u4ee4\u5c31\u53ea\u663e\u793a\u4f60\u6743\u9650\u8303\u56f4\u5185\u7684sql\u8bed\u53e5\u3002<\/p>\n
host\u5217\uff0c\u663e\u793a\u8fd9\u4e2a\u8bed\u53e5\u662f\u4ece\u54ea\u4e2aip\u7684\u54ea\u4e2a\u7aef\u53e3\u4e0a\u53d1\u51fa\u7684\u3002\u7528\u6765\u8ffd\u8e2a\u51fa\u95ee\u9898\u8bed\u53e5\u7684\u7528\u6237\u3002<\/p>\n
db\u5217\uff0c\u663e\u793a\u8fd9\u4e2a\u8fdb\u7a0b\u76ee\u524d\u8fde\u63a5\u7684\u662f\u54ea\u4e2a\u6570\u636e\u5e93\u3002<\/p>\n
command\u5217\uff0c\u663e\u793a\u5f53\u524d\u8fde\u63a5\u7684\u6267\u884c\u7684\u547d\u4ee4\uff0c\u4e00\u822c\u5c31\u662f\u4f11\u7720\uff08sleep\uff09\uff0c\u67e5\u8be2\uff08query\uff09\uff0c\u8fde\u63a5\uff08connect\uff09\u3002<\/p>\n
time\u5217\uff0c\u6b64\u8fd9\u4e2a\u72b6\u6001\u6301\u7eed\u7684\u65f6\u95f4\uff0c\u5355\u4f4d\u662f\u79d2\u3002<\/p>\n
state\u5217\uff0c\u663e\u793a\u4f7f\u7528\u5f53\u524d\u8fde\u63a5\u7684sql\u8bed\u53e5\u7684\u72b6\u6001\uff0c\u5f88\u91cd\u8981\u7684\u5217\uff0c\u540e\u7eed\u4f1a\u6709\u6240\u6709\u7684\u72b6\u6001\u7684\u63cf\u8ff0\uff0c\u8bf7\u6ce8\u610f\uff0cstate\u53ea\u662f\u8bed\u53e5\u6267\u884c\u4e2d\u7684\u67d0\u4e00\u4e2a\u72b6\u6001\uff0c\u4e00\u4e2asql\u8bed\u53e5\uff0c\u5df2\u67e5\u8be2\u4e3a\u4f8b\uff0c\u53ef\u80fd\u9700\u8981\u7ecf\u8fc7copying to tmp table\uff0cSorting result\uff0cSending data\u7b49\u72b6\u6001\u624d\u53ef\u4ee5\u5b8c\u6210\uff0c<\/p>\n
info\u5217\uff0c\u663e\u793a\u8fd9\u4e2asql\u8bed\u53e5\uff0c\u56e0\u4e3a\u957f\u5ea6\u6709\u9650\uff0c\u6240\u4ee5\u957f\u7684sql\u8bed\u53e5\u5c31\u663e\u793a\u4e0d\u5168\uff0c\u4f46\u662f\u4e00\u4e2a\u5224\u65ad\u95ee\u9898\u8bed\u53e5\u7684\u91cd\u8981\u4f9d\u636e\u3002Checking table
\n\u6b63\u5728\u68c0\u67e5\u6570\u636e\u8868\uff08\u8fd9\u662f\u81ea\u52a8\u7684\uff09\u3002
\nClosing tables
\n\u6b63\u5728\u5c06\u8868\u4e2d\u4fee\u6539\u7684\u6570\u636e\u5237\u65b0\u5230\u78c1\u76d8\u4e2d\uff0c\u540c\u65f6\u6b63\u5728\u5173\u95ed\u5df2\u7ecf\u7528\u5b8c\u7684\u8868\u3002\u8fd9\u662f\u4e00\u4e2a\u5f88\u5feb\u7684\u64cd\u4f5c\uff0c\u5982\u679c\u4e0d\u662f\u8fd9\u6837\u7684\u8bdd\uff0c\u5c31\u5e94\u8be5\u786e\u8ba4\u78c1\u76d8\u7a7a\u95f4\u662f\u5426\u5df2\u7ecf\u6ee1\u4e86\u6216\u8005\u78c1\u76d8\u662f\u5426\u6b63\u5904\u4e8e\u91cd\u8d1f\u4e2d\u3002
\nConnect Out
\n\u590d\u5236\u4ece\u670d\u52a1\u5668\u6b63\u5728\u8fde\u63a5\u4e3b\u670d\u52a1\u5668\u3002
\nCopying to tmp table on disk
\n\u7531\u4e8e\u4e34\u65f6\u7ed3\u679c\u96c6\u5927\u4e8etmp_table_size\uff0c\u6b63\u5728\u5c06\u4e34\u65f6\u8868\u4ece\u5185\u5b58\u5b58\u50a8\u8f6c\u4e3a\u78c1\u76d8\u5b58\u50a8\u4ee5\u6b64\u8282\u7701\u5185\u5b58\u3002
\nCreating tmp table
\n\u6b63\u5728\u521b\u5efa\u4e34\u65f6\u8868\u4ee5\u5b58\u653e\u90e8\u5206\u67e5\u8be2\u7ed3\u679c\u3002
\ndeleting from main table
\n\u670d\u52a1\u5668\u6b63\u5728\u6267\u884c\u591a\u8868\u5220\u9664\u4e2d\u7684\u7b2c\u4e00\u90e8\u5206\uff0c\u521a\u5220\u9664\u7b2c\u4e00\u4e2a\u8868\u3002
\ndeleting from reference tables
\n\u670d\u52a1\u5668\u6b63\u5728\u6267\u884c\u591a\u8868\u5220\u9664\u4e2d\u7684\u7b2c\u4e8c\u90e8\u5206\uff0c\u6b63\u5728\u5220\u9664\u5176\u4ed6\u8868\u7684\u8bb0\u5f55\u3002
\nFlushing tables
\n\u6b63\u5728\u6267\u884cFLUSH TABLES\uff0c\u7b49\u5f85\u5176\u4ed6\u7ebf\u7a0b\u5173\u95ed\u6570\u636e\u8868\u3002
\nKilled
\n\u53d1\u9001\u4e86\u4e00\u4e2akill\u8bf7\u6c42\u7ed9\u67d0\u7ebf\u7a0b\uff0c\u90a3\u4e48\u8fd9\u4e2a\u7ebf\u7a0b\u5c06\u4f1a\u68c0\u67e5kill\u6807\u5fd7\u4f4d\uff0c\u540c\u65f6\u4f1a\u653e\u5f03\u4e0b\u4e00\u4e2akill\u8bf7\u6c42\u3002MySQL\u4f1a\u5728\u6bcf\u6b21\u7684\u4e3b\u5faa\u73af\u4e2d\u68c0\u67e5kill\u6807\u5fd7\u4f4d\uff0c\u4e0d\u8fc7\u6709\u4e9b\u60c5\u51b5\u4e0b\u8be5\u7ebf\u7a0b\u53ef\u80fd\u4f1a\u8fc7\u4e00\u5c0f\u6bb5\u624d\u80fd\u6b7b\u6389\u3002\u5982\u679c\u8be5\u7ebf\u7a0b\u7a0b\u88ab\u5176\u4ed6\u7ebf\u7a0b\u9501\u4f4f\u4e86\uff0c\u90a3\u4e48kill\u8bf7\u6c42\u4f1a\u5728\u9501\u91ca\u653e\u65f6\u9a6c\u4e0a\u751f\u6548\u3002
\nLocked
\n\u88ab\u5176\u4ed6\u67e5\u8be2\u9501\u4f4f\u4e86\u3002
\nSending data
\n\u6b63\u5728\u5904\u7406Select\u67e5\u8be2\u7684\u8bb0\u5f55\uff0c\u540c\u65f6\u6b63\u5728\u628a\u7ed3\u679c\u53d1\u9001\u7ed9\u5ba2\u6237\u7aef\u3002
\nSorting for group
\n\u6b63\u5728\u4e3aGROUP BY\u505a\u6392\u5e8f\u3002
\nSorting for order
\n\u6b63\u5728\u4e3aORDER BY\u505a\u6392\u5e8f\u3002
\nOpening tables
\n\u8fd9\u4e2a\u8fc7\u7a0b\u5e94\u8be5\u4f1a\u5f88\u5feb\uff0c\u9664\u975e\u53d7\u5230\u5176\u4ed6\u56e0\u7d20\u7684\u5e72\u6270\u3002\u4f8b\u5982\uff0c\u5728\u6267Alter TABLE\u6216LOCK TABLE\u8bed\u53e5\u884c\u5b8c\u4ee5\u524d\uff0c\u6570\u636e\u8868\u65e0\u6cd5\u88ab\u5176\u4ed6\u7ebf\u7a0b\u6253\u5f00\u3002\u6b63\u5c1d\u8bd5\u6253\u5f00\u4e00\u4e2a\u8868\u3002
\nRemoving duplicates
\n\u6b63\u5728\u6267\u884c\u4e00\u4e2aSelect DISTINCT\u65b9\u5f0f\u7684\u67e5\u8be2\uff0c\u4f46\u662fMySQL\u65e0\u6cd5\u5728\u524d\u4e00\u4e2a\u9636\u6bb5\u4f18\u5316\u6389\u90a3\u4e9b\u91cd\u590d\u7684\u8bb0\u5f55\u3002\u56e0\u6b64\uff0cMySQL\u9700\u8981\u518d\u6b21\u53bb\u6389\u91cd\u590d\u7684\u8bb0\u5f55\uff0c\u7136\u540e\u518d\u628a\u7ed3\u679c\u53d1\u9001\u7ed9\u5ba2\u6237\u7aef\u3002
\nReopen table
\n\u83b7\u5f97\u4e86\u5bf9\u4e00\u4e2a\u8868\u7684\u9501\uff0c\u4f46\u662f\u5fc5\u987b\u5728\u8868\u7ed3\u6784\u4fee\u6539\u4e4b\u540e\u624d\u80fd\u83b7\u5f97\u8fd9\u4e2a\u9501\u3002\u5df2\u7ecf\u91ca\u653e\u9501\uff0c\u5173\u95ed\u6570\u636e\u8868\uff0c\u6b63\u5c1d\u8bd5\u91cd\u65b0\u6253\u5f00\u6570\u636e\u8868\u3002
\nRepair by sorting
\n\u4fee\u590d\u6307\u4ee4\u6b63\u5728\u6392\u5e8f\u4ee5\u521b\u5efa\u7d22\u5f15\u3002
\nRepair with keycache
\n\u4fee\u590d\u6307\u4ee4\u6b63\u5728\u5229\u7528\u7d22\u5f15\u7f13\u5b58\u4e00\u4e2a\u4e00\u4e2a\u5730\u521b\u5efa\u65b0\u7d22\u5f15\u3002\u5b83\u4f1a\u6bd4Repair by sorting\u6162\u4e9b\u3002
\nSearching rows for update
\n\u6b63\u5728\u8bb2\u7b26\u5408\u6761\u4ef6\u7684\u8bb0\u5f55\u627e\u51fa\u6765\u4ee5\u5907\u66f4\u65b0\u3002\u5b83\u5fc5\u987b\u5728Update\u8981\u4fee\u6539\u76f8\u5173\u7684\u8bb0\u5f55\u4e4b\u524d\u5c31\u5b8c\u6210\u4e86\u3002
\nSleeping
\n\u6b63\u5728\u7b49\u5f85\u5ba2\u6237\u7aef\u53d1\u9001\u65b0\u8bf7\u6c42.
\nSystem lock
\n\u6b63\u5728\u7b49\u5f85\u53d6\u5f97\u4e00\u4e2a\u5916\u90e8\u7684\u7cfb\u7edf\u9501\u3002\u5982\u679c\u5f53\u524d\u6ca1\u6709\u8fd0\u884c\u591a\u4e2amysqld\u670d\u52a1\u5668\u540c\u65f6\u8bf7\u6c42\u540c\u4e00\u4e2a\u8868\uff0c\u90a3\u4e48\u53ef\u4ee5\u901a\u8fc7\u589e\u52a0–skip-external-locking\u53c2\u6570\u6765\u7981\u6b62\u5916\u90e8\u7cfb\u7edf\u9501\u3002
\nUpgrading lock
\nInsert DELAYED\u6b63\u5728\u5c1d\u8bd5\u53d6\u5f97\u4e00\u4e2a\u9501\u8868\u4ee5\u63d2\u5165\u65b0\u8bb0\u5f55\u3002
\nUpdating
\n\u6b63\u5728\u641c\u7d22\u5339\u914d\u7684\u8bb0\u5f55\uff0c\u5e76\u4e14\u4fee\u6539\u5b83\u4eec\u3002
\nUser Lock
\n\u6b63\u5728\u7b49\u5f85GET_LOCK()\u3002
\nWaiting for tables
\n\u8be5\u7ebf\u7a0b\u5f97\u5230\u901a\u77e5\uff0c\u6570\u636e\u8868\u7ed3\u6784\u5df2\u7ecf\u88ab\u4fee\u6539\u4e86\uff0c\u9700\u8981\u91cd\u65b0\u6253\u5f00\u6570\u636e\u8868\u4ee5\u53d6\u5f97\u65b0\u7684\u7ed3\u6784\u3002\u7136\u540e\uff0c\u4e3a\u4e86\u80fd\u7684\u91cd\u65b0\u6253\u5f00\u6570\u636e\u8868\uff0c\u5fc5\u987b\u7b49\u5230\u6240\u6709\u5176\u4ed6\u7ebf\u7a0b\u5173\u95ed\u8fd9\u4e2a\u8868\u3002\u4ee5\u4e0b\u51e0\u79cd\u60c5\u51b5\u4e0b\u4f1a\u4ea7\u751f\u8fd9\u4e2a\u901a\u77e5\uff1aFLUSH TABLES tbl_name, Alter TABLE, RENAME TABLE, REPAIR TABLE, ANALYZE TABLE,\u6216OPTIMIZE TABLE\u3002
\nwaiting for handler insert
\nInsert DELAYED\u5df2\u7ecf\u5904\u7406\u5b8c\u4e86\u6240\u6709\u5f85\u5904\u7406\u7684\u63d2\u5165\u64cd\u4f5c\uff0c\u6b63\u5728\u7b49\u5f85\u65b0\u7684\u8bf7\u6c42\u3002
\n\u5927\u90e8\u5206\u72b6\u6001\u5bf9\u5e94\u5f88\u5feb\u7684\u64cd\u4f5c\uff0c\u53ea\u8981\u6709\u4e00\u4e2a\u7ebf\u7a0b\u4fdd\u6301\u540c\u4e00\u4e2a\u72b6\u6001\u597d\u51e0\u79d2\u949f\uff0c\u90a3\u4e48\u53ef\u80fd\u662f\u6709\u95ee\u9898\u53d1\u751f\u4e86\uff0c\u9700\u8981\u68c0\u67e5\u4e00\u4e0b\u3002
\n\u8fd9\u4e2a\u547d\u4ee4\u4e2d\u6700\u5173\u952e\u7684\u5c31\u662fstate\u5217\uff0cmysql\u5217\u51fa\u7684\u72b6\u6001\u4e3b\u8981\u6709\u4ee5\u4e0b\u51e0\u79cd\uff1a<\/p>\n
Checking table
\n\u6b63\u5728\u68c0\u67e5\u6570\u636e\u8868\uff08\u8fd9\u662f\u81ea\u52a8\u7684\uff09\u3002
\nClosing tables
\n\u6b63\u5728\u5c06\u8868\u4e2d\u4fee\u6539\u7684\u6570\u636e\u5237\u65b0\u5230\u78c1\u76d8\u4e2d\uff0c\u540c\u65f6\u6b63\u5728\u5173\u95ed\u5df2\u7ecf\u7528\u5b8c\u7684\u8868\u3002\u8fd9\u662f\u4e00\u4e2a\u5f88\u5feb\u7684\u64cd\u4f5c\uff0c\u5982\u679c\u4e0d\u662f\u8fd9\u6837\u7684\u8bdd\uff0c\u5c31\u5e94\u8be5\u786e\u8ba4\u78c1\u76d8\u7a7a\u95f4\u662f\u5426\u5df2\u7ecf\u6ee1\u4e86\u6216\u8005\u78c1\u76d8\u662f\u5426\u6b63\u5904\u4e8e\u91cd\u8d1f\u4e2d\u3002
\nConnect Out
\n\u590d\u5236\u4ece\u670d\u52a1\u5668\u6b63\u5728\u8fde\u63a5\u4e3b\u670d\u52a1\u5668\u3002
\nCopying to tmp table on disk
\n\u7531\u4e8e\u4e34\u65f6\u7ed3\u679c\u96c6\u5927\u4e8etmp_table_size\uff0c\u6b63\u5728\u5c06\u4e34\u65f6\u8868\u4ece\u5185\u5b58\u5b58\u50a8\u8f6c\u4e3a\u78c1\u76d8\u5b58\u50a8\u4ee5\u6b64\u8282\u7701\u5185\u5b58\u3002
\nCreating tmp table
\n\u6b63\u5728\u521b\u5efa\u4e34\u65f6\u8868\u4ee5\u5b58\u653e\u90e8\u5206\u67e5\u8be2\u7ed3\u679c\u3002
\ndeleting from main table
\n\u670d\u52a1\u5668\u6b63\u5728\u6267\u884c\u591a\u8868\u5220\u9664\u4e2d\u7684\u7b2c\u4e00\u90e8\u5206\uff0c\u521a\u5220\u9664\u7b2c\u4e00\u4e2a\u8868\u3002
\ndeleting from reference tables
\n\u670d\u52a1\u5668\u6b63\u5728\u6267\u884c\u591a\u8868\u5220\u9664\u4e2d\u7684\u7b2c\u4e8c\u90e8\u5206\uff0c\u6b63\u5728\u5220\u9664\u5176\u4ed6\u8868\u7684\u8bb0\u5f55\u3002
\nFlushing tables
\n\u6b63\u5728\u6267\u884cFLUSH TABLES\uff0c\u7b49\u5f85\u5176\u4ed6\u7ebf\u7a0b\u5173\u95ed\u6570\u636e\u8868\u3002
\nKilled
\n\u53d1\u9001\u4e86\u4e00\u4e2akill\u8bf7\u6c42\u7ed9\u67d0\u7ebf\u7a0b\uff0c\u90a3\u4e48\u8fd9\u4e2a\u7ebf\u7a0b\u5c06\u4f1a\u68c0\u67e5kill\u6807\u5fd7\u4f4d\uff0c\u540c\u65f6\u4f1a\u653e\u5f03\u4e0b\u4e00\u4e2akill\u8bf7\u6c42\u3002MySQL\u4f1a\u5728\u6bcf\u6b21\u7684\u4e3b\u5faa\u73af\u4e2d\u68c0\u67e5kill\u6807\u5fd7\u4f4d\uff0c\u4e0d\u8fc7\u6709\u4e9b\u60c5\u51b5\u4e0b\u8be5\u7ebf\u7a0b\u53ef\u80fd\u4f1a\u8fc7\u4e00\u5c0f\u6bb5\u624d\u80fd\u6b7b\u6389\u3002\u5982\u679c\u8be5\u7ebf\u7a0b\u7a0b\u88ab\u5176\u4ed6\u7ebf\u7a0b\u9501\u4f4f\u4e86\uff0c\u90a3\u4e48kill\u8bf7\u6c42\u4f1a\u5728\u9501\u91ca\u653e\u65f6\u9a6c\u4e0a\u751f\u6548\u3002
\nLocked
\n\u88ab\u5176\u4ed6\u67e5\u8be2\u9501\u4f4f\u4e86\u3002
\nSending data
\n\u6b63\u5728\u5904\u7406Select\u67e5\u8be2\u7684\u8bb0\u5f55\uff0c\u540c\u65f6\u6b63\u5728\u628a\u7ed3\u679c\u53d1\u9001\u7ed9\u5ba2\u6237\u7aef\u3002
\nSorting for group
\n\u6b63\u5728\u4e3aGROUP BY\u505a\u6392\u5e8f\u3002
\nSorting for order
\n\u6b63\u5728\u4e3aORDER BY\u505a\u6392\u5e8f\u3002
\nOpening tables
\n\u8fd9\u4e2a\u8fc7\u7a0b\u5e94\u8be5\u4f1a\u5f88\u5feb\uff0c\u9664\u975e\u53d7\u5230\u5176\u4ed6\u56e0\u7d20\u7684\u5e72\u6270\u3002\u4f8b\u5982\uff0c\u5728\u6267Alter TABLE\u6216LOCK TABLE\u8bed\u53e5\u884c\u5b8c\u4ee5\u524d\uff0c\u6570\u636e\u8868\u65e0\u6cd5\u88ab\u5176\u4ed6\u7ebf\u7a0b\u6253\u5f00\u3002\u6b63\u5c1d\u8bd5\u6253\u5f00\u4e00\u4e2a\u8868\u3002
\nRemoving duplicates
\n\u6b63\u5728\u6267\u884c\u4e00\u4e2aSelect DISTINCT\u65b9\u5f0f\u7684\u67e5\u8be2\uff0c\u4f46\u662fMySQL\u65e0\u6cd5\u5728\u524d\u4e00\u4e2a\u9636\u6bb5\u4f18\u5316\u6389\u90a3\u4e9b\u91cd\u590d\u7684\u8bb0\u5f55\u3002\u56e0\u6b64\uff0cMySQL\u9700\u8981\u518d\u6b21\u53bb\u6389\u91cd\u590d\u7684\u8bb0\u5f55\uff0c\u7136\u540e\u518d\u628a\u7ed3\u679c\u53d1\u9001\u7ed9\u5ba2\u6237\u7aef\u3002
\nReopen table
\n\u83b7\u5f97\u4e86\u5bf9\u4e00\u4e2a\u8868\u7684\u9501\uff0c\u4f46\u662f\u5fc5\u987b\u5728\u8868\u7ed3\u6784\u4fee\u6539\u4e4b\u540e\u624d\u80fd\u83b7\u5f97\u8fd9\u4e2a\u9501\u3002\u5df2\u7ecf\u91ca\u653e\u9501\uff0c\u5173\u95ed\u6570\u636e\u8868\uff0c\u6b63\u5c1d\u8bd5\u91cd\u65b0\u6253\u5f00\u6570\u636e\u8868\u3002
\nRepair by sorting
\n\u4fee\u590d\u6307\u4ee4\u6b63\u5728\u6392\u5e8f\u4ee5\u521b\u5efa\u7d22\u5f15\u3002
\nRepair with keycache
\n\u4fee\u590d\u6307\u4ee4\u6b63\u5728\u5229\u7528\u7d22\u5f15\u7f13\u5b58\u4e00\u4e2a\u4e00\u4e2a\u5730\u521b\u5efa\u65b0\u7d22\u5f15\u3002\u5b83\u4f1a\u6bd4Repair by sorting\u6162\u4e9b\u3002
\nSearching rows for update
\n\u6b63\u5728\u8bb2\u7b26\u5408\u6761\u4ef6\u7684\u8bb0\u5f55\u627e\u51fa\u6765\u4ee5\u5907\u66f4\u65b0\u3002\u5b83\u5fc5\u987b\u5728Update\u8981\u4fee\u6539\u76f8\u5173\u7684\u8bb0\u5f55\u4e4b\u524d\u5c31\u5b8c\u6210\u4e86\u3002
\nSleeping
\n\u6b63\u5728\u7b49\u5f85\u5ba2\u6237\u7aef\u53d1\u9001\u65b0\u8bf7\u6c42.
\nSystem lock
\n\u6b63\u5728\u7b49\u5f85\u53d6\u5f97\u4e00\u4e2a\u5916\u90e8\u7684\u7cfb\u7edf\u9501\u3002\u5982\u679c\u5f53\u524d\u6ca1\u6709\u8fd0\u884c\u591a\u4e2amysqld\u670d\u52a1\u5668\u540c\u65f6\u8bf7\u6c42\u540c\u4e00\u4e2a\u8868\uff0c\u90a3\u4e48\u53ef\u4ee5\u901a\u8fc7\u589e\u52a0–skip-external-locking\u53c2\u6570\u6765\u7981\u6b62\u5916\u90e8\u7cfb\u7edf\u9501\u3002
\nUpgrading lock
\nInsert DELAYED\u6b63\u5728\u5c1d\u8bd5\u53d6\u5f97\u4e00\u4e2a\u9501\u8868\u4ee5\u63d2\u5165\u65b0\u8bb0\u5f55\u3002
\nUpdating
\n\u6b63\u5728\u641c\u7d22\u5339\u914d\u7684\u8bb0\u5f55\uff0c\u5e76\u4e14\u4fee\u6539\u5b83\u4eec\u3002
\nUser Lock
\n\u6b63\u5728\u7b49\u5f85GET_LOCK()\u3002
\nWaiting for tables
\n\u8be5\u7ebf\u7a0b\u5f97\u5230\u901a\u77e5\uff0c\u6570\u636e\u8868\u7ed3\u6784\u5df2\u7ecf\u88ab\u4fee\u6539\u4e86\uff0c\u9700\u8981\u91cd\u65b0\u6253\u5f00\u6570\u636e\u8868\u4ee5\u53d6\u5f97\u65b0\u7684\u7ed3\u6784\u3002\u7136\u540e\uff0c\u4e3a\u4e86\u80fd\u7684\u91cd\u65b0\u6253\u5f00\u6570\u636e\u8868\uff0c\u5fc5\u987b\u7b49\u5230\u6240\u6709\u5176\u4ed6\u7ebf\u7a0b\u5173\u95ed\u8fd9\u4e2a\u8868\u3002\u4ee5\u4e0b\u51e0\u79cd\u60c5\u51b5\u4e0b\u4f1a\u4ea7\u751f\u8fd9\u4e2a\u901a\u77e5\uff1aFLUSH TABLES tbl_name, Alter TABLE, RENAME TABLE, REPAIR TABLE, ANALYZE TABLE,\u6216OPTIMIZE TABLE\u3002
\nwaiting for handler insert
\nInsert DELAYED\u5df2\u7ecf\u5904\u7406\u5b8c\u4e86\u6240\u6709\u5f85\u5904\u7406\u7684\u63d2\u5165\u64cd\u4f5c\uff0c\u6b63\u5728\u7b49\u5f85\u65b0\u7684\u8bf7\u6c42\u3002
\n\u5927\u90e8\u5206\u72b6\u6001\u5bf9\u5e94\u5f88\u5feb\u7684\u64cd\u4f5c\uff0c\u53ea\u8981\u6709\u4e00\u4e2a\u7ebf\u7a0b\u4fdd\u6301\u540c\u4e00\u4e2a\u72b6\u6001\u597d\u51e0\u79d2\u949f\uff0c\u90a3\u4e48\u53ef\u80fd\u662f\u6709\u95ee\u9898\u53d1\u751f\u4e86\uff0c\u9700\u8981\u68c0\u67e5\u4e00\u4e0b\u3002<\/p>\n
\u5728mysql\u7684\u5b98\u65b9\u6587\u6863\u4e2d\u5217\u51fa\u4e86\u6240\u6709\u53ef\u80fd\u7684\u72b6\u6001\u3002<\/p>\n
After create<\/code>This occurs when the thread creates a table (including internal temporary tables), at the end of the function that creates the table. This state is used even if the table could not be created due to some error.<\/li>\n- <\/a>\u00a0<\/a>
Analyzing<\/code>The thread is calculating a\u00a0MyISAM<\/code>\u00a0table key distributions (for example, forANALYZE TABLE<\/code><\/a>).<\/li>\n- <\/a>\u00a0<\/a>
checking permissions<\/code>The thread is checking whether the server has the required privileges to execute the statement.<\/li>\n- <\/a>\u00a0<\/a>
Checking table<\/code>The thread is performing a table check operation.<\/li>\n- <\/a>\u00a0<\/a>
cleaning up<\/code>The thread has processed one command and is preparing to free memory and reset certain state variables.<\/li>\n- <\/a>\u00a0<\/a>
closing tables<\/code>The thread is flushing the changed table data to disk and closing the used tables. This should be a fast operation. If not, you should verify that you do not have a full disk and that the disk is not in very heavy use.<\/li>\n- <\/a>\u00a0<\/a>
converting HEAP to MyISAM<\/code>The thread is converting an internal temporary table from a\u00a0MEMORY<\/code>\u00a0table to an on-disk\u00a0MyISAM<\/code>\u00a0table.<\/li>\n- <\/a>\u00a0<\/a>
copy to tmp table<\/code>The thread is processing an\u00a0ALTER TABLE<\/code><\/a>\u00a0statement. This state occurs after the table with the new structure has been created but before rows are copied into it.<\/li>\n- <\/a>\u00a0<\/a>
Copying to group table<\/code>If a statement has different\u00a0ORDER BY<\/code>\u00a0and\u00a0GROUP BY<\/code>\u00a0criteria, the rows are sorted by group and copied to a temporary table.<\/li>\n- <\/a>\u00a0<\/a>
Copying to tmp table<\/code>The server is copying to a temporary table in memory.<\/li>\n- <\/a>\u00a0<\/a>
Copying to tmp table on disk<\/code>The server is copying to a temporary table on disk. The temporary result set has become too large (see\u00a0Section\u00a08.4.4, \u201cHow MySQL Uses Internal Temporary Tables\u201d<\/a>). Consequently, the thread is changing the temporary table from in-memory to disk-based format to save memory.<\/li>\n- <\/a>\u00a0<\/a>
Creating index<\/code>The thread is processing\u00a0ALTER TABLE ... ENABLE KEYS<\/code>\u00a0for a\u00a0MyISAM<\/code>table.<\/li>\n- <\/a><\/a>
Creating sort index<\/code>The thread is processing a\u00a0SELECT<\/code><\/a>\u00a0that is resolved using an internal temporary table.<\/li>\n- <\/a>\u00a0<\/a>
creating table<\/code>The thread is creating a table. This includes creation of temporary tables.<\/li>\n- <\/a>\u00a0<\/a>
Creating tmp table<\/code>The thread is creating a temporary table in memory or on disk. If the table is created in memory but later is converted to an on-disk table, the state during that operation will be\u00a0Copying to tmp table on disk<\/code>.<\/li>\n- <\/a>\u00a0<\/a>
deleting from main table<\/code>The server is executing the first part of a multiple-table delete. It is deleting only from the first table, and saving columns and offsets to be used for deleting from the other (reference) tables.<\/li>\n- <\/a>\u00a0<\/a>
deleting from reference tables<\/code>The server is executing the second part of a multiple-table delete and deleting the matched rows from the other tables.<\/li>\n- <\/a>\u00a0<\/a>
discard_or_import_tablespace<\/code>The thread is processing an\u00a0ALTER TABLE ... DISCARD TABLESPACE<\/code>\u00a0or\u00a0ALTER TABLE ... IMPORT TABLESPACE<\/code>\u00a0statement.<\/li>\n- <\/a>\u00a0<\/a>
end<\/code>This occurs at the end but before the cleanup of\u00a0ALTER TABLE<\/code><\/a>,\u00a0CREATE VIEW<\/code><\/a>,\u00a0DELETE<\/code><\/a>,\u00a0INSERT<\/code><\/a>,\u00a0SELECT<\/code><\/a>, or\u00a0UPDATE<\/code><\/a>\u00a0statements.<\/li>\n- <\/a>\u00a0<\/a>
executing<\/code>The thread has begun executing a statement.<\/li>\n- <\/a>\u00a0<\/a>
Execution of init_command<\/code>The thread is executing statements in the value of the\u00a0init_command<\/code>\u00a0system variable.<\/li>\n- <\/a>\u00a0<\/a>
freeing items<\/code>The thread has executed a command. Some freeing of items done during this state involves the query cache. This state is usually followed by\u00a0cleaning up<\/code>.<\/li>\n- <\/a>\u00a0<\/a>
Flushing tables<\/code>The thread is executing\u00a0FLUSH TABLES<\/code><\/a>\u00a0and is waiting for all threads to close their tables.<\/li>\n- <\/a>\u00a0<\/a>
FULLTEXT initialization<\/code>The server is preparing to perform a natural-language full-text search.<\/li>\n- <\/a>\u00a0<\/a>
init<\/code>This occurs before the initialization of\u00a0ALTER TABLE<\/code><\/a>,\u00a0DELETE<\/code><\/a>,\u00a0INSERT<\/code><\/a>,SELECT<\/code><\/a>, or\u00a0UPDATE<\/code><\/a>\u00a0statements. Actions taken by the server in this state include flushing the binary log, the\u00a0InnoDB<\/code>\u00a0log, and some query cache cleanup operations.\nFor the\u00a0end<\/code>\u00a0state, the following operations could be happening:<\/p>\n\n\n- Removing query cache entries after data in a table is changed<\/li>\n
- Writing an event to the binary log<\/li>\n
- Freeing memory buffers, including for blobs<\/li>\n<\/ul>\n<\/div>\n<\/li>\n
- <\/a>\u00a0<\/a>
Killed<\/code>Someone has sent a\u00a0KILL<\/code><\/a>\u00a0statement to the thread and it should abort next time it checks the kill flag. The flag is checked in each major loop in MySQL, but in some cases it might still take a short time for the thread to die. If the thread is locked by some other thread, the kill takes effect as soon as the other thread releases its lock.<\/li>\n- <\/a>\u00a0<\/a>
Locked<\/code>The query is locked by another query.<\/li>\n- <\/a>\u00a0<\/a>
logging slow query<\/code>The thread is writing a statement to the slow-query log.<\/li>\n- <\/a>\u00a0<\/a>
NULL<\/code>This state is used for the\u00a0SHOW PROCESSLIST<\/code><\/a>\u00a0state.<\/li>\n- <\/a>\u00a0<\/a>
login<\/code>The initial state for a connection thread until the client has been authenticated successfully.<\/li>\n- <\/a>\u00a0<\/a><\/a><\/a>
Opening tables<\/code>,\u00a0Opening table<\/code>The thread is trying to open a table. This is should be very fast procedure, unless something prevents opening. For example, an\u00a0ALTER TABLE<\/code><\/a>\u00a0or aLOCK TABLE<\/code><\/a>\u00a0statement can prevent opening a table until the statement is finished. It is also worth checking that your\u00a0table_cache<\/code><\/a>\u00a0value is large enough.<\/li>\n- <\/a>\u00a0<\/a>
optimizing<\/code>The server is performing initial optimizations for a query.<\/li>\n- <\/a>\u00a0<\/a>
preparing<\/code>This state occurs during query optimization.<\/li>\n- <\/a>\u00a0<\/a>
Purging old relay logs<\/code>The thread is removing unneeded relay log files.<\/li>\n- <\/a>\u00a0<\/a>
query end<\/code>This state occurs after processing a query but before the\u00a0freeing items<\/code>state.<\/li>\n- <\/a>\u00a0<\/a>
Reading from net<\/code>The server is reading a packet from the network.<\/li>\n- <\/a>\u00a0<\/a>
Removing duplicates<\/code>The query was using\u00a0SELECT DISTINCT<\/code><\/a>\u00a0in such a way that MySQL could not optimize away the distinct operation at an early stage. Because of this, MySQL requires an extra stage to remove all duplicated rows before sending the result to the client.<\/li>\n- <\/a>\u00a0<\/a>
removing tmp table<\/code>The thread is removing an internal temporary table after processing a\u00a0SELECT<\/code><\/a>\u00a0statement. This state is not used if no temporary table was created.<\/li>\n- <\/a>\u00a0<\/a>
rename<\/code>The thread is renaming a table.<\/li>\n- <\/a>\u00a0<\/a>
rename result table<\/code>The thread is processing an\u00a0ALTER TABLE<\/code><\/a>\u00a0statement, has created the new table, and is renaming it to replace the original table.<\/li>\n- <\/a>\u00a0<\/a>
Reopen tables<\/code>The thread got a lock for the table, but noticed after getting the lock that the underlying table structure changed. It has freed the lock, closed the table, and is trying to reopen it.<\/li>\n- <\/a>\u00a0<\/a>
Repair by sorting<\/code>The repair code is using a sort to create indexes.<\/li>\n- <\/a>\u00a0<\/a>
Repair done<\/code>The thread has completed a multi-threaded repair for a\u00a0MyISAM<\/code>\u00a0table.<\/li>\n- <\/a>\u00a0<\/a>
Repair with keycache<\/code>The repair code is using creating keys one by one through the key cache. This is much slower than\u00a0Repair by sorting<\/code>.<\/li>\n- <\/a>\u00a0<\/a>
Rolling back<\/code>The thread is rolling back a transaction.<\/li>\n- <\/a>\u00a0<\/a>
Saving state<\/code>For\u00a0MyISAM<\/code>\u00a0table operations such as repair or analysis, the thread is saving the new table state to the\u00a0.MYI<\/code>\u00a0file header. State includes information such as number of rows, the\u00a0AUTO_INCREMENT<\/code>\u00a0counter, and key distributions.<\/li>\n- <\/a>\u00a0<\/a>
Searching rows for update<\/code>The thread is doing a first phase to find all matching rows before updating them. This has to be done if the\u00a0UPDATE<\/code><\/a>\u00a0is changing the index that is used to find the involved rows.<\/li>\nSending data<\/code>The thread is reading and processing rows for a\u00a0SELECT<\/code><\/a>\u00a0statement, and sending data to the client. Because operations occurring during this this state tend to perform large amounts of disk access (reads), it is often the longest-running state over the lifetime of a given query.<\/li>\n- <\/a>\u00a0<\/a>
setup<\/code>The thread is beginning an\u00a0ALTER TABLE<\/code><\/a>\u00a0operation.<\/li>\n- <\/a>\u00a0<\/a>
Sorting for group<\/code>The thread is doing a sort to satisfy a\u00a0GROUP BY<\/code>.<\/li>\n- <\/a>\u00a0<\/a>
Sorting for order<\/code>The thread is doing a sort to satisfy a\u00a0ORDER BY<\/code>.<\/li>\n- <\/a>\u00a0<\/a>
Sorting index<\/code>The thread is sorting index pages for more efficient access during a\u00a0MyISAM<\/code>table optimization operation.<\/li>\n- <\/a>\u00a0<\/a>
Sorting result<\/code>For a\u00a0SELECT<\/code><\/a>\u00a0statement, this is similar to\u00a0Creating sort index<\/code>, but for nontemporary tables.<\/li>\n- <\/a>\u00a0<\/a>
statistics<\/code>The server is calculating statistics to develop a query execution plan. If a thread is in this state for a long time, the server is probably disk-bound performing other work.<\/li>\n- <\/a>\u00a0<\/a><\/a><\/a>
System lock<\/code>The thread is going to request or is waiting for an internal or external system lock for the table. If this state is being caused by requests for external locks and you are not using multiple\u00a0mysqld<\/strong><\/a>\u00a0servers that are accessing the same\u00a0MyISAM<\/code><\/a>\u00a0tables, you can disable external system locks with the\u00a0