SUM(data_length+index_length)/1024/1024"SizeinMB"->FROMinformation_schema.TABLESGROUPBYtable_schema;+---------- ----------+----------------+|Database &"/> SUM(data_length+index_length)/1024/1024"SizeinMB"->FROMinformation_schema.TABLESGROUPBYtable_schema;+---------- ----------+----------------+|Database &">

Home >Database >Mysql Tutorial >How to view the size of all MySQL databases?

How to view the size of all MySQL databases?

WBOY
WBOYforward
2023-09-17 12:17:09762browse

How to view the size of all MySQL databases?

We can check the size of all MySQL databases with the help of the following statement

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)

The above is the detailed content of How to view the size of all MySQL databases?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete