- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 28-Jan-2020 10:56:05
- Related Questions & Answers
- How can we check the default character sets of all the MySQL databases we have on the server?
- What is the most efficient way to check the presence of a row in a MySQL table?
- 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?
- How to get the list of all databases using JDBC?
- What is the easiest way to store date in MySQL database?
- Is there a way to list all the reserved words in MySQL using the MySQL command-line utility?
- MySQL permissions to view all databases?
- What is the query to check Character set of the columns of MySQL table?
Advertisements