WordPress.org

Support

Support » How-To and Troubleshooting » WP and Mysql overload

WP and Mysql overload

  • I have a wordpress site And for whatever reason the set up is accessing a TON of CPU usage on my server.The site seems to Pulling a lot of resources from the database and mysql, that make mysql go away

    Im on a strong dedicated server but the just keeps exhausting CPU resources and overloading. Forcing my server to crash all the site on the server 6 site (1 high trafic – 5000-to 13 000 unique day- and some low traffic microsite)

    I’m thinking there’s something wrong with the template or a script somewhere in the backend files like. Ive deleted unnecessary plugins and have try all Cache type plugins humanely available and nothing works including total cache, super cache, quick cache

    Need someone the database and find out what exactly is causing the high CPU usage?

    the site i have issue is

    Home

Viewing 11 replies - 1 through 11 (of 11 total)
  • 1. Can be ’caused by your plugins and/or theme (bad code, too much mysql query, etc)

    2. Number of visitors (use pageviews not unique visitors, due a unique visitor may open 3,5,10, or more page which result additional server usage).

    3. Have you try w3 total cache ? Can be used with memcached or opcode.

    What is your server configuration ? apache, litespeed, nginx, etc ?

    It will be easier if you talk with your host provider. Maybe you need load balancer or use multiple servers.

    Perhaps the problem is caused by timthumb.php which is known to cause all types of problems.

    ive between 6000 et 15 00 pageview a day.

    Ive upgrade timthumb with the vuenability scanner

    It’s not about security, but timthumb may kill your server even with multiple servers.

    Take a look at wordpress codex, “high traffic wordpress”. You need to optimize your system (host and wordpress ) first.

    It’s not about security, but timthumb may kill your server even with multiple servers.

    As SNSD news suggested, timthumb can cause serious problems. That is why I pointed to that first. However, you may check other possible problems too.

    The issue is pretty new, a few week, never got this issue before, even with timthumb. i’m using this theme for 1 year at least.

    For the fact, im not a newbie and i use wordpress for about 5 years now. The site is pretty well optimized and the server is dedicated one. But for about 2 week i get this oveload mysql issue.

    Each time im doing a post, the server crash 1 out of 4 post.

    right now i use quick cache and varnish is install on the server.

    my host jst contact me and send me this mail and tell me what the error is :

    The SSD drive is in place but we are still seeing issues with your database. I went ahead and did a full process list for you and attached that to this ticket. The issue is basically a large number of the same things running that look similar to this:

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
    INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id)
    INNER JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id) WHERE 1=1 AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘sympatico’, ‘gab_gallery’) AND (wp_posts.post_status = ‘publish’) AND (wp_postmeta.meta_key = ‘iframe’
    OR mt1.meta_key = ‘video’
    OR mt2.meta_key = ‘videoflv’ ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 8 |

    If you can figure out what is causing this issue, you will resolve all of your WordPress issues with this domain.

    up
    im ready to pay to gt this issue fixed

    Krishna

    @1nexus

    Member

    im ready to pay to gt this issue fixed

    To hire someone, please post at: http://jobs.wordpress.net/

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘WP and Mysql overload’ is closed to new replies.