如何计算mysql数据库大小

                                            如何计算mysql数据库大小

      mysql大小可以通过 information_schema.tables中得出，不过内部开销不计算在内，所以是一个
近似的值

select
t.TABLE_SCHEMA "db name",
round(sum(t.INDEX_LENGTH+t.DATA_LENGTH)/1024/1024,2) "database size MB"
from information_schema.TABLES t
group by t.TABLE_SCHEMA

mysql> select
    -> t.TABLE_SCHEMA "db name",
    -> round(sum(t.INDEX_LENGTH+t.DATA_LENGTH)/1024/1024,2) "database size MB"
    -> from information_schema.TABLES t
    -> group by t.TABLE_SCHEMA
    -> ;
+--------------------+------------------+
| db name            | database size MB |
+--------------------+------------------+
| db1                |             0.09 |
| information_schema |             0.01 |
| mysql              |             0.91 |
| performance_schema |             0.00 |
| zabbix             |            20.80 |
+--------------------+------------------+
5 rows in set (0.01 sec)