Support » Plugin: Yoast SEO » wp_yoast_seo_meta table weight

  • Resolved Clément Polito


    Hello !
    I had a problem with a too heavy table of my database (wp_postmeta). So I cleaned it.
    With that, I saw the table wp_yoast_seo_meta is heavy too, with a lot of lines.
    It weights 57,6 mo, with 1 560 147 lines.

    Is it really normal ?

    Thank you !

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



    Can you confirm you have Yoast SEO v7.0.3 and WP v4.9.4?

    Can you try and gather as much information for us as possible? Please perform the following:

    1. Make sure the issue doesn’t persist when Yoast SEO is disabled.
    2. Check for conflicts.
    3. Check for JavaScript errors with your console.

    If you find any JavaScript errors related to Yoast SEO or if there is a conflict with a plugin or a theme, you can create a new GitHub issue for our developers. Please report the issue to a third party developer as well.

    If you didn’t find any conflicts or errors, we think the issue is specific to your site. We’d need to investigate further but are unable to do so on these forums. You can purchase Yoast SEO Premium and receive our Premium email support and we can help you further.


    Yes, I have last version of WordPress and Yoast SEO.
    I havn’t neither conflict nor JavaScript error.

    Of course, database doesn’t change if Yoast SEO if activated or deactivated.

    I just want to know if it’s normal to have a big table database like this :
    – I have 1 857 886 object ids ;
    – In internal_link_count, it contains ‘null’ or a number, from 0 to 50 ;
    – In incoming_link_count, it contains numbers, from 0 to 3.

    My web hosting service limits the table weight to 100 Mo. I’m near to 60 Mo. If it is not normal to have numbers like this, I have to intervene (But I don’t know the reason of the problem, and I don’t know how to resolve it yet).

    If it’s normal, I would like to remove this text link counter functionnality and this table.
    I prefer to not use the text link counter functionnality than to be in the impossibility to create posts, because the web hosting service blocks.

    [Edit] I just have 243 ID which contains data (different than 0 in internal_link_count or incoming_link_count table)
    This ID comes from 1 to 9 000, with a lot of jumps. Then to 9 000 to 262 000 with only 11 ID. After, it only contains 0, from 271 425 to the end, 1 790 000, with no jump between ID.[/Edit]

    Thank you.

    Plugin Support Md Mazedul Islam Khan


    @clementpolito Depending on the website size, the wp_yoast_seo_meta table could be either in big size or a smaller one. If you have big lists of content (posts, pages, other types content etc) the wp_yoast_seo_meta table size may be increased.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘wp_yoast_seo_meta table weight’ is closed to new replies.