Mysql查看单列索引大小，建立查看删除索引

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='article' and database_name = 'tpcc1000' and stat_description like 'Number of pages in the index' group by table_name, index_name;

建立查看删除索引：

alter table article add fulltext index xk_parser(title) with parser xk_parser;

drop index index_name on table_name;

https://www.cnblogs.com/tianhuilove/archive/2011/09/05/2167795.html