Slow queries

Hi @gwcm, thanks for getting in touch.

Generally when we’ve seen issues with wfconfig, it can be down to an excessive number of rows. That isn’t particularly common though and I haven’t seen similar cases recently with wfls_settings that might point to a common reason why both tables would be affected together. Extra overhead could be down to temporary disk space that the database uses to run some queries.

You could try optimizing the table in phpmyadmin (or however you usually administer your database) to see if it removes them from the slow query log. This is good to keep an eye on to ensure everything continues to run smoothly and may improve efficiency if maintenance hasn’t been performed for a while.

If not, it could be worth seeing a copy of your PHP error log and diagnostic report to us. You can send that 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.

NOTE: It should look as follows – Screenshot of Tools > Diagnostic > Send by Email

Many thanks,
Peter.

Thanks. I’ve optimized the tables. Config has 305 rows and the settings table has 30, which doesn’t seem a lot to me. Is that normal? I’ve sent the diagnostics.

Thanks for sending that over @gwcm,

The tables sound like an acceptable size, the case I mentioned before had over 1000 rows when it clearly should have less. Would it be possible to also send your full database slow query logs over? You can use the same email address and include your forum username in the subject so I can find them.

As you have quite a high number of plugins installed, it’d be quite important for us to see whether Wordfence’s scans or other queries are affected by that, or if any other plugins (or WordPress itself) are also experiencing slow queries elsewhere. If they are, it could suggest less resources are available than required.

Thanks again,
Peter.