CenturyLinkCloud / mdw

https://centurylinkcloud.github.io/mdw/
MIT License
46 stars 10 forks source link

Change default transaction isolation level to READ_COMMITTED for MySQL/MariaDB #780

Closed donaldoakes closed 4 years ago

donaldoakes commented 4 years ago

The out-of-the-box default is REPEATABLE_READ, which can cause stale value problems when selecting for update. Oracle's default is already REPEATABLE_READ, and we'll change MySQL/MariaDB to use the same.

This can be set by property database.transaction.isolation, and is now displayed on the System Tab Database Info section.