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

How to get the size of the database in MySQL? in view of this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

1. Command line mode

Introduction:

To know the amount of space occupied by a table, it is equivalent to the data size + index size.

Show databases; (to see how many database, also known as table schema;, are a bit serial)

1.1 View the size of a single database (or table schema)

Select sum (DATA_LENGTH) + sum (INDEX_LENGTH) from information_schema.tables

Where table_schema=' name'

The result is in bytes, which is converted into megabytes divided by 1024 million 1024.

Note: the information_schema library contains a lot of statistical information about the entire database. You can get the database-related information by viewing them.

To make it easier, go directly to information_schema to check.

Use information_schema

Next, ignore the size of the index.

1.2 query the size of all data

Select concat (round (sum (DATA_LENGTH/1024/1024), 2),'M') from tables

This will take a little longer.

1.3 View the size of a table in the database

Select concat (round (sum (DATA_LENGTH/1024/1024), 2),'M') from tables where table_schema=' database name 'AND table_name=' table name'

two。 Software viewing mode

You can install PhpMyAdmin or you can see

This is the answer to the question about how to get the size of the database in MySQL. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

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.