mysql 查看单个表每个索引的大小

/*单个表每个索引的大小*/

SELECT
       sum(stat_value) pages,
       table_name part,
       index_name,
       concat(round(sum(stat_value)/1000000,2),'M',' rows') * @@innodb_page_size size
FROM
       mysql.innodb_index_stats
WHERE
           table_name = '你的表名'
       AND database_name = '你的数据库名'
       AND stat_description LIKE 'Number of pages in the index'
GROUP BY
       table_name, index_name;

错误说明：用户名权限不够

 

转载于:https://www.cnblogs.com/shmily3929/p/10064229.html