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

Re: Table Core_Cache increasing rapidly

@siemed

 

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

Found something useful, please give "Kudos" or "Accept as Solution" for Token of Appreciation.
Free Magento Extensions : https://magecomp.com/free-magento-extensions.html

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.

Found something useful, please give "Kudos" or "Accept as Solution" for Token of Appreciation.
Free Magento Extensions : https://magecomp.com/free-magento-extensions.html

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>
James Lee | Moderator • Magento Master
See My Recommended Magento Hosting & Security Tips

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>
James Lee | Moderator • Magento Master
See My Recommended Magento Hosting & Security Tips

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?