Brent W Well-known member Feb 1, 2017 #1 See screenshot: MySQL Tuner tells me to run Optimize Table but it does not solve the issue: Code: 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?
See screenshot: MySQL Tuner tells me to run Optimize Table but it does not solve the issue: Code: 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?
X Xon Well-known member Feb 4, 2017 #3 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.
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.
