天天看点

mysql中show processlist_mysql中show processlist出现的问题

我在mysql中运行showprocesslist命令时,出现的结果如下,我只截取了前几行,为什么state列的值都是空的,而且command列的值都是sleep,info列的值都是null??????????+-----...

我在mysql中运行show processlist命令时,出现的结果如下,我只截取了前几行,为什么state列的值都是空的,而且command列的值都是sleep,info列的值都是null??????????

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

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

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

| 6 | root | localhost:3169 | sjzrixcbdb | Sleep | 163 | | NULL |

| 7 | root | localhost:3170 | sjzrixcbdb | Sleep | 163 | | NULL |

| 8 | root | localhost:3171 | sjzrixcbdb | Sleep | 163 | | NULL |

| 9 | root | localhost:3172 | sjzrixcbdb | Sleep | 163 | | NULL |

| 10 | root | localhost:3173 | sjzrixcbdb | Sleep | 163 | | NULL |

| 11 | root | localhost:3174 | sjzrixcbdb | Sleep | 163 | | NULL |

| 12 | root | localhost:3175 | sjzrixcbdb | Sleep | 163 | | NULL |

展开