To speed up table repairing use large values for key buffer and sort buffer. Both values can be made very large cause only one of them is used at a time.
Eg: myisamchk --key_buffer_size=512M --sort_buffer_size=512M --read_buffer_size=8M --write_buffer_size=8M ./path/to/database/table.MYI
--sort-recover, -n
Wednesday, October 17, 2007
Subscribe to:
Posts (Atom)