查看MYSQL数据库大小，指定表大小的方法

1、查询所有数据的大小

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

2、查看指定数据库的大小

比如说 数据库bbs

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

3、查看指定数据库的表的大小

比如说 数据库bbs中post表

select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data  from information_schema.TABLES where table_schema='bbs' and table_name='post';

并按大小排序
select table_name, round(sum(DATA_LENGTH/1024/1024),2) as data  from information_schema.TABLES where table_schema='bbs' GROUP BY table_name ORDER BY data;