• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Table size differences - anything look unusual?

Live Free

Active member
#1
So I thought I was having a database crisis, long story short it doesn't appear I am. I compared table sizes for my current installation and a two week old backup. A few tables seemed to drop in size which caught my eye and I'm not sure if I should be concerned or not.

Screen Shot 2017-03-20 at 4.18.58 AM.png

Left columns contain data on the changed tables, right columns on the current database.

Do any of the size decreases look unusual or alarming?

In particular - xf_conversation_message, xf_liked_content, xf_post, xf_thread, xf_thread_user_post, xf_thread_watch, xfa_blog_comment and others have decreased (with some change in rows).

Can anyone comment on this?

For example, does the change in values for xf_post indicate a significant loss of actual forum posts? In this case we're talking about 50,000 rows and 170MB.

Thanks guys.