Forums

Host Disabled Site for Too Many MySQL Queries (6 posts)

  1. flashbuddy
    Member
    Posted 1 year ago #

    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

  2. esmi
    Theme Diva & Forum Moderator
    Posted 1 year ago #

    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.

  3. cubecolour
    ɹoʇɐɹǝpoɯ
    Posted 1 year ago #

    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

  4. flashbuddy
    Member
    Posted 1 year ago #

    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.

  5. Happeh
    Member
    Posted 1 year ago #

    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!

  6. flashbuddy
    Member
    Posted 1 year ago #

    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?

Topic Closed

This topic has been closed to new replies.

About this Topic