mySQL process freezing

  • Resolved salvia49

    (@salvia49)


    2 years, 3 months ago

    Hello,

    Please, I need know how resolve this bug please.

    Every time I access /wp-admin/, Yoast SEO spawns this mySQL process:

    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

    From there, my whole website becomes inaccessible (infinite loading), as long as I don’t kill this process from phpMyAdmin.

    As soon as this process is killed, all my site becomes accessible again, except if I load a page in WP admin, then in this case the site becomes inaccessible again.

    Everything is resolved when I deactivate the Yoast SEO plugin.

    Please note that I have also attempted a database optimization via: Yoast SEO => Tools, and that does not resolve this issue.

    Please help…

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hey @salvia49,

    Thank you for using Yoast SEO and for reaching out!

    Hmm, I’m not directly familiar with this specific query. Is it queried specifically on a page on /wp-admin/ like your Dashboard? Or on a post overview, plugin page, or settings page?

    I opened a few pages in the dashboard and checked with the plugin Query Monitor if I could reproduce or find where the query runs, but I can’t seem to find it. Some more information would help us investigate.

    Apart from the info, can you also let us know what versions of plugins, themes and WordPress is running? A site information export from the Site Health (Tools > Site Health > Info) would help us understand your site better as well.

    Plugin Support Maybellyne

    (@maybellyne)

    This thread was marked resolved due to a lack of activity, but you’re always welcome to re-open the topic. Please read this post before opening a new request.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘mySQL process freezing’ is closed to new replies.