wp_termmeta InnoDB Whas is it? And what is impact of Emptying it?

  • I have noticed that wp_termmeta InnoDB table has an overhead of 4 MB. I’m trying to find the ways to remove the overhead. Optimization of this table does not help. I’m wondering what is stored in this table and if I empty it, what is potential risk / impact?

    I hope someone will help me to figure this out.

    Thank you in advance.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Don’t worry about it. Reporting of overhead on InnoDB tables via many versions of phpMyAdmin and/or mysql server is innacurate and meaningless.

    It is not affecting your site.

    Thread Starter olga777

    (@olga777)

    Thank you very much for your quick response!

    I have one more question: I have also noticed that table wp_comments has over 28K rows – I honestly have no idea what they are, as I have no comments at all. Anything that was spam (not a big number) was already deleted from Admin. What exactly (what data other than comments to posts, which we do not have, as we are ecommerce site) this table stores? Is it safe to empty wp_comments and wp_commentmeta tables (if there are no comments to be kept)?

    Thank you very much for your support in advance.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    without looking at the contents of those tables, I can’t say. If you truly have no comments, then truncating those tables should not be an issue.

    backup first!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘wp_termmeta InnoDB Whas is it? And what is impact of Emptying it?’ is closed to new replies.