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,
oliver

Options: ReplyQuote


Subject
Views
Written By
Posted
repair table on 15m records
2629
February 02, 2005 03:15PM
2141
February 03, 2005 03:59AM
3436
February 03, 2005 11:43AM
1962
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.