Jump to content

Featured Replies

Posted
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? 

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.

  • Author
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! 

  • Author

BTW, what are my options if it doesn't prune?  

I can't purge the table because it's not showing up in phpMyAdmin. 

Try opening the MySQL console and running

TRUNCATE TABLE ipbcore_output_cache

See if you get an error.

  • Author

@bfarber Fanstastic!  That did it.  Went from 17GB to 176K.  

Thanks.  

Recently Browsing 0

  • No registered users viewing this page.