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?
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 http://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