如何获取MySQL数据库表的大小？

您可以使用此查询显示表的大小（尽管您需要先替换变量）：

SELECt     table_name AS `Table`,     round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES WHERe table_schema = "$DB_NAME"    AND table_name = "$TABLE_NAME";

或此查询以列出每个数据库中每个表的大小，从大到大：

SELECt      table_schema as `Database`,      table_name AS `Table`,      round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC;