• Resolved mountainguy2

    (@mountainguy2)


    Hi Wordfence,

    I don’t use Rate Limiting (it doesn’t work for me), my WP_wfleechers table has 29,000 rows and it’s only mid-month. My understanding is that wfleechers is used for rate limiting? 29,000 rows is a bit much and is slowing down my site load time. I don’t want to add a manual truncate to my endless to-do list. Any solutions? Is there a way to disable wf_leechers, or set it to store fewer rows?

    Thanks, MTN

    https://www.ads-software.com/plugins/wordfence/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Hi MTN,
    I want to confirm that wp_wfLeechers contains all the data used for “Rate Limiting Rules”, this is necessary to track the frequency which IP’s are hitting a site.

    All the data in this table are collected whether you are using “Rate Limiting Rules” or not, knowing that this table has only a few columns and the old entries are deleted periodically, this generally can’t cause any slowness to your website.

    Currently, there is no option to disable collecting data in “wp_wfLeechers”, but it’s safe to manually truncate this table if you aren’t using “Rate Limiting Rules”.

    Last thing to mention is that having a table with these few columns and
    29,000 rows can’t cause this slowness to your website loading, specially when you aren’t using “Rate Limiting Rules”, so no queries are executed involving this table.

    Thanks.

    Thread Starter mountainguy2

    (@mountainguy2)

    Thanks wfalaa, the fact that no queries are executed is getting there in clarity.

    By “Rate Limiting Rules” do you mean “Block” and “Throttle?”

    Or, do you refer only to “Throttle” ?

    I have all the “Rate Limiting Rules” set to “Block.” Does having it set up that way query wp_wfleechers?

    FYI, my wp_wfleechers is now 34,000 rows.

    Thanks, MTN

    Hi MTN,
    Actually, setting any of the “Rate Limiting Rules” to “Unlimited” means “Disabled”, it doesn’t matter if you choose “throttle it” or “block it”, as long as you have it “Unlimited”.

    Any other rate chosen other than “Unlimited” means “Enabled” and it will utilize these data in that table regardless you chose “throttle it” or “block it”.

    I hope you find that useful.
    Thanks.

    Thread Starter mountainguy2

    (@mountainguy2)

    Thanks, that now very clear. Suggest you change “Unlimited” in the settings to say something like “Unlimited-Disabled” and clarify in your documentation. MTN

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WP_wfleechers, the eternal mystery of Wordfence’ is closed to new replies.