XF 1.5 SQL Database of xenforo being 750mB large....

[borgqueenx]

Is there any way i can remove entries no longer being used?

xf_search already costs 419mb.
xf_template_compiled costs 51mb.

 

[Nudaii]

you can rebuild search, but that wont be any smaller unless you have pruned alot of threads recently.

 

[RobParker]

Are you using the Enhanced Search addon? I think (but double check with someone else) that you can empty the search table if so as it's not used.

 

[Mike]

The xf_search template is not the index. It holds temporary search results (including find new results). It would normally only hold the last 24 hours of results, but it can grow fairly large in certain situations.

 

[RobParker]

Ah sorry I misread and assumed it was the index given how large it was!