re-indexing stuck on mysql query causing 100% cpu load
-
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.idTakes 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)
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.