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