Table Op Msg_type Msg_text test.t1 optimize status OK Table Op Msg_type Msg_text test.t1 check status OK test.t2 check error The handler for the table doesn't support check/repair Table Op Msg_type Msg_text test.t1 repair status OK test.t2 repair error The handler for the table doesn't support check/repair Table Op Msg_type Msg_text test.t2 check error The handler for the table doesn't support check/repair test.t1 check status OK Table Op Msg_type Msg_text test.t2 check error Table 't2' was not locked with LOCK TABLES test.t1 check status OK Field Type Null Key Default Extra a int(11) PRI 0 b int(11) MUL 0 c int(11) 0 Field Type Null Key Default Extra Privileges a int(11) PRI 0 select,insert,update,references b int(11) MUL 0 select,insert,update,references c int(11) 0 select,insert,update,references Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment t1 0 PRIMARY 1 a A 4 NULL NULL t1 1 b 1 b A 1 NULL NULL t1 1 b 2 c A 4 NULL NULL Table Op Msg_type Msg_text test.t1 check status Table is already up to date Table Op Msg_type Msg_text test.t1 check status Table is already up to date 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 check status OK Table Op Msg_type Msg_text test.t1 check 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 t1 1 b 2 c A 5 NULL NULL Table Op Msg_type Msg_text test.t1 optimize status OK Table Op Msg_type Msg_text test.t1 optimize status Table is already up to date Variable_name Value wait_timeout 28800 Variable_name Value Name Type Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Create_options Comment Database mysql test Database (test%) test Table Op Msg_type Msg_text test.t1 analyze status OK Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment t1 0 PRIMARY 1 f1 A 1 NULL NULL t1 0 PRIMARY 2 f2 A 3 NULL NULL t1 0 PRIMARY 3 f3 A 9 NULL NULL t1 0 PRIMARY 4 f4 A 18 NULL NULL Table Op Msg_type Msg_text test.t1 repair status OK Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment t1 0 PRIMARY 1 f1 A 1 NULL NULL t1 0 PRIMARY 2 f2 A 3 NULL NULL t1 0 PRIMARY 3 f3 A 9 NULL NULL t1 0 PRIMARY 4 f4 A 18 NULL NULL Table Create Table t1 CREATE TEMPORARY TABLE `t1` ( `a` int(11) NOT NULL default '0' ) TYPE=MyISAM Table Create Table t2 CREATE TEMPORARY TABLE `t2` ( `a` int(11) NOT NULL default '0' ) TYPE=MyISAM Table Create Table t1 CREATE TABLE `t1` ( `test_set` set('val1','val2','val3') NOT NULL default '', `name` char(20) default 'O''Brien' ) TYPE=MyISAM COMMENT='it''s a table' Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL default '0', UNIQUE KEY `aa` (`a`) ) TYPE=MyISAM Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL default '0', PRIMARY KEY (`a`) ) TYPE=MyISAM Open_tables_in_test Comment Open_tables_in_test Comment t1 cached=1, in_use=0