mysql查询所有表数据大小

mysql查询所有表空间大小

 

select table_name,table_rows,data_length+index_length,
concat(round((data_length+index_length)/1024/1024/1024,2),'GB')
data from information_schema.tables where table_schema='db' order by data desc