Shulou(Shulou.com)06/01 Report--

How to view database size:

MariaDB [mysql]> show databases;

MariaDB [mysql]> use information_schema;

Query all database sizes:

MariaDB [mysql]> select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from TABLES;

Query formulated database size:

MariaDB [mysql]> select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from TABLES where table_schema='VIEWS';

You can see that you only need to specify the name of the database to query the database size. If you need to query the size of the table in the database, you can add the condition at the end:

MariaDB [mysql]> select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from TABLES where table_schema='VIEWS' and table_name='name';

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.