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)

Ankith Reddy

Published on 19-Feb-2018 07:37:18

• Related Questions & Answers
• What is the most efficient way to check the presence of a row in a MySQL table?
• How can we check the default character sets of all the MySQL databases we have on the server?
• What is the synonym statement of SHOW DATABASES with the help of which we can see the list of MySQL databases?
• What is the best way to check capacity in Java?
• What is the MySQL VARCHAR max size?
• How to get all the collections from all the MongoDB databases?
• What is the most elegant way to check if the string is empty in Python?
• What is the fastest way to update the whole document (all fields) in MongoDB?
• What is the correct way to check if String is empty in Java?
• How to get the list of all the MongoDB databases using java?
• What is the easiest way to store date in MySQL database?
• How to get the list of all databases using JDBC?
• Is there a way to list all the reserved words in MySQL using the MySQL command-line utility?
• What is the query to check Character set of the columns of MySQL table?
• MySQL permissions to view all databases?