Database Issues?

  • Resolved bkeller83

    (@bkeller83)


    9 years, 9 months ago

    I don’t know for sure if this is a wordfence issue, but I’m getting database errors “exceeded the max_questions resource” on a site. I know what this error means, just have not been able to nail down the cause.
    I’ve checked raw access logs and it does not appear to be coming from external traffic. Server error logs shows a lot of the following:

    20150615T200215: www.MYSITE.net/index.php
WordPress database error User 'DB_USERNAME' has exceeded the 'max_questions' resource (current value: 75000) for query insert into wp_wfLeechers (eMin, IP, hits) values (floor(unix_timestamp() / 60), '??”?ì§', 1) ON DUPLICATE KEY update hits = IF(@wfcurrenthits := hits + 1, hits + 1, hits + 1) made by wfDB::queryWrite
WordPress database error User 'DB_USERNAME' has exceeded the 'max_questions' resource (current value: 75000) for query insert into wp_wfHits (ctime, is404, isGoogle

    There are about 20 of those entries over a period of a couple minutes. This site does not get enough external visits to exceed 75,000 database queries in an hour. I am thinking it’s a plugin that is going crazy, and with most of the errors related to wordfence, am wondering if this is causing it.

    This site owner really loves wordfence, so I would rather not uninstall if I don’t have to.

    Any ideas??

    https://www.ads-software.com/plugins/wordfence/

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

  • wfLeechers is used for all rate limiting (allowed hits per minute globally, for crawlers, humans, etc) to track the frequency which IP’s are hitting a site.
    wfHits stores all hits visible in Live Traffic views.

    I wonder if you turn off live traffic if that might solve the issue. If you have low traffic I wouldn’t think these would be a problem. You might tighten up your firewall rules for crawlers if those seems to be hitting you frequently. The thing is that WF might have just been the straw that broke the camel’s back in this case and that’s why you see the alert. You might ask the hosting provider to get the top ten things sending queries and work your way from there.

    tim

    Thread Starter bkeller83

    (@bkeller83)

    Thanks for the quick response!
    I went ahead and disabled live traffic, and tightened up the firewall rules. I’ll keep an eye on it and see if other issues pop up if this problem persists.

    I tried to enlist the host’s support first – their only recommendations were to ‘optimize my database queries’ and increase additional max_questions limits for $20/month.

    Thank you!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database Issues?’ is closed to new replies.

Tags