WordPress database error: exceeded the ‘max_questions resource”

  • When I looked at my blog this morning, https://www.eoecho.com/allthingsmercedes/ I found the following error:

    WordPress database error: [User has exceeded the ‘max_questions’ resource (current value: 50000)]
    SELECT * FROM wp_users WHERE user_login = ‘admin’

    I searched WP for discussions, but can’t find anything that appears to work to fix the problem. Anybody know how to correct this by any chance?

    Any help you can provide is appreciated. Thanks!

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter optimisticfriend

    (@optimisticfriend)

    Fixed! I called my hosting company and they restarted the server, which apparently is the way to resolve this issue. Tech support said to check the “access log” for IP addresses that may be hitting the site way too frequently. Then, limit access for that IP address. It could be a problem if the IP is a search engine.

    So.. can the status of this thread be changed to [Resolved] then, or..?

    spencerp

    Hi folks – I know this is an old topic, but it is happening to me right now and I can get my isp to reset, but then it happens again and causes lots of trouble. I have been told that my current limit of 50000 needs to go up, or that I need to optimize my sql queries.

    Does anyone else have input on this?

    Moderator Samuel Wood (Otto)

    (@otto42)

    www.ads-software.com Admin

    Some hosts put a limit on the maximum number of SQL Queries you can make per hour. Depending on your particular blog setup, WordPress makes between 10-30 queries every time anybody hits the website.

    Solution: If you get a lot of traffic, get a better host that doesn’t have that sort of problem.

    Temporary solution: Use a caching plugin, like WP-Cache. WP-Cache will make a file copy of a page and serve that up instead of the original page (refreshing it every so often). This not only speeds up your site a lot, but hits to the cached pages make no SQL queries or database hits whatsoever.

    I’m still facing that problem every day, whenever i try to post, after 3-5 post this error comes up on https://www.freedownloadinfo.org

    WordPress database error: [User ‘freedown_info’ has exceeded the ‘max_questions’ resource (current value: 50000)]
    SELECT * FROM wp_categories WHERE cat_ID = ’54’ LIMIT 1

    WordPress database error: [User ‘freedown_info’ has exceeded the ‘max_questions’ resource (current value: 50000)]
    SELECT option_value FROM wp_options WHERE option_name = ‘rewrite_rules’ LIMIT 1

    and it stayed for a while(5-10 mins) and than automatically be corrected
    Any help will be appreciated, Have tried server restart and using cache plugin but still facing this error..
    Thanks..
    Anxiously waiting any help

    Duplicate question from networkingnanzia.

    See:
    https://www.ads-software.com/support/topic/123237?replies=1

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘WordPress database error: exceeded the ‘max_questions resource”’ is closed to new replies.