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

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
bbrian017
Forum Newbie
Posts: 3
Joined: Tue Dec 15, 2009 10:04 am

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

Post 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
User avatar
McInfo
DevNet Resident
Posts: 1532
Joined: Wed Apr 01, 2009 1:31 pm

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

Post by McInfo »

MySQL Manual: REPAIR TABLE

Edit: This post was recovered from search engine cache.
Last edited by McInfo on Thu Jun 17, 2010 3:46 pm, edited 1 time in total.
bbrian017
Forum Newbie
Posts: 3
Joined: Tue Dec 15, 2009 10:04 am

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

Post 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.
User avatar
McInfo
DevNet Resident
Posts: 1532
Joined: Wed Apr 01, 2009 1:31 pm

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

Post 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.
Last edited by McInfo on Thu Jun 17, 2010 3:47 pm, edited 1 time in total.
bbrian017
Forum Newbie
Posts: 3
Joined: Tue Dec 15, 2009 10:04 am

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

Post 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?
Post Reply