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