Myisamchk on really large tables.

2005-07-13 Thread RV Tec
Folks, We are going through a nasty problem, and I hope you guys can help me out. We are running a couple of MySQL 4.0.25 at 2 OpenBSD Opteron (246, 2GB RAM, 36GB RAID-1 15K), and for backup purposes, 1 Linux CentOS 4.0 Pentium 4 (3GHz, 1GB RAM, 80GB SATA 10K). They are all connected through

Re: Myisamchk on really large tables.

2005-07-13 Thread Gleb Paharenko
Hello. Check if the speed of recovering changes if you run myisamchk with -n option among other parameters to force using sort recovery. However, it requires a lot of disk space. See: http://dev.mysql.com/doc/mysql/en/myisamchk-repair-options.html I guess it might help because this