Table Op Msg_type Msg_text test.t1 check status OK Table Op Msg_type Msg_text test.t1 check status OK Table Op Msg_type Msg_text test.t1 repair status OK Table Op Msg_type Msg_text test.t1 check status OK Table Op Msg_type Msg_text test.t1 repair status OK Table Op Msg_type Msg_text test.t1 check status OK Table Op Msg_type Msg_text test.t1 optimize status OK Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment t1 0 PRIMARY 1 a A 5 NULL NULL t1 1 b 1 b A 1 NULL NULL Table Op Msg_type Msg_text test.t1 optimize status Table is already up to date Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment t1 0 PRIMARY 1 a A 5 NULL NULL t1 1 b 1 b A 1 NULL NULL table type possible_keys key key_len ref rows Extra t1 ALL NULL NULL NULL NULL 4 Using filesort table type possible_keys key key_len ref rows Extra t1 ALL NULL NULL NULL NULL 4 Using filesort table type possible_keys key key_len ref rows Extra t1 ALL NULL NULL NULL NULL 4 Using filesort table type possible_keys key key_len ref rows Extra t1 index NULL PRIMARY 4 NULL 4 Using index table type possible_keys key key_len ref rows Extra t1 index NULL b 4 NULL 4 Using index table type possible_keys key key_len ref rows Extra t1 ALL NULL NULL NULL NULL 4 Using filesort table type possible_keys key key_len ref rows Extra t1 ALL NULL NULL NULL NULL 4 table type possible_keys key key_len ref rows Extra t1 ALL NULL NULL NULL NULL 4