mysql基础信息常用sql

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 '%单价%'