repair.result 1.83 KB
Newer Older
1 2 3 4 5 6
drop table if exists t1;
create table t1 SELECT 1,"table 1";
repair table t1 use_frm;
Table	Op	Msg_type	Msg_text
test.t1	repair	warning	Number of rows changed from 0 to 1
test.t1	repair	status	OK
7
alter table t1 ENGINE=HEAP;
8 9
repair table t1 use_frm;
Table	Op	Msg_type	Msg_text
10
test.t1	repair	note	The storage engine for the table doesn't support repair
11
drop table t1;
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
create table t1(id int PRIMARY KEY, st varchar(10), KEY st_key(st));
insert into t1 values(1, "One");
alter table t1 disable keys;
show keys from t1;
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
t1	0	PRIMARY	1	id	A	1	NULL	NULL		BTREE	
t1	1	st_key	1	st	A	NULL	NULL	NULL	YES	BTREE	disabled
repair table t1 extended;
Table	Op	Msg_type	Msg_text
test.t1	repair	status	OK
show keys from t1;
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
t1	0	PRIMARY	1	id	A	1	NULL	NULL		BTREE	
t1	1	st_key	1	st	A	NULL	NULL	NULL	YES	BTREE	disabled
drop table t1;
serg@serg.mylan's avatar
serg@serg.mylan committed
27 28
repair table t1 use_frm;
Table	Op	Msg_type	Msg_text
29
test.t1	repair	error	Table 'test.t1' doesn't exist
30
create table t1 engine=myisam SELECT 1,"table 1";
31
flush tables;
serg@serg.mylan's avatar
serg@serg.mylan committed
32 33 34 35 36 37 38 39
repair table t1;
Table	Op	Msg_type	Msg_text
test.t1	repair	error	Can't open file: 't1.MYI' (errno: 130)
repair table t1 use_frm;
Table	Op	Msg_type	Msg_text
test.t1	repair	warning	Number of rows changed from 0 to 1
test.t1	repair	status	OK
drop table t1;
40 41 42 43 44 45 46 47 48 49 50
CREATE TABLE t1(a INT, KEY(a));
INSERT INTO t1 VALUES(1),(2),(3),(4),(5);
SET myisam_repair_threads=2;
REPAIR TABLE t1;
Table	Op	Msg_type	Msg_text
test.t1	repair	status	OK
SHOW INDEX FROM t1;
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
t1	1	a	1	a	A	5	NULL	NULL	YES	BTREE	
SET myisam_repair_threads=@@global.myisam_repair_threads;
DROP TABLE t1;