Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to view the MySQL database size

2025-03-29 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report