How to use commands to view Mysql database size _ MySQL

How to use commands to view the Mysql database size bitsCN.com

How to use commands to view the Mysql database size

1. enter the specified schema database (storing the information of other databases)

1

Use information_schema

2. query the size of all data

1

Select concat (round (sum (DATA_LENGTH/1024/1024), 2), 'mb') as data from TABLES

3. view the size of the specified database

For example, database apoyl

1

Select concat (round (sum (DATA_LENGTH/1024/1024), 2), 'mb') as data from TABLES where table_schema = 'apoyl ';

4. view the table size of the specified database

For example, the apoyl_test table in the database apoyl

1

Select concat (round (sum (DATA_LENGTH/1024/1024), 2), 'MB ') as data from TABLES where table_schema = 'apoyl' and table_name = 'apoyl _ test ';

If you are interested, try it! Pretty easy to use

BitsCN.com