thefarang Posted February 1, 2021 Share Posted February 1, 2021 mysql mysql 17G Feb 1 13:32 ipbcore_output_cache.ibd In the last few weeks, I began to notice that my database volume has been starting to fill up quicker than normal. When I went to check the file sizes, I noticed this ipbcore_output_cache file in the MySQL folder and it was 17GB. When I tried to find this in phpMyAdmin, it doesn't show a table called ipbcore_output_cache (just ipbcore_cache). Searching Google results in no pages found. Searching this site shows no pages found. Any idea what it might be and why it's so huge? Link to comment Share on other sites More sharing options...
bfarber Posted February 1, 2021 Share Posted February 1, 2021 This table would hold entire cached pages, and be pruned periodically by a background task. You can alternatively store these caches in Redis or in a remote database, and you can change how long the pages are cached for with the CACHE_PAGE_TIMEOUT constant. Cooking 1 Link to comment Share on other sites More sharing options...
thefarang Posted February 1, 2021 Author Share Posted February 1, 2021 3 minutes ago, bfarber said: This table would hold entire cached pages, and be pruned periodically by a background task. You can alternatively store these caches in Redis or in a remote database, and you can change how long the pages are cached for with the CACHE_PAGE_TIMEOUT constant. Thanks! Link to comment Share on other sites More sharing options...
thefarang Posted February 1, 2021 Author Share Posted February 1, 2021 BTW, what are my options if it doesn't prune? I can't purge the table because it's not showing up in phpMyAdmin. Cooking 1 Link to comment Share on other sites More sharing options...
bfarber Posted February 2, 2021 Share Posted February 2, 2021 Try opening the MySQL console and running TRUNCATE TABLE ipbcore_output_cache See if you get an error. Link to comment Share on other sites More sharing options...
thefarang Posted February 3, 2021 Author Share Posted February 3, 2021 @bfarber Fanstastic! That did it. Went from 17GB to 176K. Thanks. Link to comment Share on other sites More sharing options...
Recommended Posts