今天主要介绍MySQL查看数据库表大小的几种方法，仅供参考。1.查看所有数据库的大小SELECTtable_schemaAS'数据库',sum(table_rows)AS'记录数',sum(TRUNCATE(data_length/1024/1024,2))AS'数据容量(MB)',sum(TRUNCATE(index_length/1024/1024,2))AS'索引容量(MB)'FROMinformation_schema.TABLESGROUPBYtable_schemaORDERBYsum(data_length)DESC,sum(index_length)DESC;2.查看所有数据库中每张表的大小SELECTtable_schemaAS'数据库',table_nameAS'表名',table_rowsAS'记录数',TRUNCATE(data_length/1024/1024,2)AS'数据容量(MB)',TRUNCATE(index_length/1024/1024,2)AS'索引容量(MB)'FROMinformation_schema.TABLESORDERBYdata_lengthDESC,index_lengthDESC;3.查看指定数据库容量SELECTtable_schemaAS'数据库',sum(table_rows)AS'记录数',sum(TRUNCATE(data_length/1024/1024,2))AS'数据容量(MB)',sum(TRUNCATE(index_length/1024/1024,2))AS'索引容量(MB)'FROMinformation_schema.TABLESWHEREtable_schema='mysql';4.查看指定数据库中各表的大小SELECTtable_schemaAS'数据库',table_nameAS'表名',table_rowsAS'记录数',TRUNCATE(data_length/1024/1024,2)AS'数据容量(MB)',TRUNCATE(index_length/1024/1024,2)AS'索引容量(MB)'FROMinformation_schema.TABLESWHEREtablee_schema='mysql'ORDERBYdata_lengthDESC,index_lengthDESC;
