Hi-load mysql server issue
I’m using wordpress, and having big troubles with my stability of server, i’m getting thousands hits to mysql, and this couldn’t handle my server, so i decided to grab all online content from index page and copy it somewhere else, now my users don’t access mysql with each loads of page.
so mysql requests dropped to about 5% from 100%
but sometimes those small requests can kill mysql and cancel connection, i have enabled loggin for longer mysql requests, and i can see there a lot of such requests:
SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’;
# Time: 050526 12:03:39
# User@Host: root[root] @ localhost 
# Query_time: 0 Lock_time: 0 Rows_sent: 255 Rows_examined: 255
Can you please tell me what i didn’t disable yet, and what that request is trying to do ? where i could disable this, and what php file is doing that.
- The topic ‘Hi-load mysql server issue’ is closed to new replies.