MySQL 不常用命令
1、查看当前正在执行的查询
SHOW FULL PROCESSLIST;
查询结果
mysql> SHOW FULL PROCESSLIST; +-------+-----------------+---------------------+--------------+---------+---------+------------------------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+-----------------+---------------------+--------------+---------+---------+------------------------+-----------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 1881210 | Waiting on empty queue | NULL | | 38506 | root | 192.168.10.20:49440 | sscm_settled | Sleep | 1480 | | NULL | | 38515 | root | 192.168.10.20:49490 | nacos | Sleep | 9 | | NULL | | 38533 | root | 192.168.10.20:49546 | xxl_job | Sleep | 0 | | NULL | +-------+-----------------+---------------------+--------------+---------+---------+------------------------+-----------------------+
2、终止正在执行的查询( kill id号)
kill 38506;