How to view the MySQL database size
This article mainly explains "how to check the size of the MySQL database". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to view the size of the MySQL database".
Access to the information_schema database (storing information from other databases)
Mysql > use information_schema
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with-A
Database changed
The first case: query the total size of all databases as follows:
Mysql > select concat (round (sum (DATA_LENGTH/1024/1024), 2), 'MB') as data from TABLES
+-+
| | data |
+-+
| | 3052.76MB |
+-+
1 row in set (0.02 sec)
The second case: check the size of the specified database, such as database test, as follows:
Mysql > select concat (round (sum (DATA_LENGTH/1024/1024), 2), 'MB') as data from TABLES where table_schema='test'
+-+
| | data |
+-+
| | 142.84MB |
+-+
1 row in set (0.00 sec)
Third: check the size of the table in the specified database, for example, the f_apply table in the database test, as follows:
Mysql > select concat (round (sum (DATA_LENGTH/1024/1024), 2), 'MB') as data from TABLES where table_schema='ixinnuo_financial' and table_name='f_apply'
+-+
| | data |
+-+
| | 0.08MB |
+-+
1 row in set (0.00 sec)
Thank you for your reading, the above is the content of "how to view MySQL database size". After the study of this article, I believe you have a deeper understanding of how to view MySQL database size, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!
