Wordpress DB making overload on VPS

[cvrle77]

So I have (had) this blog with lots of posts, db was about 140MB, and lately, db is making huge load on VPS to that point, that it crash, and shuts down. It wouldn't upset me at all, if I don't have other sites there, and everything goes byebye. Right now, I had to put it in maintenance mode, so visitors don't pull data from db.

List of things I've tried:

• I had W3 cache plugin, nothing, doesn't help when db starts going wild
• I've tried turning off all plugins, didn't helped
• Tried turning off all RSS feeds, nothing
• Also tried to export all posts with wordpress export tool, and reinstall fresh wordpress with fresh db, then import back all posts, by dividing original file into smaller chunks, didn't even imported all posts, same..
• Ok, just tested it, even with maintenance plugin, I am getting load of 18

Btw, there is few other sites on same VPS, receiving same amount of visitors like the troubled one, but load doesn't go over 1. Also wordpress sites. So, I guess MySQL settings would impact them too, if something is optimized bad.


I'm basically clueless what it can be.
Any ideas??

The one who finds me a working solution will be credited with rapidpoints equal to 2 years RS account, in case that is ok with the KWWH rules, and I can actually offer that here. That is not a PAYMENT, it's a reward for your effort and time.
To mods: in case this type of reward is not allowed, please, only remove RS line, don't close topic.
Since it's not a trade case, and I don't give the actual premium account ( I give points from my own account, transferring to someone elses )
So, I can ask for help for free, but instead, I will give away something.

EDIT: Huge load occurs ONLY when I post a new post on blog. Not when lots of users are online, or do a search or anything, in regular circumstances, load is not over 1.

cvrle77 Reviewed by cvrle77 on 10th May 2012. Wordpress DB making overload on VPS So I have (had) this blog with lots of posts, db was about 140MB, and lately, db is making huge load on VPS to that point, that it crash, and shuts down. It wouldn't upset me at all, if I don't have other sites there, and everything goes byebye. Right now, I had to put it in maintenance mode, so visitors don't pull data from db. List of things I've tried: I had W3 cache plugin, nothing, doesn't help when db starts going wild I've tried turning off all plugins, didn't helped Tried Rating: 5

[Qoo]

Try disabling all your plug ins and monitor the load. If the load no longer shoots up high, you know it's a plug in fault and the you can try enabling them one by one to find out which is the causing the high load. If you don't have plug ins installed then I'm not too sure

[cvrle77]

That is the second thing I've mentioned, that didn't worked.

I've tried turning off all plugins, didn't helped

[Qoo]

If you have spare hosting elsewhere, could you try to move the site and do a simple test? It could just be the vps/hosting you are on o_O

[cvrle77]

Yes, I've already moved because of that. Funny, is that other wordpress sites are having same theme, same plugins, same settings, none of them is making problems.

[Smith]

cvrle, my suggestions is that you TURN OFF revisions. Manually disable them in Wordpress configuration file.

[cvrle77]

That is already set

[vgnheart]

any control panel used on your vps ?

[Cometolearn]

use wp super cache an in advannce setting tick cache for known user , hope this will help.

[BlaZe]

The issue is not with wordpress. Its with your VPS.

I had the same issue few months ago. The problem was with the VPS high IO wait. This problem was due to the VPS upstream provider and eventually the host (BuyVPS.co) fixed it.

But before that, I tried optimizing the mysqld. I also converted my DB from InnoDB to MyISAM engine.

Login to SSH
Type iostat or iotop and show us the output here. Also type top and free -m and show us the output.