diff options
| author | Marius Balteanu <marius.balteanu@zitec.com> | 2023-11-26 13:56:36 +0000 |
|---|---|---|
| committer | Marius Balteanu <marius.balteanu@zitec.com> | 2023-11-26 13:56:36 +0000 |
| commit | 9575af8c83f1c14cc9f401207703d66a83a7675e (patch) | |
| tree | bca053915f11f37b75dffd7f9ff377e7f7bd98c5 /config | |
| parent | 4daed3c8678d2afce69cbd626d309b6ce3cfc913 (diff) | |
| download | redmine-9575af8c83f1c14cc9f401207703d66a83a7675e.tar.gz redmine-9575af8c83f1c14cc9f401207703d66a83a7675e.zip | |
Merged r22475 to r22477 from trunk to 5.1-stable (#39737).
git-svn-id: https://svn.redmine.org/redmine/branches/5.1-stable@22480 e93f8b46-1217-0410-a6f0-8f06a7374b81
Diffstat (limited to 'config')
| -rw-r--r-- | config/database.yml.example | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/config/database.yml.example b/config/database.yml.example index 727b4d89b..6b0849602 100644 --- a/config/database.yml.example +++ b/config/database.yml.example @@ -10,6 +10,12 @@ production: password: "" # Use "utf8" instead of "utfmb4" for MySQL prior to 5.7.7 encoding: utf8mb4 + variables: + # Recommended `transaction_isolation` for MySQL to avoid concurrency issues is + # `READ-COMMITTED`. + # In case of MySQL lower than 8, the variable name is `tx_isolation`. + # See https://www.redmine.org/projects/redmine/wiki/MySQL_configuration + transaction_isolation: "READ-COMMITTED" development: adapter: mysql2 @@ -19,6 +25,8 @@ development: password: "" # Use "utf8" instead of "utfmb4" for MySQL prior to 5.7.7 encoding: utf8mb4 + variables: + transaction_isolation: "READ-COMMITTED" # Warning: The database defined as "test" will be erased and # re-generated from your development database when you run "rake". @@ -31,6 +39,8 @@ test: password: "" # Use "utf8" instead of "utfmb4" for MySQL prior to 5.7.7 encoding: utf8mb4 + variables: + transaction_isolation: "READ-COMMITTED" # PostgreSQL configuration example #production: |