加速Mysql repair table的方法(转)

SET SESSION myisam_sort_buffer_size = 256*1024*1024;
SET SESSION read_buffer_size = 64*1024*1024;
SET GLOBAL myisam_max_sort_file_size = 100*1024*1024*1024;
SET GLOBAL repair_cache.key_buffer_size = 1024*1024*1024;
CACHE INDEX tbl_name  IN repair_cache;
LOAD INDEX INTO CACHE tbl_name ;
REPAIR TABLE tbl_name  ;
SET GLOBAL repair_cache.key_buffer_size = 0;



更多参考:

http://dev.mysql.com/doc/refman/5.0/en/repair-table-speed.html