| 1 |
select @@global.aria_recover_options; |
| 2 |
@@global.aria_recover_options |
| 3 |
BACKUP |
| 4 |
set global aria_recover_options=off; |
| 5 |
select @@global.aria_recover_options; |
| 6 |
@@global.aria_recover_options |
| 7 |
OFF |
| 8 |
set global aria_recover_options=default; |
| 9 |
select @@global.aria_recover_options; |
| 10 |
@@global.aria_recover_options |
| 11 |
BACKUP,QUICK |
| 12 |
set global aria_recover_options=normal; |
| 13 |
select @@global.aria_recover_options; |
| 14 |
@@global.aria_recover_options |
| 15 |
NORMAL |
| 16 |
drop database if exists mysqltest; |
| 17 |
create database mysqltest; |
| 18 |
use mysqltest; |
| 19 |
create table t1 (a varchar(1000), index(a)) engine=aria; |
| 20 |
Warnings: |
| 21 |
Note 1071 Specified key was too long; max key length is 2300 bytes |
| 22 |
insert into t1 values("ThursdayMorningsMarket"); |
| 23 |
flush table t1; |
| 24 |
insert into t1 select concat(a,'b') from t1 limit 1; |
| 25 |
set global aria_checkpoint_interval=1000; |
| 26 |
select * from t_corrupted2; |
| 27 |
a |
| 28 |
ThursdayMorningsMarket |
| 29 |
ThursdayMorningsMarketb |
| 30 |
Warnings: |
| 31 |
Error 145 Got error '145 "Table was marked as crashed and should be repaired"' for 't_corrupted2' |
| 32 |
Warning 1034 1 client is using or hasn't closed the table properly |
| 33 |
Error 176 Got error '176 "Read page with wrong checksum"' for 't_corrupted2.MAI' |
| 34 |
Error 1034 Can't read indexpage from page: 1, error: 176 |
| 35 |
select * from t_corrupted2; |
| 36 |
a |
| 37 |
ThursdayMorningsMarket |
| 38 |
ThursdayMorningsMarketb |
| 39 |
drop database mysqltest; |
| 40 |
set global aria_recover_options=backup; |
| 41 |
set global aria_checkpoint_interval=30; |