1. 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)

Discussion in 'Troubleshooting and Problems' started by sross, Aug 27, 2016.

  1. sross

    sross 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
  2. sross

    sross Active Member

    ok i guess it took some time for the optimise to reflect. It's gone from 7 GB to 4.5 GB
  3. Mike

    Mike 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.
  4. Jake Bunce

    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.

Share This Page