原文链接 MySQL查看表占用空间大小 查看方法 查看指定数据库所有表容量大小 SELECT table_schema AS '数据库', table_name AS '表名', table_rows AS '记录数', TRUNCATE(data_length / 1024 / 1024, 2) AS '数据容量(MB)', TRUNCATE (index_length / 1024 / 1024, 2) AS '索引容量(MB)' FROM information_schema.tables WHERE tab…