select id, db, user, host, command, time, state, info
from information_schema.processlist
where command != 'Sleep'
order by time desc ;
select CONCAT('kill ',id,' ;')
from information_schema.processlist
where command != 'Sleep' and id >1;
kill 12321
select * from information_schema.innodb_trx
select * from mysql.proc where db = 'db_name' and `type` = 'PROCEDURE'
select * from mysql.proc where db = 'db_name' and `type` = 'FUNCTION'
-- 查询存储过程和函数的关键字
select * from information_schema.ROUTINES
where ROUTINE_SCHEMA='db_name' and ROUTINE_DEFINITION like '%单价%'