XF 1.5 Daily Clean not works

fingon

Active member
I was found that DAILY CLEAN in cron is not working.
With execute DAILY CLEAN manually, the xf_search still have 12.7GB data.

Before:
QQ截图20170824180704.jpg

After:
QQ截图20170824185055.jpg
 

Mike

XenForo developer
Staff member
That table can be large as it stores 24 hours of cache results for searches and "find new" requests. Given that you appear to have over 30 million posts, I would assume you have a very busy board so while on the large side, I suspect you'll find the data is getting pruned daily.
 

fingon

Active member
That table can be large as it stores 24 hours of cache results for searches and "find new" requests. Given that you appear to have over 30 million posts, I would assume you have a very busy board so while on the large side, I suspect you'll find the data is getting pruned daily.
ehmm
For now I clean it manually in phpmyadmin.:oops:
Is there anyway to limit xf_search results like node thread list only shows 90 days/180 days/1 year etc?
 

Tracy Perry

Well-known member
Personally, if I had that large of a post count, I'd seriously be looking at using ES add-on.
 

Mike

XenForo developer
Staff member
There isn't a way to automatically limit the search date range -- it would likely require an add-on.
 
Top