What is ipbcore_output_cache and why is it 17GB?

[thefarang]

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? 

[bfarber]

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.

[thefarang]

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! 

[thefarang]

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

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

[bfarber]

Try opening the MySQL console and running

TRUNCATE TABLE ipbcore_output_cache

See if you get an error.

[thefarang]

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

Thanks.