Table Core_Cache increasing rapidly

[siemed]

Hi,

I have a Magento installation (1.9) that is live for 2 months now. Last week I got a server message that my disk space was low, when I checked the database table core_cache had over 5 Gb of data.

I emptied it, but it keep on growing fast every day.

I don't believe I made the choice to keep cache in the database, but what else can it be? 

Is there a way to get the cache (back?) to the file system?

Thank you in advance.

[theMageComp]

@siemed

If your caching is enable then please disable it and then try again.

[siemed]

But, caching is important for speed. So, I would like to use caching, but then as files and not in the database. I beleive this is an option on install, can you change this after installation?

[theMageComp]

@siemed

Yes, we can enable it after the installation. I am telling you for debugging of the issue.

[siemed]

Hi,

I can confirm that with chaching disabled the table does not increase. So, the table only increases with caching enabled.

[JLHC]

If you mean session storage, you are given a choice to choose either to use the File System or Database during installation. 

If you selected Database and want to change it to File System now, open your /app/etc/local.xml file and search for:-

<session_save><![CDATA[db]]></session_save>

Replace it with:-

<session_save><![CDATA[files]]></session_save>

[siemed]

Hello JLHC,

Thank you for your advice, I checked, but in my local.xml the session save is already on files. There must be another setting/configuration that causes the table corce_cache to increase when caching is turned on.

Can this be caused by an extension? I have Amasty Full Page Cache installed, but I think it has it's own table.

[JLHC]

Do you see the following codes in your /app/etc/local.xml file?

<cache>
    <backend>database</backend>
</cache>

[siemed]

No, there is no information about the cache in the local.xml.

[sml12]

what was the answer with this thread?