Mysql 索引相关sql

 

一、看特定数据库特定表的数据部分大小，索引部分大小和总占用磁盘大小

SELECT
    a.table_schema ,
    a.table_name ,
    concat(round(sum(DATA_LENGTH / 1024 / 1024) + sum(INDEX_LENGTH / 1024 / 1024) ,2) ,'MB') total_size ,
    concat(round(sum(DATA_LENGTH / 1024 / 1024) , 2) ,'MB') AS data_size ,
    concat(round(sum(INDEX_LENGTH / 1024 / 1024) , 2) ,'MB') AS index_size
FROM
    information_schema. TABLES a
WHERE
    a.table_schema = 'tkcloud_health'
AND a.table_name = 'health_act_third_dept';