XF 1.5 What happened to my database?

borgqueenx

Active member
I suddenly have a database of 580mB from the last backup 2 months ago of being 122mB.
Activity on the site has been low, so im wondering if there is a way to check what is eating all this space.
 

Brogan

XenForo moderator
Staff member
Your post table is only 4MB and you have a fairly small forum so I wouldn't expect the search to be 156MB.
I suppose though there could be a lot of searches being made.

Even then, I don't see how the total backup can be ~600MB - the tables in that screenshot are listed in size order and only amount to around 300Mb.
 

borgqueenx

Active member
i do have some add ons, but i didnt change addons for a very long time.

I already had problems with conversations for quite some time(cant make long PM's or it gives an error), but i have no add-on that does anything with the search to my knowledge.

These are my add-ons.
https://puu.sh/thGy4/4921053d17.png
 

Brogan

XenForo moderator
Staff member
I misread the image - it's the search table which is quite large, not the index.

It's normal for that table to get quite large but I wouldn't necessarily expect it from such a small site.

You will find that table changes in size, depending on the number of searches being made.
 
Top