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