DB yoast_indexable & yoast_indexable_hierarchy

  • Resolved pvde

    (@pvde)


    4 weeks, 1 day ago

    How to stop this plugin to fill up the DB yoast_indexable & yoast_indexable_hierarchy tables?

    yoast_indexable alone is already over 1GB, whilst I don’t use the plugin for that purpose.

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

    (@maybellyne)

    3 weeks, 6 days ago

    Hello @pvde,

    Thanks for using the Yoast SEO plugin.

    Since version 14.0, Yoast SEO stores metadata for all pages in separate database tables – wp_yoast_indexable_hierarchy & wp_yoast_indexable. This lets us 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 the tables are overbloated, please try the following:

    1. Install & activate the Yoast Test Helper plugin
    2. Go to Tools > Yoast Test
    3. Locate the Yoast SEO section and click on the ‘Reset indexables tables & migrations‘, ‘Reset Prominent words calculation‘, and ‘Reset Internal link counter‘ buttons. After each click, the page will reload to confirm that the specific reset was successful.
    4. Go to SEO > Tools, and under SEO data, click the “Start SEO data optimization” button to allow Yoast to rescan your content.

    Please monitor the results and let us know if the reported issue remains after resetting the optimized data.

    Thread Starter pvde

    (@pvde)

    3 weeks, 6 days ago

    Thank you for responding.

    I don’t want to reset or let my site rescan. I want to stop Yoast from filling up these tables overall. I only use Yoast for the SEO Title function since you can add the current date to a title. In that matter, 1/1.5 extra GB in your DB is a complete waste of resources.

    How can I stop the plugin from scanning the site? So that after I empty the tables manually it doesn’t start over with the process.

    Plugin Support Maybellyne

    (@maybellyne)

    3 weeks, 5 days ago

    You can turn OFF the associated features – Text link counter, Internal linking suggestions and Insights – in WordPress > Yoast SEO > Settings > General > Site Features.

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.

Tags