Comments (4)
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.
Related Issues (20)
- Saving product from backend causes destroying category product positions in anchor categories.
- All attributes set to be used for search appear in layering navigation when there are no search results HOT 11
- Loopback for the changes Zend directory HOT 5
- The graphs in the Dashboard page no longer display data HOT 10
- Wrong attributes order in comparison window
- Bug on created_at in customer_entity table on update HOT 4
- Deprecated functionality: strlen(): Passing null to parameter #1
- Deprecated functionality: strlen(): Passing null to parameter #1 - Abstract.php HOT 4
- [Minimal Query Length] issue for search strings of 1 - 2 characters HOT 3
- [Backend Navbar] Empty spaces in the classes HOT 5
- New EAV attributes not found without cleaning cache
- Zip-Release 20.10.0 incomplete or too many items? HOT 5
- Missing translation new order mail HOT 1
- Question about commit ...
- [Backend] Changing Customer Password - The warning message. HOT 2
- [Backend] Creating New Customer - No message is sent to the customer HOT 3
- Error when saving product with image without description HOT 7
- Main branch does not correspond to the release tag 20.10.2 HOT 4
- Unit tests not run?
- Paypal Credit "See terms" not working HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from magento-lts.