Index Info…

SELECT DISTINCT     TABLE_NAME, INDEX_NAME,COLUMN_NAME, index_type FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA =’thinklouder_optimization’;

SHOW INDEXES FROM table_name IN database_name;

——————————————————

OPTIMIZE TABLE tbl; 

will rebuild the indexes and do ANALYZE; it takes time.

——————————————————

ANALYZE TABLE tbl; 

is fast for InnoDB to rebuild the stats. With 5.6.6 it is even less needed.

——————————————————

Read the article