Title: Database size issue
Last modified: February 26, 2024

---

# Database size issue

 *  [ad902374](https://wordpress.org/support/users/ad902374/)
 * (@ad902374)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/database-size-issue-3/)
 * Hello – Every few months I get the following issue where my WordFence DB grows
   in size to 1GB and i have to empty it via phpMyAdmin. This is now happening every
   few days. Is this a known issue and is there a resolution please? My webhost 
   is Site Ground, perhaps a conflict with SG Optimiser plug in
 * Database name: dbuitbqbwtee3k
   Table: yxf_wfhooverCurrent Usage: 1030MB

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

 *  Plugin Support [wfpeter](https://wordpress.org/support/users/wfpeter/)
 * (@wfpeter)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/database-size-issue-3/#post-17456150)
 * Hi
 * This issue is reasonably infrequent, but we do see issues mentioned often enough
   to suggest certain MySQL installations could be involved. In terms of the large`
   wfHoover` table example above, does it also have a high number of rows, or does
   it have 0 rows despite its size?
 * Just for some background information, the `wfHoover` table is used during a scan
   to temporarily store information about the scan to report back afterwards. It
   should be truncated at every scan.
 * If it’s stuck, it’s totally safe to empty it, but you might still need to check
   your database privileges to ensure Wordfence will be able to clean this as intended
   in future. On the **Wordfence > Tools > Diagnostics** page under “**MySQL Database
   version and privileges**“, you should be able to see whether your database has
   all the necessary permissions.
 * If you’re using MySQL or MariaDB, you should be able to `TRUNCATE` like this 
   example: [https://www.mysqltutorial.org/mysql-truncate-table/](https://www.mysqltutorial.org/mysql-truncate-table/)
 * In addition to the question above, let us know if permissions seem fine and truncating
   manually remains only a temporary solution.
 * Thanks,
   Peter.
 *  Thread Starter [ad902374](https://wordpress.org/support/users/ad902374/)
 * (@ad902374)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/database-size-issue-3/#post-17458473)
 * Thank you for the reply. I manually emptied the file yesterday so will monitor
   and review your comments next time it grows again, I suspect this will be over
   the next few days.
 *  Thread Starter [ad902374](https://wordpress.org/support/users/ad902374/)
 * (@ad902374)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/database-size-issue-3/#post-17470447)
 * Hello – this has just increased in size again to 1GB, To answer your questions.
    1. It has 5,212,616 rows.
    2. Yes it has the necessary permissions, I checked this as you advised.
    3. I can manually empty/truncate but trying to have to avoid this.
 *  Thread Starter [ad902374](https://wordpress.org/support/users/ad902374/)
 * (@ad902374)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/database-size-issue-3/#post-17504631)
 * This keeps happening is there a solution please?

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

The topic ‘Database size issue’ 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
 * 2 participants
 * Last reply from: [ad902374](https://wordpress.org/support/users/ad902374/)
 * Last activity: [2 years, 2 months ago](https://wordpress.org/support/topic/database-size-issue-3/#post-17504631)
 * Status: not resolved