mysql数据库巡检常用sql

SELECT VERSION();

SELECT table_schema AS 'Database', SUM(data_length + index_length) / 1024 / 1024 AS 'Size (MB)' FROM information_schema.TABLES GROUP BY table_schema;

SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) AS 'Size (MB)' FROM information_schema.TABLES WHERE table_schema = 'database_name' ORDER BY (data_length + index_length) DESC;

SHOW INDEX FROM table_name;

SHOW VARIABLES LIKE 'slow_query_log';

SHOW VARIABLES LIKE 'slow_query_log_file';

SHOW STATUS LIKE 'Threads_connected';

SHOW STATUS LIKE 'Qcache_free_memory';

SHOW ENGINE INNODB STATUS;

ANALYZE TABLE table_name;