MySQL估算数据库大小

SELECT

CONCAT(

ROUND(SUM(data_length / 1024 / 1024), 2),

'MB'

) AS data_length_MB,

CONCAT(

ROUND(SUM(index_length / 1024 / 1024), 2),

'MB'

) AS index_length_MB

FROM

information_schema.TABLES

WHERE table_schema = 'weaver_dev'

+----------------+-----------------+

| data_length_MB | index_length_MB |

+----------------+-----------------+

| 1200.13MB | 358.56MB |

+----------------+-----------------+

命令端估算只统计了表和索引文件大小，完整 MySQL占用空间需datadir目录下的所有文件