Syntax error What is the way to check the size of all the MySQL databases?

What is the way to check the size of all the 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)
Updated on: 2020-01-28T10:56:05+05:30

124 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements