mysql数据库查看表占用空间

1.通过information_schema.TABLES来查看每一个表的相信信息，比如：table_rows, avg_row_length, data_length, man_data_length, date_free等数据

查看该数据库实例下所有库大小，得到的结果是以MB为单位 

1. select table_schema,sum(data_length)/1024/1024 as data_length,sum(index_length)/1024/1024 \  
2. as index_length,sum(data_length+index_length)/1024/1024 as sum from information_schema.tables;  
3. +--------------------+---------------+--------------+---------------+  
4. | table_schema       | data_length   | index_length | sum           |  
5. +--------------------+---------------+--------------+---------------+  
6. | information_schema | 2734.92757511 |  86.27539063 | 2821.20296574 |  
7. +--------------------+---------------+--------------+---------------+ 

查看该实例下各个库大小

1. select table_schema, sum(data_length+index_length)/1024/1024 as total_mb,   
2. sum(data_length)/1024/1024 as data_mb, sum(index_length)/1024/1024 as index_mb,   
3. count(*) as tables, curdate() as today from information_schema.tables group by table_schema order by 2 desc;  
4. +--------------------+---------------+---------------+-------------+--------+------------+  
5. | table_schema       | total_mb      | data_mb       | index_mb    | tables | today      |  
6. +--------------------+---------------+---------------+-------------+--------+------------+  
7. | data_1234567890    | 2820.59610939 | 2734.39689064 | 86.19921875 |     65 | 2015-11-02 |  
8. | mysql              |    0.60579967 |    0.53744030 |  0.06835938 |     14 | 2015-11-02 |  
9. | information_schema |    0.00781250 |    0.00000000 |  0.00781250 |     35 | 2015-11-02 |   查看单个表状态 show table status from data_1234567890 where name = ‘data_1234567890_ss‘ \G  

mysql数据库查看表占用空间

原文：https://www.cnblogs.com/lh-php/p/14066039.html