#29380: Add support for QuerySet.select_for_update()'s nowait and skip_locked
options on MySQL 8+
-------------------------------------+-------------------------------------
Reporter: bakabiko | Owner: nobody
Type: | Status: new
Cleanup/optimization |
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: skip_locked, MYSQL, | Triage Stage: Accepted
database |
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Tim Graham):
* stage: Unreviewed => Accepted
* type: New feature => Cleanup/optimization
* easy: 1 => 0
Old description:
> MYSQL 8+ already supports skip locked and no wait options while Django DB
> backend doesn't support it for MYSQL.
>
> Reference: https://mysqlserverteam.com/mysql-8-0-1-using-skip-locked-and-
> nowait-to-handle-hot-rows/
New description:
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/
--
--
Ticket URL: <https://code.djangoproject.com/ticket/29380#comment:1>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/066.f23674d40ea4bf165433bd4394c4f574%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
