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

XF 1.5 runaway xf_search table? (elastisearch)

sross

Active member
#1
Hi,

3 days ago all my db dumps were around 550mb, yesterday was 700, today is 1.2GB. It looks like my xf_search keeps growing. Have tried a repair/optimise and it was 300mb larger after that. What is the best way to tackle this? Thanks
 

Mike

XenForo developer
Staff member
#3
This table can get larger than people think because it's not only used to cache search results but it old various "find new" (posts, profile posts, etc) caches, which are a commonly hit page. It clears results after 24 hours.
 

Jake Bunce

XenForo moderator
Staff member
#4
Make sure this is running:

Admin CP -> Tools -> Cron Entries -> Daily Clean Up

That is what prunes the search records.