mysql数据表占用空间查看

-- 1、查询所有数据库占用磁盘空间大小
select 
TABLE_SCHEMA, 
concat(truncate(sum(data_length)/1024/1024,2),' MB') as data_size,
concat(truncate(sum(index_length)/1024/1024,2),'MB') as index_size
from information_schema.tables
group by TABLE_SCHEMA
ORDER BY data_size desc
;

select 
TABLE_SCHEMA, t.TABLE_NAME,
concat(truncate(sum(data_length)/1024/1024,2),' MB') as data_size,
concat(truncate(sum(index_length)/1024/1024,2),'MB') as index_size
from information_schema.tables t where TABLE_SCHEMA = 'kettle'
group by TABLE_SCHEMA,TABLE_NAME
ORDER BY data_size desc
;