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/
In addition to the question above, let us know if permissions seem fine and truncating manually remains only a temporary solution.
Thanks,
Peter.
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.
Hello – this has just increased in size again to 1GB, To answer your questions.
- It has 5,212,616 rows.
- Yes it has the necessary permissions, I checked this as you advised.
- I can manually empty/truncate but trying to have to avoid this.
This keeps happening is there a solution please?
