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
Database	Table	In_use	Name_locked
Database	Table	In_use	Name_locked
test	t1	0	0
Table	Create Table
t1	CREATE TABLE `t1` (
  `a` int(11) NOT NULL default '0',
  `b` char(10) default NULL,
  KEY `b` (`b`)
) TYPE=MyISAM MIN_ROWS=10 MAX_ROWS=100 AVG_ROW_LENGTH=10 PACK_KEYS=1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=FIXED COMMENT='test'
Table	Create Table
t1	CREATE TABLE `t1` (
  `a` int(11) NOT NULL default '0',
  `b` varchar(10) default NULL,
  KEY `b` (`b`)
) TYPE=MyISAM MIN_ROWS=10 MAX_ROWS=200 AVG_ROW_LENGTH=10 PACK_KEYS=0 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='test'
Table	Create Table
t1	CREATE TABLE `t1` (
  `a` int(11) NOT NULL default '0',
  `b` varchar(10) default NULL,
  KEY `b` (`b`)
) TYPE=MyISAM