XF 1.5 What happened to my database?

[borgqueenx]

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.

 

[Paul B]

Use phpMyAdmin and click on the size column to sort the tables.

 

[borgqueenx]

Use phpMyAdmin and click on the size column to sort the tables.

thanks.
Here is a print screen.

I dont get how these can suddenly be so huge in size though...

 

[Paul B]

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]

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

 

[Paul B]

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.