I need database help - its really bad

Hey everyone,

I really need someone to guide me through this. I absolutely have no idea why this is going on.

Problem: This Account Has Exceeded Its CPU Quota
When it happens: Started about 3 months ago and now eveytime i try to use my blog admin panel it shows up . I thought that it was a databse problem

Action taken: i have installed wp super cache and wp database thinking it will optimize the database better and now the situation worsen.

I just do not know what to do. I am not a server admin so no idea at all. Please help.

Update: I have looked into the error log and i have found the following.

[11-Oct-2008 06:33:14] WordPress database error MySQL server has gone away for query UPDATE wp_options SET option_value = '0' WHERE option_name = 'doing_cron' made by update_option
[11-Oct-2008 07:02:56] WordPress database error MySQL server has gone away for query UPDATE wp_options SET option_value = '0' WHERE option_name = 'doing_cron' made by update_option
[11-Oct-2008 08:51:39] WordPress database error MySQL server has gone away for query UPDATE wp_options SET option_value = '0' WHERE option_name = 'doing_cron' made by update_option
[11-Oct-2008 09:13:24] WordPress database error MySQL server has gone away for query UPDATE wp_options SET option_value = '0' WHERE option_name = 'doing_cron' made by update_option
[11-Oct-2008 09:14:15] WordPress database error MySQL server has gone away for query UPDATE wp_options SET option_value = '0' WHERE option_name = 'doing_cron' made by update_option
[11-Oct-2008 09:53:49] WordPress database error MySQL server has gone away for query UPDATE wp_options SET option_value = '0' WHERE option_name = 'doing_cron' made by update_option
[11-Oct-2008 10:18:08] WordPress database error MySQL server has gone away for query UPDATE wp_options SET option_value = '0' WHERE option_name = 'doing_cron' made by update_option
[14-Oct-2008 10:45:27] WordPress database error MySQL server has gone away for query UPDATE wp_options SET option_value = '0' WHERE option_name = 'doing_cron' made by update_option
[14-Oct-2008 11:09:09] WordPress database error MySQL server has gone away for query UPDATE wp_options SET option_value = '0' WHERE option_name = 'doing_cron' made by update_option

PHP:

Its not the bandwidth or the storage issue, i have unlimited BTW

 

Sounds more like an issue with your host. (perhaps one of those UNLIMITED deals your advertising ?)

 

If you are sure this query uses too much cpu, then make an index on column 'option_name'

or check how many lines there are and see if you can delete some ?

 

This seems to be an issue with your host's MySQL server. Contact them regarding this error message.

If you have any issue with MySQL performance, tune your database and queries by creating indexes and using them. You might need EXPLAIN and slow query log to optimize your queries.

 

Is this one of the fixes you tried:
robsnotebook.com/wordpress-mysql-gone-away

Have you replace that "fixed" wp-dp.php file with each upgrade ?

 

i have tried changing the new wp-dp.php file today but it didnt work. I am having the same old problem.

i have told my hosting company about this issue and they are telling me to try creating a new databse and swap the existing wp database. I will try to do that tonight.

This problem is simple getting under my skin now.
Is there anyone can look into it.?? I am willing to pay for it if anyone can fix this.

 

I am not a SQL expert, but I do know Unix/Linux.

Do you have a cron job set up to do anything with the database? I say this because of the 'doing_cron' entry in your logs. Looks like it could be trying to do some type of update on a fairly regular basis and cannot do it because it can't get to the database. "MySql server has gone away".

I might be making a big fool of myself, but maybe it will help someone who knows SQL to find out what the problem is.

Good luck
Zeek