1set default_storage_engine='tokudb'; 2drop table if exists tt; 3create table tt (a int, b int, key(b)); 4insert into tt values (1,0),(2,1),(3,2),(4,3); 5insert into tt values (5,0),(6,1),(7,2),(8,3); 6show indexes from tt; 7Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment 8tt 1 b 1 b A 8 NULL NULL YES BTREE 9analyze table tt; 10Table Op Msg_type Msg_text 11test.tt analyze status OK 12show indexes from tt; 13Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment 14tt 1 b 1 b A 8 NULL NULL YES BTREE 15flush tables; 16show indexes from tt; 17Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment 18tt 1 b 1 b A 8 NULL NULL YES BTREE 19drop table tt; 20