How to reduce WordFence queries

  • Resolved jgatsi

    (@jgatsi)


    4 years, 3 months ago

    We’re looking for some tips on how to optimize WordFence query load.

    Currently, we have a couple of 100 sites on our servers all running the free version. We’re finding that each site is generating large volumes of queries.

    What tips do you have to reduce the load of queries we’re getting? At this point, our system admins are considering server-side protection over using WordFence. I would like to continue to use WordFence but we need a solution to reduce the query load.

    Thoughts or suggestions?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support WFAdam

    (@wfadam)

    Hello @jgatsi and thanks for reaching out to us!

    Can you send a diagnostic report from one of your sites to wftest @ wordfence . com? You can find the link to do so at the top of the Wordfence Tools > Diagnostics page. Then click on “Send Report by Email”. Please add your forum username where indicated and respond here after you have sent it.

    Do all the sites run similar set ups?

    Thanks!

    Thread Starter jgatsi

    (@jgatsi)

    Hi @wfadam thank yo for responding.

    I have sent a diagnostic report. Yes, all our sites have a similar setup. Let me know if you need any other info.

    Best,

    James

    Plugin Support WFAdam

    (@wfadam)

    Thanks for sending that diagnostic @jgatsi

    I see a few things we will want to correct. Not sure if they are directly related to your query issue but I want to make sure the setup is correct first.

    It looks like your firewall is not optimized on this site. auto_prepend_file is not set currently.

    It says your Server API is FPM/FastCGI and the default configuration for FastCGI should have worked. However, on some sites with PHP FPM we do sometimes see situations where the settings are being overridden. This is from our documentation:

    In rare cases, when a host uses PHP-FPM, they may have PHP settings defined in a “pool” file. These settings can override options set in your custom php.ini or .user.ini file. You may need to ask the host if they have settings in the pool file. The default location for the pool file on new Ubuntu servers is similar to /etc/php/7.0/fpm/pool.d/www.conf (depending on the PHP version) and an example of an option that would override your auto_prepend_file option is php_admin_value[auto_prepend_file] = none. If the host is able to remove this option, it should allow your settings to be used for the firewall.

    So I would at this point recommend that you reach out to your host and ask them this:

    I need to set a PHP value auto_prepend_file on my site but it doesn’t seem to be taking effect. Can you explain how to set auto_prepend_file on my site?

    Hopefully, they’ll be able to give you an idea of why it’s not working. If you have any questions, let me know! Let’s start there and move up the ladder.

    Thanks!

    Thread Starter jgatsi

    (@jgatsi)

    Awesome! Thanks Adam. I’ll talk to my SYS admin. I’ll reply here if I have any further questions.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘How to reduce WordFence queries’ is closed to new replies.