MySQL Forums
Forum List  »  Performance

repair table on 15m records
Posted by: oliver peek
Date: February 02, 2005 03:15PM

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,

Options: ReplyQuote

Written By
repair table on 15m records
February 02, 2005 03:15PM
February 03, 2005 03:59AM
February 03, 2005 11:43AM
February 04, 2005 11:58AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.