Latest Announcemnent
New thread
Status
Not open for further replies.
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/
 
@ 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.
 
Don't use InnoDB engine, its shit. Use MyISAM engine :D

Also, if the problem still prevails then you no option other than move the site to a separate VPS.
 
try disabling w3 cache,
repair, optimize database,
check your phpmyadmin status, try increasing the values which are in red by editing the config.
 
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.
 
Oh, I forgot to log out :blush:

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

x56Mr.png
 
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.
 
my.cnf
[mysqld]
port = {blah}
socket = /var/lib/mysql/mysql.sock
skip-locking

key_buffer = 128M
max_allowed_packet = 1M
table_cache=1024
thread_cache_size=4

max_connections=256
max_user_connections=32

join_buffer_size=2M
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 4M

query_cache_size=512M
query_cache_type=1

tmp_table_size=128M
max_heap_table_size=128M

skip-bdb
# skip-innodb

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer = 8M
sort_buffer_size = 8M

[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout
Click to expand...
 
are you pinging new topics to a huge list of sites? iv read through the thread and its the only thing i can think of. it makes sense since it only occurs when new topics are posted.
 
BlaZe said:
Don't use InnoDB engine, its shit. Use MyISAM engine :D

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

InnoDB aint shit :| It's perfect for HUGE databases like warez-bb..
MyIsam is for smaller ones.
 
jayfella said:
are you pinging new topics to a huge list of sites? iv read through the thread and its the only thing i can think of. it makes sense since it only occurs when new topics are posted.
Click to expand...


Tried leaving only pingomatic...
No change :(
PbzFo.png



mybe this help
1. Use cache plugin (supercache, w3, etc) tried, no difference
2. define('WP_POST_REVISIONS', false ); Edited that already, when I started blog
3. Optimize my.cnf, calculate using this program https://launchpad.net/mysql-tuning-primer you can see my.cnf
Click to expand...
 
Last edited:
You have no more chances than migrate your site to another VPS and check load.
Your site goes crazy ONLY when you post is weird. Mainly on new post action, INSERT and UPDATE queries are made.
How many visits do you have?
 
2000-3000 a day.
I already moved to another VPS.
No change.
As I said, there's more than one site, 3 of them have about equal amount of visitors and posts. If I turn off one with issues, other sites together don't make load over 1-1.5, when I post on them all together, it doesn't matter if I post or not, there's no load. Yes, I know it's weird. It's only one site, showing this symptoms.

---------- Post added at 11:43 PM ---------- Previous post was at 09:43 PM ----------

When everything fails, consider looking here:

http://www.prelovac.com/vladimir/wordpress-optimization-guide

FUCK YEAH, load 1 when posting, prelovac, you won 2 yrs rapidshare account.

UpGsd.png
 
Status
Not open for further replies.
Back
Top