#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 , 8 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 , 8 years ago
| Owner: | changed from to |
|---|---|
| Status: | new → assigned |
comment:3 by , 8 years ago
comment:4 by , 8 years ago
| Cc: | added |
|---|
comment:5 by , 8 years ago
| Owner: | removed |
|---|---|
| Status: | assigned → new |
Deassigned so bakabiko can take it if he/she wants!
comment:6 by , 8 years ago
| Owner: | set to |
|---|---|
| Status: | new → assigned |
comment:8 by , 8 years ago
| Patch needs improvement: | set |
|---|
comment:9 by , 8 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.