mysql+data+比较大小,您如何找出MySQL数据库中数据的总大小？

How do you calculate the total size of the database in MySQL?

P.S. Total size in term of how much disk space is using.

解决方案

This link has a pretty intense query... that will give you more than you need...:

SELECT s.schema_name,

CONCAT(IFNULL(ROUND((SUM(t.data_length)+SUM(t.index_length)) /1024/1024,2),0.00)) total_size_in_MB,

CONCAT(IFNULL(ROUND(((SUM(t.data_length)+SUM(t.index_length))-SUM(t.data_free))/1024/1024,2),0.00)) data_used_IN_MB,

CONCAT(IFNULL(ROUND(SUM(data_free)/1024/1024,2),0.00)) data_free_IN_MB,

IFNULL(ROUND((((SUM(t.data_length)+SUM(t.index_length))-SUM(t.data_free))/((SUM(t.data_length)+SUM(t.index_length)))*100),2),0) pct_used,

COUNT(table_name) total_tables

FROM INFORMATION_SCHEMA.SCHEMATA s

LEFT JOIN INFORMATION_SCHEMA.TABLES t ON s.schema_name = t.table_schema

WHERE s.schema_name = 'abc' -- give your schema name

GROUP BY s.schema_name

ORDER BY pct_used DESC;