You might try running an optimize and repair on your database using a plugin or phpmyadmin.
I’ve optimized it about 5-6 times last month, but the results stay the same.
How many posts/pages do you have? Cleaning out old post/page revisions can greatly reduce the size of your database and increase it’s speed. Also, empty your trash and delete spam comments.
Run as SQL query in phpmyadmin to delete post/page revisions. Backup your DB first.
DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = 'revision'
You can add to wp-config.php to stop revisions and autosave:
define ('WP_POST_REVISIONS', FALSE);
define('AUTOSAVE_INTERVAL', 6000);
Or select the number of revisions to keep:
define('WP_POST_REVISIONS', 3);
I got 925 posts and 5 pages. Trash and Spam are always empty. I just checked that wassup plugin uses over than 2.5 million records. Could this be the problem? I deleted both the plugin and the table, I ‘ll tell you if this is going to work!
Well nothing happened, CPU throttling increases like devil (as traffic increases)… 🙁
I’d Clean Options « WordPress Plugins and be sure the wassup plugin is really gone.
Checked that wassup is fully gone, but same things again. CPU throttling goes like hell. And “error establishing database connection” appears 3-4 times every day, when there is much traffic. Any other idea? 🙁
“error establishing database connection” is the host database server going down. Who is your host? Might be better of finding another one.
It’s hostmonster. Moving to another server costs money and time. And the result is not guaranteed…
having the same problem of cpu throttling about all the day 24hours. from hostmonster
done several things but no results.
HAve a hostmonster account as well with the same random error.
More often than not. Have to refresh many times before it shows.
throttling of the server maybe?
Has anyone resolved this with hostmonster aka bluehost yet?
PLEASE RESPOND IF YOU HAVE!
thanks!
