XF 1.5 runaway xf_search table? (elastisearch)


Active member

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


XenForo developer
Staff member
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
Make sure this is running:

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

That is what prunes the search records.