repair table on 15m records
hello all.
i am repairing a table that has ~15,000,000 records. i had a system crash two days ago, and it had a corrupted key file. so i started a 'repair table `name`' and it's been going ever since (2 days). here is top output:
op - 05:01:03 up 2 days, 11 min, 7 users, load average: 170.99, 170.83, 170.08
Tasks: 226 total, 1 running, 225 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.3% us, 0.0% sy, 0.0% ni, 0.0% id, 99.7% wa, 0.0% hi, 0.0% si
Mem: 906744k total, 902804k used, 3940k free, 4148k buffers
Swap: 0k total, 0k used, 0k free, 816388k cached
2.4ghz 800fsb cpu/motherboard, 1gig ram, and 2 40gb raptor sata hard disks. the mysql database has it's own hard disk. i didn't think a load average of 170 was possible :). should i be concerned? it's not hot, in fact the machine is quite cool. even the drives are rather cool. is there a faster alternative? is there a way to calculate how long this will take? an estimate? anything?
many thanks,
oliver