当我在MySQL数据库中运行SHOW PROCESSLIST时,我得到以下输出:
mysql> show full processlist;
+--------+------+-----------+--------+---------+-------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------+-----------+-------+---------+-------+-------+-----------------------+
| 411665 | root | localhost | somedb | Sleep | 11388 | | NULL |
| 412109 | root | localhost | somedb | Query | 0 | NULL | show full processlist |
+--------+------+-----------+-------+---------+-------+-------+------------------------+
我想知道命令下的“睡眠”过程。什么意思?为什么它运行了很长一段时间并显示为空?这会使数据库变慢,当我杀死进程时,它就会正常工作。请帮帮我。
https://stackoverflow.com/questions/12194241
复制相似问题