diff options
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/ref/databases.txt | 10 | ||||
| -rw-r--r-- | docs/releases/2.0.txt | 9 |
2 files changed, 17 insertions, 2 deletions
diff --git a/docs/ref/databases.txt b/docs/ref/databases.txt index 26351314de..af368c8dd5 100644 --- a/docs/ref/databases.txt +++ b/docs/ref/databases.txt @@ -449,8 +449,14 @@ this entry are the four standard isolation levels: * ``'serializable'`` or ``None`` to use the server's configured isolation level. However, Django -works best with read committed rather than MySQL's default, repeatable read. -Data loss is possible with repeatable read. +works best with and defaults to read committed rather than MySQL's default, +repeatable read. Data loss is possible with repeatable read. + +.. versionchanged:: 2.0 + + In older versions, the MySQL database backend defaults to using the + database's isolation level (which defaults to repeatable read) rather + than read committed. .. _transaction isolation level: https://dev.mysql.com/doc/refman/en/innodb-transaction-isolation-levels.html diff --git a/docs/releases/2.0.txt b/docs/releases/2.0.txt index dec2b85228..4e42bd2b55 100644 --- a/docs/releases/2.0.txt +++ b/docs/releases/2.0.txt @@ -227,6 +227,15 @@ The end of upstream support for Oracle 11.2 is Dec. 2020. Django 1.11 will be supported until April 2020 which almost reaches this date. Django 2.0 officially supports Oracle 12.1+. +Default MySQL isolation level is read committed +----------------------------------------------- + +MySQL's default isolation level, repeatable read, may cause data loss in +typical Django usage. To prevent that and for consistency with other databases, +the default isolation level is now read committed. You can use the +:setting:`DATABASES` setting to :ref:`use a different isolation level +<mysql-isolation-level>`, if needed. + :attr:`AbstractUser.last_name <django.contrib.auth.models.User.last_name>` ``max_length`` increased to 150 ---------------------------------------------------------------------------------------------------------- |
