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
Incorrect key file for table MYI'; try to repair it
Moderator: General Moderators
Re: Incorrect key file for table MYI'; try to repair it
Last edited by McInfo on Thu Jun 17, 2010 3:46 pm, edited 1 time in total.
Re: Incorrect key file for table MYI'; try to repair it
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.
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
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.
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.
Re: Incorrect key file for table MYI'; try to repair it
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?
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?