An SQL query leading to server slow down

Hello! We’ve been experiencing massive slowdowns on all our sites located on the same server (we’ve the plugin installed on multiple sites). For over a week our sites take over a minute to load from time to time for hours. We removed multiple plugins installed recently and then it happened again, then a tech support engineer at our hosting provider told us that we’ve been constantly getting the following query in our database from multiple sites:

DELETE
               a,
               b
           FROM
               wp_options a
               INNER JOIN wp_options b
                   ON b.option_name = CONCAT( ‘_transient_timeout_’, SUBSTRING( a.option_name, 12 ) )
                   AND b.option_value < 1695297566
           WHERE
               a.option_name LIKE ‘\_transient\_tribe\_%’
               AND a.option_name NOT LIKE ‘\_transient\_timeout\_tribe\_%’ | 0.000    |

Seeing “tribe” leads me to this forum. Could you support me on this, please, maybe there’s a fix for it?

In logs, that we’ve been sent by the hosting provider representative, numbers in line differ.

  AND b.option_value <