查询耗时分析
查看执行语句:
MySQL [dbname]> show processlist;
+-----+-----------------+----------------------+--------+---------+-------+-----------------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+-----------------+----------------------+--------+---------+-------+-----------------------------+------------------------------------------------------------------------------------------------------+
| 1 | event_scheduler | localhost | NULL | Daemon | 27675 | Waiting for next activation | NULL |
| 2 | root | 114.55.72.122:41679 | dbname| Sleep | 25 | | NULL |
| 3 | root | 114.55.72.122:41682 | dbname| Sleep | 51 | | NULL |
| 4 | root