一、查看各个数据库的大小 select table_schema as '数据库',sum(table_rows) as '记录数',sum(truncate(data_length/1024/1024, 2)) as '数据容量(MB)',sum(truncate(index_length/1024/1024, 2)) as '索引容量(MB)' from information_schema.tables group by table_schema order by sum(data_length) desc, sum(index_length) desc;

二、查看指定数据库的大小 select table_schema as '数据库', table_name as '表名', table_rows as '记录数',truncate(data_length/1024/1024, 2) as '数据容量(MB)',truncate(index_length/1024/1024, 2) as '索引容量(MB)'from information_schema.tables where table_schema='db_prod' order by data_length desc, index_length desc;

三、查看mysql变量 show global variables like '%timeout%';

四、查看mysql当前连接数 show status like 'Threads%';

或者 show full processlist;