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 . 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