查看数据数据大小

1.查看所有数据

select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from information_schema.TABLES;

2. 查看实例下所有数据库的空间占用情况
select
table_schema
,concat(round(sum(data_length/1024/1024),2),‘MB’) as data
from information_schema.tables
where table_schema like ‘db_name_%’
group by table_schema
;

3.查看指定数据库的大小：
select concat(round(sum(data_length/1024/1024),2),‘MB’) as data
from information_schema.tables
where table_schema=‘home’
;

4. 查看指定数据库下的所有表的空间占用情况
select table_name,round(sum(data_length/1024/1024),2) as size
from information_schema.tables
where table_schema=‘DB_NAME’
group by table_name
order by size
;