MySQL Forums
Forum List  »  Performance

Repair with keycache benchmarks
Posted by: James Thorne
Date: April 16, 2008 10:37AM

Hi guys.

I have a small table (~500k rows), it had 2 large full text fields.
The table messed up and i am restoring a backup.

All the data has been inserted - but the status says:
Quote

Command: Query
Time: 7109
State: Repair with keycache
Info: /*!40000 ALTER TABLE `newsArticlesTexts` ENABLE KEYS */

Do you have any estimates on how long it should take? It has nearly been going for 2 hours.

Server CPU speed 3Ghz,
Server memory 4Gb,
Server OS CentOS 4

Options: ReplyQuote


Subject
Views
Written By
Posted
Repair with keycache benchmarks
5082
April 16, 2008 10:37AM
3562
April 16, 2008 12:28PM


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.