beboptions
Forum Replies Created
-
All I can say after several days of testing is the only way to stop server from crashing is disabling Yoast. There is some serious issue with Yoast since indexables was introduced. I have had sitemaps turned off completely so that cannot be the issue.
Are you sure indexables doesnt run on its own> i see this message.
“Wait for a week or so, until Yoast SEO automatically processes most of your content in the background. Remind me in a week.”
I’ve had Sitemaps TURNED OFF this whole time! So that can’t be the problem. I dont know why Yoast is causing my Server to crash with MySQL Creating Sort Index Queries after 24 hours.
Yes it is relatively large.
Which PHP File can I find wpseo_sitemap_entries_per_page
php 7.2 mariadb 10.2.32
Please see this post. It seems it is caused by Yoast Sitemaps?
Does anyone know what part of WordPress makes this particular operation run?
byu/chriscasemart inWordPressA) Are you using the latest WordPress?
Yes
B) Are all other plugins and themes up to date?
Yes
C) Does your site meet the plugin requirements?
Yes
D) Can you give us a little more information on your hosting infrastructure and mySQL set-up?
VPS Running WHM/Cpanel. Only 2 Sites, both running Yoast.Why is Yoast doing MySQL Queries randomly? Is it because of Indexables being automated?
Please give us an option to turn that off. Yoast used to be fine and these Indexables have caused so much problems for everyone.Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modifi
Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modifi
Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modifi
Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modifi
Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modifiAfter the crash they turn into Sleeping processes and my server cannot recover without reboot.