How to Keep Wordfence Plugin Database Usage Low

Wordfence is a security plugin that can help protect your site. The database tables that the Wordfence plugin uses should be checked for size as part of regular maintenance checks on the site’s database.

Wordfence plugin uses many database tables, which were covered before in this article.

Below is the Wordfence database table to regularly check for the size;

wp_wfHoover

You can use a plugin such as WP-Optimize to check the database size. With the plugin installed and active in wp-admin, go to;

WP-Optimize > Database > Tables

Search using the name wfhoover and the WP-Optimize plugin will show you the data size, index size, and the number of records stored in that database table.

Many hosts provide the phpMyAdmin application, which can search for that specific database table, or you can sort tables by size. Ideally, the database table should be under 200 MB. There have been reports of that database table being up to 2.7 GB.

If you notice that the wfHoover database table is large, it can be emptied since it is a temporary storage table used while scanning for malicious URLs and data on the site.

Checking on Wordfence plugin database usage will help keep your site’s database size down and stop any unexpected higher database usage surprises from happening.

Useful Links

• https://wordpress.org/plugins/wordfence/
• https://wordpress.org/support/topic/wp_wfhoover-too-big/
• https://www.wordfence.com/help/advanced/remove-or-reset/
• https://mainwp.com/how-to-remove-all-wordfence-plugin-created-data/