1analyze table tt; 2Table Op Msg_type Msg_text 3test.tt analyze status OK 4set global tokudb_cardinality_scale_percent = 10; 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 4000 NULL NULL BTREE 8tt 1 b 1 b A 4000 NULL NULL YES BTREE 9tt 1 c 1 c A 4000 NULL NULL YES BTREE 10tt 1 d 1 d A 4000 NULL NULL YES BTREE 11set global tokudb_cardinality_scale_percent = 50; 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 0 PRIMARY 1 a A 4000 NULL NULL BTREE 15tt 1 b 1 b A 4000 NULL NULL YES BTREE 16tt 1 c 1 c A 4000 NULL NULL YES BTREE 17tt 1 d 1 d A 2000 NULL NULL YES BTREE 18set global tokudb_cardinality_scale_percent = 100; 19show indexes from tt; 20Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment 21tt 0 PRIMARY 1 a A 4000 NULL NULL BTREE 22tt 1 b 1 b A 4000 NULL NULL YES BTREE 23tt 1 c 1 c A 2000 NULL NULL YES BTREE 24tt 1 d 1 d A 1000 NULL NULL YES BTREE 25set global tokudb_cardinality_scale_percent = 200; 26Warnings: 27Warning 1292 Truncated incorrect tokudb_cardinality_scale_percent value: '200' 28show indexes from tt; 29Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment 30tt 0 PRIMARY 1 a A 4000 NULL NULL BTREE 31tt 1 b 1 b A 4000 NULL NULL YES BTREE 32tt 1 c 1 c A 2000 NULL NULL YES BTREE 33tt 1 d 1 d A 1000 NULL NULL YES BTREE 34