【工作中使用之数据库】MySQL 数据库

数据库表容量大小查询语句

select
table_schema as '数据库',
table_name as '表名',
table_rows as '记录数',
truncate(data_length/1024/1024/1024, 2) as '数据容量(G)',
truncate(index_length/1024/1024/1024, 2) as '索引容量(G)'
from information_schema.tables
order by data_length desc, index_length desc;

正在执行中sql的查询

SELECT * FROM information_schema.PROCESSLIST -- WHERE COMMAND <> 'Sleep' ;