Title: Gigantic Database
Last modified: August 24, 2016

---

# Gigantic Database

 *  [andrewcharon](https://wordpress.org/support/users/andrewcharon/)
 * (@andrewcharon)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/gigantic-database/)
 * I’ve been evaluating WordPress for security purposes on a site that gets a significant
   amount of traffic. Six months after implementation, the result is a 1 GB+ database
   of logs of every single activity that happened on the site, which was unanticipated.
 * The fix is to disable logging, which is easy, but I’m still left with a 1 GB+
   database with info that we don’t need. Is there a simple way of cleaning up that
   database within the functionality of WordFence (not within DB)?
 * Thank you!
 * Andrew
 * [https://wordpress.org/plugins/wordfence/](https://wordpress.org/plugins/wordfence/)

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

 *  [WFSupport](https://wordpress.org/support/users/wfsupport/)
 * (@wfsupport)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/gigantic-database/#post-6026829)
 * What tables are filling up?
 * tim
 *  Thread Starter [andrewcharon](https://wordpress.org/support/users/andrewcharon/)
 * (@andrewcharon)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/gigantic-database/#post-6026831)
 * The largest tables are:
    wp_wfHits wp_wfLeechers
 * These are significant but a bit smaller:
    wp_wfScanners wp_wfStatus
 *  Thread Starter [andrewcharon](https://wordpress.org/support/users/andrewcharon/)
 * (@andrewcharon)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/gigantic-database/#post-6027042)
 * Within your plug-in, is there a way to minimize/customize quantity of data going
   into table wp_wfHits and wp_wfLeechers?
 *  [davefezz](https://wordpress.org/support/users/davefezz/)
 * (@davefezz)
 * [11 years ago](https://wordpress.org/support/topic/gigantic-database/#post-6027110)
 * Hi there,
    any update on this – as since enabling wordfence my database grows
   and grows. I remove transients and revisions but the database continues to grow.
   I am considering WP-Optimize for this. Any advice is appreciated. Regards, Davef

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

The topic ‘Gigantic Database’ 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/)

 * 4 replies
 * 3 participants
 * Last reply from: [davefezz](https://wordpress.org/support/users/davefezz/)
 * Last activity: [11 years ago](https://wordpress.org/support/topic/gigantic-database/#post-6027110)
 * Status: not resolved