Title: Database size increase
Last modified: August 22, 2016

---

# Database size increase

 *  [davefezz](https://wordpress.org/support/users/davefezz/)
 * (@davefezz)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/database-size-increase/)
 * Hi there,
    the database on one site we are using wordfence on is ever increasing
   due to entries made by wordfence (logging each update etc). The wp_options table
   has also grown since enabling wordfence. Any ideas on decreasing the database
   growth and still maintaining ideal security (free version). Thanks for any advice.
   Dave
 * [https://wordpress.org/plugins/wordfence/](https://wordpress.org/plugins/wordfence/)

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

 *  [WFBrian](https://wordpress.org/support/users/wfbrian/)
 * (@wfbrian)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/database-size-increase/#post-5836569)
 * Hey Dave,
 * You could try disabling Live Traffic and then see if the database growth decreases.
   You still get all the security benefits.
 * -brian
 *  Thread Starter [davefezz](https://wordpress.org/support/users/davefezz/)
 * (@davefezz)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/database-size-increase/#post-5836570)
 * Hi Brian,
    thanks for this suggestion – I have disabled a few more things, jsut
   ran a scan and will check on the db size. As shown on a few other posts. I tried
   the truncate table wp_wfHoover – Our host showed me this output and the wp_options.
   MYD and .MYI seems to large as does the … mysql mysql 171M Feb 24 22:26 wp_options.
   MYD … mysql 20M Feb 24 22:26 wp_options.MYI … mysql 14M Feb 24 22:26 wp_wfHits.
   ibd … mysql mysql 10M Feb 24 12:57 wp_wfFileMods.ibd … mysql mysql 9.0M Feb 24
   12:57 wp_wfConfig.ibd … mysql 9.0M Feb 24 22:26 wp_wfLeechers.ibd
 * Is it ok to empty the wp_wfHits, wp_wfFileMods and wp_wfLeechers tables? (oops
   already done this and wordfence still seems ok – scan works).
    I have Live Traffic
   disabled since the db growth was noticed (from less than 80MB pre-wordfence to
   211MB) – I have increased our quota to 300 but this is a little unusual for a
   standard wp using minimal avada + woocommerce.
 * Any advice is appreciated – I do intend to go to the pro version btw 🙂
    Regards,
   Dave
 *  [WFSupport](https://wordpress.org/support/users/wfsupport/)
 * (@wfsupport)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/database-size-increase/#post-5836786)
 * **wfHits** stores all the hits in Live Traffic. Disable Live Traffic before clearing
   this. This may be the reason for growth if you have lots of traffic while LT 
   is enabled. I usually leave it off unless I see server issues.
    **wfFileMods**
   stores a list of the file we find during a scan. This can be cleared but not 
   during a scan. **wp_wfLeechers** is used to track visits by crawlers, humans,
   etc and is used in rate limiting. This can be cleared.
 * I would recommend deactivating wordfence before performing these operations in
   the database.
 * Hope this helps.
 * tim

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

The topic ‘Database size increase’ 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 size](https://wordpress.org/support/topic-tag/database-size/)

 * 3 replies
 * 3 participants
 * Last reply from: [WFSupport](https://wordpress.org/support/users/wfsupport/)
 * Last activity: [11 years, 2 months ago](https://wordpress.org/support/topic/database-size-increase/#post-5836786)
 * Status: not resolved