Magento removes old sessions without limit about magento-lts HOT 4 CLOSED

After thinking about it, setting a limit will not help much when you have long session lifetime, as most of the cases Magento will not find enough records to fulfill the limit, thus it will do a full table scan anyway.

from magento-lts.

I would think something like an hourly cron job would be appropriate for the MySQL driver.

It seems there should definitely be an index on session_expires. Without an index the whole table is locked using the default "REPEATABLE READ" isolation level. The alternative to avoid locking would be to use "READ COMMITTED" isolation level for this one update, but the full table scan still is going to be bad for performance.

from magento-lts.

Is this still an issue? we added the index.

from magento-lts.

Quite old ... i'd close to do some cleanup. Please reopen if its still an issue.

from magento-lts.