wfLeechers

The wfLeechers table is used to track hits for the rate-limiting features in the Firewall Rules. How many rows does the table have? If the table is excessively large, it probably means that the site has had visits from a lot of different IPs — it is safe to truncate it manually (deleting all records, but not the table itself) if necessary.

-Matt R

Over 72.000 rows in a week.
It’s insane that i’ve to truncate it manually… why don’t let us select a time range? ??

Yes, normally you shouldn’t have to truncate it manually, but I wanted to give you a quick fix, in case the table was huge (millions of rows), or growing extremely quickly.

I checked with our dev team, and old entries should be removed after two days. Can you check the database user, to be sure it has all privileges on the database tables? (This is sometimes an issue with various tables, most often if the site has changed hosts.)

72k is quite a lot of rows, but it might happen in a short amount of time if your site was under attack.

-Matt R

Hi,

My wf_leechers table is 38,000 rows.

My “How long is an IP address blocked when it breaks a rule:” setting is two days.

Are you saying that means that IPs in the wf_leechers table will rotate out in 2 days? In other words, my wf_leechers table is recording 19,000 ip numbers a day, and every time someone visits my website Wordfence has to look up their ip in a 38,000 row table?

If I set “How long…” to 5 minutes, will that mostly clear the table, immediately, or with some kind of mysterious time delay?

A bit more clarity on this would be appreciated. I did search these forums and examine WF documentation and got little to no enlightenment on how this all works, just a vague idea.

Thanks for any help. MTN

Bump, am still mystified by my WFleechers table, which now has 48,000 rows. The last time an IP was rate limited on my site was about 2 months ago, but Firewall blocking is set to 2 days. Not making much sense. Please, Matt, can you offer some kind of clarification? Thanks, MTN