Thread Starter
Anonymous User 15141300
(@anonymized-15141300)
I need to say that this a WordPress Multisite that has been migrated from one IP (http://123.123.123.123) to a domain (https://example.com).
In the migration process, I use this tool: https://github.com/interconnectit/Search-Replace-DB
How compatible are the new “indexable” tables from Yoast SEO with a migration like this? I think the problem could be related to that.
Same issue here. I think this is related to the large number of posts. Not the migration issue. My website with 500k+ post is experiencing the same issue.
Whenever trying to load the search appearance page, the processor and ram usage going to very high and after a couple of minutes, it’s getting timeout.
Thread Starter
Anonymous User 15141300
(@anonymized-15141300)
Hey @nissho325 – Do you have timeout problems when trying to edit or add a new page? I am trying to debug what could be happening here.
I think the problem with my pages is that I load a meta_box on them, and the query related to that, I think, is querying the whole wp_posts and wp_postmeta tables, and that’s the reason why it is timing out.
And my assumption is that by loading the “Search Appearance” tab, some similar query is being done, that queries the whole wp_posts and wp_postmeta tables.
@agb58 creating and editing pages is fine here. No issues with that.
I think your assumption is correct regarding the loading of the “Search Appearance” tab. Because, when I’m trying to load that particular tab, the memory and CPU usage of my VPS is going to full. That means it’s doing some queries for every post in wp_posts and wp_postmeta table.
@agb58 We are sorry to hear that you are having an issue with the Yoast SEO plugin, and we’d be more than happy to investigate the matter further for you.
Can you please confirm whether you have performed the new indexables analysis?
Typically the search appearance window shouldn’t take such long period of time to execute a query. Can you please install the 3rd party Query Monitor plugin to check what query it’s executing on the relevant page?
On the other hand, can you please confirm whether the issue persists if you resets the new indexables tables using the Yoast Test Helper plugin?
Thread Starter
Anonymous User 15141300
(@anonymized-15141300)
Hey @mazedulislamkhan thanks for your reply! I decided to re-structure the website and host a maximum of 35.000 posts per wp_posts table. That made the website and the “Search Appearance” option to work again. So it was something to do with a query to wp_posts or wp_postmeta.
If in the future I deal with a similar problem, with a big website, I know how to debug the problem with your instructions.
