Re: Repair with keycache benchmarks

[Clint Byrum]

repair with keycache can take orders of magnitude longer than filesort or just sort.

Since you are doing fulltext indexes, it makes sense that the server would perceive that the index file would be very large, so it uses keycache.

You may want to kill that enable keys, and repair the indexes with

myisamchk --sort-recover --tmpdir=/path/to/disks/with/free/space --ft_min_word_len=xxx --ft_xyz tbl_name.MYI

You'll need the ft_XXX options that are in the [mysqld] section of your my.cnf files, or it will build your index incorrectly.

I've had this speed things up from 5 hours down to 40 minutes...