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?

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBforward
2023-09-17 12:17:09784browse

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