mysql show processlist info null_mysql show processlist query显示state = null

我有一个脚本运行一批非常相似的查询。

点击

除了一个之外，他们都没有任何问题。

点击

只有一个查询卡住了。

点击

在“show processlist”中，查询的状态= null

点击

根据文档，show processlist只应为“show processlist”线程本身报告“State = null”。

点击

Server version: 5.0.67 MySQL Community Server (GPL)

mysql> show processlist;

+---------+--------+-----------+--------------+---------+------+-------+------------------------------------------------------------------------------------------------------+

| Id | User | Host | db | Command | Time | State | Info |

+---------+--------+-----------+--------------+---------+------+-------+------------------------------------------------------------------------------------------------------+

| 3866613 | user | localhost | db_name | Query | 1986 | NULL | select log_time,log_action,log_action_id,log_object_id, @abcde:=if(log_action='abcde',to_ |

| 3873414 | root | localhost | NULL | Query | 0 | NULL | show processlist |

+---------+--------+-----------+--------------+---------+------+-------+------------------------------------------------------------------------------------------------------+

2 rows in set (0.00 sec)