When and how often Yoast create sitemap index record?

  • Resolved Takahashi Fumiki

    (@takahashi_fumiki)


    9 months, 2 weeks ago

    Hi,

    We have a WordPress site with 500 thousands+ posts.

    We’ve already know the huge impact of the record Yoast creating on the tables below:

    1. wp_yoast_indexable_hierarchy
    2. wp_yoast_indexable

    To avoid the frequent read/write to DB, we’ve stopped the sitemap feature.

    But it seems that Yoast still insert recoreds to the tables via cron job nevertheless sitemap is active or not. It took almost 1 day under high load average.

    So, I’d like to know:

    1. When Yoast create sitemap records? We know the first activation of the plugin trigger one, but is there any whole indices creation?
    2. How often it occurs? The whole indices make huge impact, so we need preparation for that.

    Thanks in advance.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Maybellyne

    (@maybellyne)

    Hello Takahashi,

    Thanks for using the Yoast SEO plugin. The creation of wp_yoast_indexable_hierarchy and wp_yoast_indexable isn’t connected to the sitemap feature. Since version 14.0, Yoast SEO stores metadata for all pages in a separate database table. This allows us to fetch a page’s metadata in one simple database request (rather than many individual requests), resulting in much faster page loads.

    Before 14.0, we stored metadata like titles and meta descriptions in different places for different types of pages. This data needs to be migrated to the new table for everything to work best. To do this, Yoast SEO will ask to index your site’s SEO data. You can learn more at?https://yoast.com/help/why-does-yoast-seo-ask-to-index-a-sites-seo-data/

    If your site is slowed down, experiencing high CPU usage etc, you can turn OFF the associated features (Text link counter, Internal linking suggestions and Insights) in WordPress > Yoast SEO > Settings > General > Site Features.

    Thread Starter Takahashi Fumiki

    (@takahashi_fumiki)

    @maybellyne

    Thanks for the reply.

    It’s good for me to know that sitemap features is not the only reason.

    We’ll consider deatctivate those features below on huge site.

    • sitemap
    • Text link counter
    • Internal linking suggestions
    • Insights
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘When and how often Yoast create sitemap index record?’ is closed to new replies.