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