Host Disabled Site for Too Many MySQL Queries

  • My site went dark with a 403 Forbidden error. Found my public_html directory permissions set to 0.

    Need counseling and advice on this.

    Host explains:

    we just were writing a ticket to you regarding this account, it critically overloaded the server, there were a lot of php processes serving this account and a lot of mysql queries like these:

    View Paste Bin

Viewing 5 replies - 1 through 5 (of 5 total)

  • Have you tried:

    – deactivating all plugins to see if this resolves the problem. If this works, re-activate the plugins one by one until you find the problematic plugin(s).

    – switching to the Twenty Ten theme to rule out any theme-specific problems.

    – resetting the plugins folder by FTP or PhpMyAdmin. Sometimes, an apparently inactive plugin can still cause problems.

    Moderator cubecolour

    (@numeeja)

    Time to go with a hosting company who will discuss problems & work with you to find a solution rather than pulling the rug away from under your feet. Which company is it?

    Do you have a full file & database backup?

    I always have a snippet of code in my footer which displays the number of queries if I am logged-in:

    <?php if (is_user_logged_in()) { ?>
 | <?php echo get_num_queries(); ?> queries |
<?php timer_stop(1); ?> seconds
<?php } ?>

    This is good for troubleshooting; I once briefly tried a plugging which I was able to see generated an extra 200 queries on each page load

    Running a copy of the site locally on xammp will enable you to troubleshoot excessive queries without upsetting a hosting company

    Thread Starter Flash Buddy

    (@flashbuddy)

    Argh! Added one new page with one image and my host disabled my site again. WTF! Their solution is to move it to a dedicated server. With over forty WordPress sites being hosted; I’ve never run into this.

    They are a no good host. I had one like that too. No tech support. Happy to move you to a more expensive server.

    If you install the DB-cache reloaded plugin, it will write a message to the page source saying how many SQL queries were made by the post and how many the plugin cached. The numbers can be a real eye opener.

    The front page for my site makes 88 SQL queries!

    Thread Starter Flash Buddy

    (@flashbuddy)

    I’ve emailed the host and asked them to cut me some slack so I can try disabling theme, plugins, widgets and then re-add one by one while outputing queries to the browser.

    Looking at HostGater now, have I lost my mind?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Host Disabled Site for Too Many MySQL Queries’ is closed to new replies.