Title: Database Issues?
Last modified: August 30, 2016

---

# Database Issues?

 *  Resolved [bkeller83](https://wordpress.org/support/users/bkeller83/)
 * (@bkeller83)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/database-issues-11/)
 * 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://wordpress.org/plugins/wordfence/](https://wordpress.org/plugins/wordfence/)

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

 *  [WFSupport](https://wordpress.org/support/users/wfsupport/)
 * (@wfsupport)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/database-issues-11/#post-6234889)
 * 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](https://wordpress.org/support/users/bkeller83/)
 * (@bkeller83)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/database-issues-11/#post-6234969)
 * 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.

 * ![](https://ps.w.org/wordfence/assets/icon.svg?rev=2070865)
 * [Wordfence Security - Firewall, Malware Scan, and Login Security](https://wordpress.org/plugins/wordfence/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordfence/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordfence/)
 * [Active Topics](https://wordpress.org/support/plugin/wordfence/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordfence/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordfence/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)

 * 2 replies
 * 2 participants
 * Last reply from: [bkeller83](https://wordpress.org/support/users/bkeller83/)
 * Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/database-issues-11/#post-6234969)
 * Status: resolved