查询mysql数据库空间占用语句

进入information_schema 数据库（存放了其他的数据库的信息）

查询所有数据的大小：

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

查看实例下所有数据库的空间占用情况

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;

查看指定数据库的大小：

select concat(round(sum(data_length/1024/1024),2),'MB') as data from information_schema.tables where table_schema='addrcloud';

查看指定数据库下的所有表的空间占用情况

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;