WordPress.org

Ready to get started?Download WordPress

Forums

WP and Mysql overload (12 posts)

  1. jeffqc
    Member
    Posted 2 years ago #

    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
    http://www.tvqc.com/

  2. SNSD Photo
    Member
    Posted 2 years ago #

    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.

  3. Krishna
    Volunteer Moderator
    Posted 2 years ago #

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

  4. jeffqc
    Member
    Posted 2 years ago #

    ive between 6000 et 15 00 pageview a day.

  5. jeffqc
    Member
    Posted 2 years ago #

    Ive upgrade timthumb with the vuenability scanner

  6. SNSD Photo
    Member
    Posted 2 years ago #

    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.

  7. Krishna
    Volunteer Moderator
    Posted 2 years ago #

    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.

  8. jeffqc
    Member
    Posted 2 years ago #

    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.

  9. jeffqc
    Member
    Posted 2 years ago #

    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.

  10. jeffqc
    Member
    Posted 2 years ago #

    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.

  11. jeffqc
    Member
    Posted 2 years ago #

    up
    im ready to pay to gt this issue fixed

  12. Krishna
    Volunteer Moderator
    Posted 2 years ago #

    im ready to pay to gt this issue fixed

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

Topic Closed

This topic has been closed to new replies.

About this Topic