• My website: https://lis.uncg.edu

    Bluehost sent me a message that says, “It looks like the site on our server at least is being throttled for taking up too much CPU.” The message goes on to say that:

    Throttling or Suspensions are usually caused by:
    * Queries that return inordinately large dataset results (eg: 100,000
    records) in the Response object of a round trip to the server.
    * Queries that take too long to execute due to heavy aggregation
    commands like SUM, COUNT over very large datasets without proper
    indexing.
    * Queries that are doing complex unoptimized nested Joins.
    * Queries that execute large batch commands like INSERTS, UPDATES, OR
    DELETES – these types of sql calls are 10 times more expensive and
    resource intensive than the SELECT query command.
    * Poorly coded Php scripts such as multiple nested loops, or infinite
    loops.
    * Themes, Addons, or Plugins (if you just added a new component to your
    script, you may want to remove it to see if that new component caused
    your site to suddenly perform slowly)
    * DDoS Attacks
    * Any process that uses too much RAM, like a rogue cron job
    * Too many simultaneous connections like Downloads, FTP, IMAP, or PHP

    I’ve checked out today’s query log and found the following:

    #Query_time: 1.042531 Lock_time: 0.000093 Rows_sent: 9 Rows_examined: 152
    SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') AND ( ID <> 3288 AND ID <> 3166 AND ID <> 3282 ) AND post_parent = 0 ORDER BY menu_order ASC

    Another query is listed with a query time of 1.888361 with very similar information. I have no idea what this means. Help?

Viewing 4 replies - 1 through 4 (of 4 total)
  • I’ve had the same issues. I think it still happens but not as bad. Check the query logs just like the one you posted and see if a plugin is responsible for the queries.

    If it will not break your site, disable the plugin and watch the trottle graphs from your cPanel.

    That should give you a very good clue what’s going on.

    Thread Starter Godaisies

    (@godaisies)

    I’ll be doing some massive revision work on the website in December when it is not needed to be in service. My boss was asking me about the site’s slowness today. When I checked the records, it looks like they decided to start the throttling when school came back into session.

    Thanks!

    The following suggestions should help a great deal: https://wordpress.shadowlantern.com/2009/01/reducing-cpu/

    Thread Starter Godaisies

    (@godaisies)

    Thanks. I’ve deactivated all the plugins on the mirror site and am testing there first.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Bluehost has throttled my site. Need advice ASAP!’ is closed to new replies.