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