Wordpress DB making overload on VPS

[Apathetic]

It's normal for it to go that way when you are inserting/updating for a myISAM table.

[BlaZe]

Did you do try optimizing my.cnf file ? Its for tuning the mysql daemon.

I did whatever written here http://www.linuxweblog.com/tune-my.cnf and my load became half. But the remaining load was due to High IO Wait time.

If you want to see whats going on with the mysql database, I would suggest installing mytop, which is a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL 3.22.x, 3.23.x, and 4.x server.

http://jeremy.zawodny.com/mysql/mytop/

[cvrle77]

@ Apathetic
I don't have one blog using same settings. Lots of them run same settings, only one is facing this issue. I've converted to InnoDB and enabled Innodb use from my.cnf.
Once I tried to post, server almost crashed, it was unresponsive for more than a minute.

[BlaZe]

Don't use InnoDB engine, its shit. Use MyISAM engine

Also, if the problem still prevails then you no option other than move the site to a separate VPS.

[deAthbLisS]

try disabling w3 cache,
repair, optimize database,
check your phpmyadmin status, try increasing the values which are in red by editing the config.

[okone]

When you do the database on/off test I mentioned before, make sure you are logged out and using the cache.

If you're using the static page cache (Disk Enhanced), you can also check you are using the cache (without having to turn mysql off) by looking at the date stamp in the html source of a page. It should be the same as the static cached file in wp-content/w3tc/pgcache.

I use nginx instead of apache, but those rules in htaccess look fine to me.

[cvrle77]

Oh, I forgot to log out

Yes, it's loading when I'm logged out.
Not sure how is W3 related to posting.
Load only happens when I am posting something new on blog.
Other than that, load is average at 1-2 top

[okone]

As mentioned in the shoutbox, if you use Google XML Sitemaps, try disabling automatic creation and enable creation via the GET request (you will need to setup a cronjob).

Alternatively, use BWP's plugin: http://s.p2.pe/4gq.

[cvrle77]

Using BWP already, tried disabling it, to see the difference, there is none
FML

[axl]

how many post do you have btw?