This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.
Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| - | 10:00 – 13:00 | 10:00 – 13:00 | 10:00 – 13:00 | 10:00 – 13:00 | 10:00 – 13:00 | - |
| - | 14:00 – 18:00 | 14:00 – 18:00 | 14:00 – 18:00 | 14:00 – 18:00 | 14:00 – 18:00 | - |
Supporter timezone: Asia/Kolkata (GMT+05:30)
Hi support team,
This site has been using Toolset since its creation, at least 7 years and it's been working fine.
From time to time, we have Bots attack and the site is down.
Today, almost 4,500 slow errors were logged within a two hour time span calling out this plugin, causing database CPU to spike and the site to go down.
The site is hosted via Flywheel and the Flywheel support has found this error in the log.
Message from Flywheel support :
It appears the wp-views plugin is throwing thousands of slow errors per hour, all dealing with MySQL queries. These quieries are dealing with the _posts table and are similar to the one below :
SELECT id FROM wp_fb82uskzk4_posts
WHERE `post_type` = 'attachment'
AND `guid` IN ( 'hidden link', 'hidden link', 'hidden link', 'hidden link' )
ORDER BY CHAR_LENGTH( `guid` ) DESC
Could you please help analysing the log file here : hidden link ?
Maybe I need to optimise my queries with View.
Thank you in advance for your help.
Best regards,
Sawitri
