How to use SQL commands to view Mysql database size _ MySQL

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

To know the size of each database, follow these steps:
1. enter the information_schema database (storing information about other databases)
Use information_schema;

2. query the size of all data:
Select concat (round (sum (data_length/1024/1024), 2), 'mb') as data from tables;

3. view the size of the specified database:
For example, you can view the size of the database home.
Select concat (round (sum (data_length/1024/1024), 2), 'mb') as data from tables where table_schema = 'home ';

4. view the size of a table in the specified database
For example, you can view the size of the members table in the database home.
Select concat (round (sum (data_length/1024/1024), 2), 'mb') as data from tables where table_schema = 'home' and table_name = 'members ';

BitsCN.com