要想知道每個數(shù)據(jù)庫的大小的話，步驟如下：

1、進入information_schema 數(shù)據(jù)庫（存放了其他的數(shù)據(jù)庫的信息）

use information_schema;

2、查詢所有數(shù)據(jù)的大小：

select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables;

3、查看指定數(shù)據(jù)庫的大?。?/p>

比如查看數(shù)據(jù)庫home的大小

select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables where table_schema='home';

4、查看指定數(shù)據(jù)庫的某個表的大小

比如查看數(shù)據(jù)庫home中 members 表的大小

select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables where table_schema='home' and table_name='members';

查看MySQL數(shù)據(jù)庫大小

1.首先進入information_schema 數(shù)據(jù)庫（存放了其他的數(shù)據(jù)庫的信息）

mysql> use information_schema;Database changed

2.查看大小

（1）查看所有數(shù)據(jù)庫大小

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

結(jié)果：

（2）查看指定數(shù)據(jù)庫大小

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

結(jié)果

（3）查看指定數(shù)據(jù)庫的指定表單的大小

mysql> select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from TABLES where table_schema='CarData' and table_name='driver020294';

結(jié)果

查看指定數(shù)據(jù)庫指定表單的其他大小：

mysql> select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data_size,

? ? -> concat(round(sum(MAX_DATA_LENGTH/1024/1024),2),'MB') as max_data_size,

? ? -> concat(round(sum(INDEX_LENGTH/1024/1024),2),'MB') as index_size,

? ? -> concat(round(sum(DATA_FREE/1024/1024),2),'MB') as data_free

? ? -> from TABLES where table_schema='CarData' and table_name='driver020294';

結(jié)果：

注：第一步也可以不用使用數(shù)據(jù)庫，直接像下面這樣寫;

mysql> select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data_size,

? ? -> concat(round(sum(MAX_DATA_LENGTH/1024/1024),2),'MB') as max_data_size,

? ? -> concat(round(sum(INDEX_LENGTH/1024/1024),2),'MB') as index_size,

? ? -> concat(round(sum(DATA_FREE/1024/1024),2),'MB') as data_free

? ? -> from INFORMATION_SCHEMA.TABLES where table_schema='CarData' and table_name='driver020294';

結(jié)果是一樣的：