Duplicate Query Performance Issues

Resolved

(@coldxot)

Hello,

We are experiencing performance issues with extensive duplicate quieries being caused by WordFence.

While I understand WordFence can be demanding resource-wise for the trade off of a lot of functionality, it seems these extra calls are frequently affecting our server’s performance.

Do you have any adivce to deal with them?

Calls:

-- 3 duplicate calls
SELECT name, val, autoload
FROM wp_wfconfig
WHERE name = 'detectProxyRecommendation';

-- 2 duplicate calls
SELECT val
FROM wp_wfconfig
WHERE name = 'wordfence_chunked_adminNoticeQueue_header';

-- 2 duplicate calls
SELECT val
FROM wp_wfconfig
WHERE name = 'adminNoticeQueue';

-- 2 duplicate calls
SELECT *
FROM wp_wfnotifications
WHERE new = 1
AND ctime > 0
ORDER BY priority ASC, ctime DESC;

-- 8 duplicate calls
SELECT name, val, autoload
FROM wp_wfconfig
WHERE name = 'onboardingAttempt3';

-- 4 duplicate calls
SELECT name, val, autoload
FROM wp_wfconfig
WHERE name = 'onboardingAttempt2';

Viewing 1 replies (of 1 total)

Plugin Support wfpeter
(@wfpeter)

1 year ago

Hi @coldxot, thanks for providing the information above.

Wordfence can be demanding during scans on servers with fewer available resources, or an extremely large amount of files/plugins. However, these duplicates shouldn’t cause a noticeable performance hit. The tool identifying the queries possibly has a “time” column for how long those queries are taking that hasn’t been included? They should collectively just take a few milliseconds as duplicated queries don’t necessarily mean slow queries, so feel free to show us that information if you have it.

The specific columns and values being requested above should only happen on /wp-admin pages for admin users, so it’s unlikely these are the cause of larger server performance issues as not all visitors to your site will be causing them.

If the whole site is slow, and not just wp-admin pages, then it’s likely to be something else that would need more investigation. Naturally if anything from your MySQL slow query log points to Wordfence tables, or your server’s error log is showing regular timeouts or fatal errors on Wordfence files we’d be happy to assist further in that investigation.

Thanks,
Peter.

Viewing 1 replies (of 1 total)

The topic ‘Duplicate Query Performance Issues’ is closed to new replies.