The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

VPS high load

Discussion in 'General Discussion' started by jazz1611, Jul 30, 2013.

  1. jazz1611

    jazz1611 Well-Known Member

    Joined:
    Jun 5, 2012
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hi,

    I am provider Hosting. I get error when website of customer have 500 current connection (500 online or more).

    First error: 500 Internal Server Error
    continue to Second error: 508 Resource Limit Is Reached

    My VPS specifications:
    10vCPU (12Ghz) Intel(R) Xeon(R) CPU L5640 @ 2.27GHz
    6GB RAM
    CloudLinux 6

    I checked see:
    Server load 5.56 (10 CPUs) alert!

    Then website of my customer error.

    P/s: But website of other customer on same VPS loading normal.

    Ex: domainA.com (123.123.1.1) have 500 online or more - get error.
    Ex: domainB.com (123.123.1.1) other customer have 800 online or more - still normal loading.

    Regards,

    I from Vietnam then i speak English not well. Hope you understand.

    ---------------------------------------------------------------------------------------

    Error logs of website when 500 online or more:
    Code:
    [30-Jul-2013 15:09:13 UTC] WordPress database error MySQL server has gone away for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY RAND() DESC LIMIT 0, 8 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/mobiletheme/index.php'), WP_Query->__construct, WP_Query->query, WP_Query->get_posts
    [30-Jul-2013 15:09:31 UTC] WordPress database error MySQL server has gone away for query SELECT DISTINCT ID,post_title,post_date,post_content,MATCH(post_title,post_content) AGAINST ('Yêu nhầm chị hai… được nhầm em gái [Full]') AS score FROM wp_posts WHERE MATCH (post_title,post_content) AGAINST ('Yêu nhầm chị hai… được nhầm em gái [Full]') AND post_date <= '2013-07-30 22:09:31' AND post_status = 'publish' AND id != 9 AND post_type = 'post' ORDER BY score DESC  made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/mobiletheme/single.php'), the_content, apply_filters('the_content'), call_user_func_array, ald_crp_content, ald_crp
    [30-Jul-2013 15:09:31 UTC] WordPress database error MySQL server has gone away for query 
    					SELECT term_taxonomy_id
    					FROM wp_term_taxonomy
    					WHERE taxonomy = 'category'
    					AND term_id IN (1)
    				 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/mobiletheme/single.php'), WP_Query->__construct, WP_Query->query, WP_Query->get_posts, WP_Tax_Query->get_sql, WP_Tax_Query->clean_query, WP_Tax_Query->transform_query
    [30-Jul-2013 15:09:32 UTC] WordPress database error MySQL server has gone away for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE 1=1  AND wp_posts.ID NOT IN (9) AND 0 = 1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 12 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/mobiletheme/single.php'), WP_Query->__construct, WP_Query->query, WP_Query->get_posts
    [30-Jul-2013 15:09:38 UTC] WordPress database error MySQL server has gone away for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY RAND() DESC LIMIT 0, 8 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/mobiletheme/index.php'), WP_Query->__construct, WP_Query->query, WP_Query->get_posts
    [30-Jul-2013 15:15:47 UTC] WordPress database error MySQL server has gone away for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY RAND() DESC LIMIT 0, 8 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/mobiletheme/index.php'), WP_Query->__construct, WP_Query->query, WP_Query->get_posts
    [30-Jul-2013 15:23:26 UTC] WordPress database error MySQL server has gone away for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY RAND() DESC LIMIT 0, 8 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/mobiletheme/index.php'), WP_Query->__construct, WP_Query->query, WP_Query->get_posts
    
     
    #1 jazz1611, Jul 30, 2013
    Last edited: Jul 30, 2013
  2. jazz1611

    jazz1611 Well-Known Member

    Joined:
    Jun 5, 2012
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hi,

    I checked on hosting this website have error. See alway CPU load high.

    CPU Usage 80 / 100 % on table Stats (cPanel)

    Ảnh chụp màn hình_2013-07-31_230049.png

    3 week ago. Website have 800 online or more still normal. But now just 500 online or more will get error 500 then to 508.

    I really dont know why that? Can give me suggest about that?

    Regards,
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Could you let us know the specific 500 error message that appears in the /usr/local/apache/logs/error_log file? Also, it looks like you are using Cloud Linux, and the account is reaching it's resource usage threshold. Have you considered increasing the Cloud Linux resource limit for this account?

    Thank you.
     
  4. jazz1611

    jazz1611 Well-Known Member

    Joined:
    Jun 5, 2012
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Yes, i increase the Cloud Linux resource limit for this account. Now all website running on same server get error 508 too. It just make server loading to high.

    Can i open ticket for us check it?
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Per the Cloud Linux documentation:

    Each LVE limits amount of entry processes (Apache processes entering into LVE) to prevent single site exhausting all Apache processes. If the limit is reached -- mod_hostinglimits will not be able to place Apache process into LVE, and will return error code 508. This way very heavy site would slow down and start returning 508 errors, without affecting other users.

    The full document is available at:

    Understanding LVE

    Have you tried disabling the limits completely? You may want to consult with a qualified system administrator to troubleshoot the load issue on your system. You can find a list of third-party system administration companies at:

    cPanel Application Catalog - SysAdmin Services

    Thank you.
     
Loading...

Share This Page