Mysql 查询数据库容量大小的方法步骤

查询所有数据库的总大小

方法如下：

mysql> use information_schema; mysql> select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from TABLES; +-----------+ | data   | +-----------+ | 3052.76MB | +-----------+ 1 row in set (0.02 sec)

统计一下所有库数据量

每张表数据量=AVG_ROW_LENGTH*TABLE_ROWS+INDEX_LENGTH

SELECT SUM(AVG_ROW_LENGTH*TABLE_ROWS+INDEX_LENGTH)/1024/1024 AS total_mb FROM information_schema.TABLES

统计每个库大小：

SELECT table_schema,SUM(AVG_ROW_LENGTH*TABLE_ROWS+INDEX_LENGTH)/1024/1024 AS total_mb FROM information_schema.TABLES group by table_schema;

第二种情况：查看指定数据库的大小，比如说：数据库test，方法如下：

mys