xf_search data free 1.8GB

Brent W

Well-known member
See screenshot:

Screen Shot 2017-02-01 at 2.42.41 AM.png

MySQL Tuner tells me to run Optimize Table but it does not solve the issue:

      OPTIMIZE TABLE live_xf.xf_search; -- can free 1867 MB
    Total freed space after theses OPTIMIZE TABLE : 1867 Mb

Any ideas on how to reclaim that space?


Well-known member
At worse; You can try truncating the table. As this table is just a cache of recent search results ids.

Or create a new table with the same layout, copy everything over and then rename the old away and put the new one in the same place.