Is Yoast 200mb Mysql normal?

  • Resolved fdanell

    (@fdanell)


    4 years, 5 months ago

    Hi,
    I’m troubleshooting some performance issues on our site and just wanted to ask if near 200mb of database usage is normal for yoast:

    yoast_indexable = 133mb (429918 rows)

    yoast_indexable_hierarchy = 59mb (672696 rows)

Viewing 3 replies - 1 through 3 (of 3 total)

  • Hi @fdanell,

    Thank you for reaching out.

    Without knowing your site and how big it is, it’s hard to tell. The size and amount of rows in those tables are related to the amount of posts/pages/taxonomies/products/custom post type posts and more on your site. Can you please share a little more information?

    Thanks.

    Thread Starter fdanell

    (@fdanell)

    Hi,
    Nothing too crazy, it’s a moderate e-commerce site

    600 products (half of which are translations)
    39 pages (half of which are translations)
    6 posts (half of which are translations)

    12 attributes (half of which are translations)
    106 attribute terms

    Just thought those tables stood out in our database but maybe it’s normal.
    https://photos.app.goo.gl/rosLt5X1WpbsSkQ29

    Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    Yoast SEO 14.0 comes with a?revolutionary update?that uses an innovative new way of gathering data in WordPress. It’s now able to present data in a single instance, instead of getting every little piece at a time. We’ve rebuilt a large part of how the plugin gets its data, which helped us to make it faster to load and faster to load pages.

    To do all of this, Yoast SEO needs space in the database, and the amount required depends on the amount of indexable content on your site, one row for each indexable piece of content. This innovative way of handling data inside WordPress helps us — and you — get ready for a fascinating future!

    So, depending on your website, the relevant tables may take less or more space in the database.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Is Yoast 200mb Mysql normal?’ is closed to new replies.