Today I saw my Magento database and in a few months, it went from a weight of 300MB to 2GB. I saw which of the tables was heavier and I saw that there is a 2GB SESSION table.
Why do the sessions are saved in the Database and not in a folder? Is it possible to clean the table without breaking the website? Is there any setting I can add to change the save into the DB?
Below an image.
open app/etc/env.php (changing session save from db to file)
find
'session' => array ( 'save' => 'db', )
replace with
'session' => array ( 'save' => 'files', )
The configuration can be found in:
app/etc/env.php
and can be changed by updating the session configuration to:
'session' =>
array (
'save' => 'files',
),
When you save it in sessions you can clear the session tables.
Normally the session files will be cleaned up through the cron but if you want to make sure old session files are removed add a crontask to the crontab like this example:
0 2 * * * flock -n ~/.cleanup-sessions.lock -c 'find /folder/to/your/magento/root/var/session -name '"'"'sess_*'"'"' -type f -mtime +1 -exec rm {} \;'
Its possible that your php.ini or user.ini file has the session.save_handler directive set to db.
If you see a line that says: session.save_handler = db
Change it to: session.save_handler = files
Remember to restart PHP after making changes to *.ini files.
I would advise activating Memcache through these changes in your Magento root folder > app > etc > env.php.
From: 'session' => array ( 'save' => 'db', )
In: 'session' => array ('save' => 'memcached', 'save_path' => '127.0.0.1:11211'),
Then remove these files: rm -rf var/cache/* var/page_cache/* var/session/*
This will improve your website speed.
