存储大小
-
如何准确测量MySQL数据库的存储大小?
要统计MySQL数据库的大小,可以使用以下SQL查询语句:SELECT table_schema AS “Database”, SUM(data_length + index_length) / 1024 / 1024 AS “Size (MB)” FROM information_schema.TABLES GROUP BY table_schema;
要统计MySQL数据库的大小,可以使用以下SQL查询语句:SELECT table_schema AS “Database”, SUM(data_length + index_length) / 1024 / 1024 AS “Size (MB)” FROM information_schema.TABLES GROUP BY table_schema;