统计mysql数据库占用磁盘空间大小和行数实例

select sum(t1.data_size ) as data_sum_size,  
sum(t1.index_size) as index_sum_size
from(
select
table_name,
table_schema,
truncate(data_length/1024/1024,2) as data_size, -- 查看数据占用大小单位为mb
truncate(index_length/1024/1024,2) as index_size -- 查看索引占用大小 单位为mb
from information_schema.tables
where table_schema = '数据库名'
order by data_length desc) t1;

select
table_name,
table_schema,
truncate(data_length/1024/1024,2) as data_size, -- 查看数据占用大小单位为mb
truncate(index_length/1024/1024,2) as index_size -- 查看索引占用大小 单位为mb
from information_schema.tables
where table_schema = '数据库名'
order by data_length desc

select sum(t1.table_rows) as table_sum from (
select table_name,table_rows from information_schema.tables
where table_schema = '数据库名'
order by table_rows desc) t1;

select table_name,table_rows from information_schema.tables
where table_schema = '数据库名'
order by table_rows des