mysql常用指令

统计数据库对应各表的大小：

use information_schema;  

SELECT 

   TABLE_NAME,  

    (DATA_LENGTH/1024/1024) as DataM ,  

    (INDEX_LENGTH/1024/1024) as IndexM,   

    ((DATA_LENGTH+INDEX_LENGTH)/1024/1024) as AllM,  

    TABLE_ROWS  

FROM  

    TABLES  

WHERE  

    TABLE_SCHEMA = 'db-name';