#29380 closed Cleanup/optimization (fixed)
Add support for QuerySet.select_for_update()'s nowait and skip_locked options on MySQL 8+
Reported by: | bakabiko | Owned by: | bakabiko |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | dev |
Severity: | Normal | Keywords: | skip_locked, MYSQL, database |
Cc: | Adam Johnson | Triage Stage: | Accepted |
Has patch: | yes | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description (last modified by )
MySQL 8+ supports skip_locked
and nowait
options but the MySQL database backend doesn't support them.
Reference: https://mysqlserverteam.com/mysql-8-0-1-using-skip-locked-and-nowait-to-handle-hot-rows/
Change History (12)
comment:1 by , 7 years ago
Description: | modified (diff) |
---|---|
Easy pickings: | unset |
Summary: | Support skip_locked argument to QuerySet.select_for_update() on MYSQL 8+ → Add support for QuerySet.select_for_update()'s nowait and skip_locked options on MySQL 8+ |
Triage Stage: | Unreviewed → Accepted |
Type: | New feature → Cleanup/optimization |
comment:2 by , 7 years ago
Owner: | changed from | to
---|---|
Status: | new → assigned |
comment:3 by , 7 years ago
comment:4 by , 7 years ago
Cc: | added |
---|
comment:5 by , 7 years ago
Owner: | removed |
---|---|
Status: | assigned → new |
Deassigned so bakabiko can take it if he/she wants!
comment:6 by , 7 years ago
Owner: | set to |
---|---|
Status: | new → assigned |
comment:8 by , 7 years ago
Patch needs improvement: | set |
---|
comment:9 by , 6 years ago
Patch needs improvement: | unset |
---|
Note:
See TracTickets
for help on using tickets.
I already have a patch, you can assign the ticket to me.