Page 1 of 1

Incorrect key file for table MYI'; try to repair it

Posted: Tue Dec 15, 2009 10:15 am
by bbrian017
Hey guys I'm Brian and I'm looking for help to determine why mysql starts running at 190% when I activate a module.

I currently use it here fine, vlogengage dot com

But when installed here I get an extremely high load, blogengage dot com

The website is active and live

The module is already written.

I'm getting the following message,

[ERROR] /usr/libexec/mysqld: Incorrect key file for table

Running pligg 1.0.3

[ERROR] /usr/libexec/mysqld: Incorrect key file for table './blogengage/pligg_links.MYI'; try to repair it

The Process for mysql is at 190%

I have the following specs

phpMyAdmin - 2.11.9.4

Operating System: CentOS 5
Processor: Intel Pentium 4 - 3.0 GHz
RAM: 1 GB
Total Disk Space: 120 GB

Any suggestions?

Thanks,

Brian

Re: Incorrect key file for table MYI'; try to repair it

Posted: Tue Dec 15, 2009 11:21 am
by McInfo
MySQL Manual: REPAIR TABLE

Edit: This post was recovered from search engine cache.

Re: Incorrect key file for table MYI'; try to repair it

Posted: Tue Dec 15, 2009 11:27 am
by bbrian017
Is this the same as using repair table in apache?

When I logged into mysql I selected repair table form the drop down menu.

Perhaps this is actually two separate issues then.

Re: Incorrect key file for table MYI'; try to repair it

Posted: Tue Dec 15, 2009 11:39 am
by McInfo
I don't think this has anything to do with Apache. Running a REPAIR TABLE query is the same as clicking the repair table link in phpMyAdmin, though.

This isn't my area of expertise, so proceed with caution. The manual page I linked to contains some important tips and some links to other pages that might be helpful.

Edit: This post was recovered from search engine cache.

Re: Incorrect key file for table MYI'; try to repair it

Posted: Tue Dec 15, 2009 11:42 am
by bbrian017
Yeah I already completed a few repair tables!

I'm not even sure if that specific error has anything to do with my real question.

See I'm trying to add a module to my website. When I add this specific module my CPU for mysql starts running at 190%

I currently use it here fine, vlogengage dot com

But when installed here I get an extremely high load, blogengage dot com

Does anyone know how to see what coudl be causing the high CPU usage?