Too heavy database

Hi @patrickhaond, thanks for dropping us a message about this.

wfknownfilelist in particular should be truncated at the start of new scans. If you visit Wordfence > Tools > Diagnostics > MySQL, what is reported as the Database Version? You can also check your privileges to INSERT, UPDATE, TRUNCATE etc here. Do all of those report back as OK?

You could check the contents of that table, start a new scan, and see if you are noticing any change at all. Are you noticing your scans are starting and completing successfully?

Thanks,

Peter.

Thanks for your help @wfpeter .
My database version is 5.6.50-log and all my privileges are OK.
I tried my scans and it works fine.
Indeed when I start a new scan the size of the table __wffilemods is greatly improving about 4Mo in a couple of minutes.
So indeed I need clear it after each scan…

• This reply was modified 3 years, 9 months ago by Pat.

Hi @patrickhaond,

Thanks for your feedback on this. As the table is truncating before the scan as expected, and your permissions are reporting OK, there shouldn’t need to be any manual action required – although you are of course free to set up a maintenance schedule as you see fit.

Most of our customers, even on more limited shared hosting environments don’t seem to be reporting issues regarding the size of this table being a problem, so if this is causing issues in your case it might be worth speaking with your hosting provider’s support team to see if the resources available to you are limited – or perhaps it’s something that can be rectified.

Thanks again,

Peter.