id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
30928	Update documentation about MariaDB and MySQL support for nowait and skip_locked arguments.	Par Andersson	Kolawole Nafiu Erinoso	"The documentation incorrectly claims that NOWAIT & SKIP LOCKED is not supported by MySQL:

https://docs.djangoproject.com/en/dev/ref/models/querysets/#select-for-update

{{{
Currently, the postgresql, oracle, and mysql database backends support select_for_update(). However, MySQL doesn’t support the nowait, skip_locked, and of arguments.

Passing nowait=True, skip_locked=True, or of to select_for_update() using database backends that do not support these options, such as MySQL, raises a NotSupportedError. This prevents code from unexpectedly blocking.
}}}

However MySQL added support for nowait and skip locked since version 8, as documented here:
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html
"	Cleanup/optimization	closed	Documentation	2.2	Normal	fixed	mysql mariadb		Accepted	0	0	0	0	1	0