Persistent Issue with Yoast SEO Causing MySQL Process Freezing

Hello to the entire Yoast SEO team,

I apologize for reaching out again, but I have an unresolved issue that has been persisting for months. I previously addressed this problem in a post, which unfortunately got closed due to inactivity. You can find the post here: https://www.ads-software.com/support/topic/yoast-seo-mysql-process-freezing-when-i-go-to-an-admin-page/

Allow me to provide a summary of the situation:

MY PROBLEM:

Every time I access the admin section of my website (/wp-admin/), Yoast SEO triggers a MySQL query that blocks the loading of admin pages on my site. The issue is so severe that it can even cause my MySQL server to crash.

The only immediate solution to restore the functionality of my site is to go to phpMyAdmin => Status => Processes => Kill this process (via WHM, not cPanel).

Here is the blocking MySQL query:

SELECT P.ID FROM wp_posts AS P WHERE P.post_type IN ('post', 'page', 'attachment', 'wpi_invoice', 'gd_producteur', 'gd_artisan', 'gd_place', 'gd_evenement', 'gd_event', 'product') AND P.post_status NOT IN ('auto-draft') AND P.ID not in ( SELECT I.object_id from wp_yoast_indexable as I WHERE I.object_type = 'post' AND I.version = 2 ) LIMIT 26

So, if I manually kill this blocked MySQL query from the processes, my site immediately starts functioning again, and subsequent WordPress queries execute normally. The problem is resolved only if I disable the Yoast SEO plugin.

YOUR REPLY:

In the aforementioned (closed) post that I posted a few months ago, you suggested installing the “Yoast Test Helper” plugin and using the following tools:

• Reset indexable tables & migrations
• Reset Prominent words calculation
• Reset Internal link counter

Finally, you requested me to navigate to: Yoast SEO > Tools, and under SEO data, click the “Start SEO data optimization” option.
I followed these steps, but it had no effect whatsoever.

With all plugins disabled same issue!

Please note that I have also attempted to disable all plugins, but the issue still persists. Since the problem is resolved when Yoast is deactivated, my hosting provider refuses to assist me. When I presented the problem to them, they stated that they do not handle issues related to CMS or plugin bugs.

My MySQL Server is Completely Unstable!

My database is valuable, and I sincerely hope that the “wp_yoast_indexable” table has not caused any damage. In my 15 years of using WordPress, I have never encountered such a severe bug caused by a WordPress plugin, to the extent of destabilizing my MySQL server. There was even an instance where this bug caused the MySQL server on my dedicated server to crash, affecting the databases of ALL the sites on the server!

My Hosting provider denies responsibility for third-party CMS/Plugins

Additionally, my hosting provider is unwilling to assist me, as they state that they do not handle issues related to CMS or plugin bugs after reviewing the problem.

I would greatly appreciate any further assistance you can provide to help resolve this persistent issue. Thank you in advance for your attention and support.

Best regards,
Brigitte G.