mysql dba常用命令_MySql之DBA常用命令集锦

Mysql之DBA常用命令集锦

show status like 'Threads_connected';

show status like 'Threads_running';

show full processlist;

show status like 'table%';

show variables like '%max_connections%';

show variables like 'log_slow_queries';

show variables like 'long_query_time';

show profiles;

show PROCESSLIST;

use admin;

show profiles;

SELECT STATE AS `Status`, ROUND(SUM(DURATION),7) AS `Duration`,

CONCAT(ROUND(SUM(DURATION)/0.001644*100,3), '%') AS `Percentage` FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID=77 GROUP BY STATE

-- 当前运行的所有事务 当前出现的锁 锁等待的对应关系

select * from information_schema.innodb_trx limit 100;

select * from information_schema.innodb_locks limit 100;

select * from information_schema.innodb_lock_waits limit 100;

参考文章：https://www.centos.bz/2017/10/mysql-%E8%A1%A8%E9%94%81%E6%83%85%E5%86%B5%E6%9F%A5%E7%9C%8B/