---Mysql查询表的容量use information_schema;select table_name,concat(round((data_length+index_length)/1024/1024/1024),'GB') as table_capacity,table_rows from tables where table_schema='db_name' order by table_capacity desc;
本文共 260 字，大约阅读时间需要 1 分钟。
---Mysql查询表的容量use information_schema;select table_name,concat(round((data_length+index_length)/1024/1024/1024),'GB') as table_capacity,table_rows from tables where table_schema='db_name' order by table_capacity desc;
转载于:https://my.oschina.net/Kxvz/blog/598158