Support » Plugin: Yoast SEO » re-indexing stuck on mysql query causing 100% cpu load

re-indexing stuck on mysql query causing 100% cpu load

  • Resolved Mindas22

    (@mindas22)


    1 year, 10 months ago

    Hi, we got this problem (after wpml update) with yoast seo indexing it runs this mysql query:
    DELETE wyi FROM wp_yoast_indexable wyi INNER JOIN wp_yoast_indexable wyi2 WHERE wyi2.object_id = wyi.object_id AND wyi2.object_type = wyi.object_type AND wyi2.id < wyi.id

    Takes one CPU core 100% and does not finish.

    Also wp_yoast_indexable table has 231,752 rows for some reason?

    What would be safe solution for that?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter Mindas22

    (@mindas22)

    1 year, 10 months ago

    Resolved, by installing yoast test helper plugin and clicked reset indexables tables & migrations. (also hosting admin had to kill the processes several times)

    The website is small after reindexing again wp_yoast_indexable has 769 rows.

    What could cause this 231,752 row problem?

    • This reply was modified 1 year, 10 months ago by Mindas22.
    Plugin Support devnihil

    (@devnihil)

    1 year, 10 months ago

    @mindas22 We’re sorry to hear you experienced difficulties in the indexing of the site. In regards to the large number of rows, can you please let us know how large the site in question is? For example, the number of pages/posts?

    Thread Starter Mindas22

    (@mindas22)

    1 year, 10 months ago

    @devnihil the website has no more than 300 pages including posts, portfolio items etc.

    Plugin Support devnihil

    (@devnihil)

    1 year, 10 months ago

    @mindas22 When the issue with the large number of database rows and CPU usage occurred, can you please confirm what version of Yoast SEO you were using?

    Was it 14.4.1 or an earlier version?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘re-indexing stuck on mysql query causing 100% cpu load’ is closed to new replies.

Views