cancel
Showing results for 
Search instead for 
Did you mean: 

Table Core_Cache increasing rapidly

Table Core_Cache increasing rapidly

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.

11 REPLIES 11

Re: Table Core_Cache increasing rapidly

@siemed

 

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

Was my answer helpful? You can accept it as a solution.
175+ Professional Extensions for M1 & M2
Need a developer?Just visit Contact Us Now

Re: Table Core_Cache increasing rapidly

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?

Re: Table Core_Cache increasing rapidly

@siemed

 

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

Was my answer helpful? You can accept it as a solution.
175+ Professional Extensions for M1 & M2
Need a developer?Just visit Contact Us Now

Re: Table Core_Cache increasing rapidly

Hi,

 

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

Re: Table Core_Cache increasing rapidly

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>

Re: Table Core_Cache increasing rapidly

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.

Re: Table Core_Cache increasing rapidly

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

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

Re: Table Core_Cache increasing rapidly

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

 

Re: Table Core_Cache increasing rapidly

what was the answer with this thread?