Solved Magento 1.6 MySQL core_session table size grows fast

After upgrade magento from 1.4.0.1 to 1.6.2.0

In Phpmyadmin I just notice the size of core_session table grows fast than normal

I trustate data in core_session now , before , it reach 450MB and 250MB ….

Unknow what happen , at last have to ask a friend , he told me :

We do not recommend storing sessions in the database unless running a multi-store. You should see a performance benefit from storing sessions in the file-system. You can do this by editing your app/etc/local.xml, line 51 below.

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

Change to:

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

You may need to clear var/cache and can potentially truncate the core_session table subsequent to this change. This will be our only recommended solution to the issue you are describing.

I do according he says , it is work !

Now , I have my author name : Winsion Liang ┬á­čÖé ┬á, link here Winsion Liang

 

2 thoughts on “Solved Magento 1.6 MySQL core_session table size grows fast

Leave a Reply

Your email address will not be published. Required fields are marked *