我们可以借助以下语句检查所有mysql数据库的大小
mysql> select table_schema "database",-> sum(data_length + index_length)/1024/1024 "size in mb"-> from information_schema.tables group by table_schema;+--------------------+----------------+| database | size in mb |+--------------------+----------------+| gaurav | 1.04785156 || information_schema | 0.00878906 || mysql | 0.68551350 || performance_schema | 0.00000000 || sample | 0.04687500 || tutorial | 0.03125000 |+--------------------+----------------+6 rows in set, 1 warning (0.33 sec)
以上就是如何查看所有mysql数据库的大小?的详细内容。