diff options
author | Marius Balteanu <marius.balteanu@zitec.com> | 2023-11-26 13:20:27 +0000 |
---|---|---|
committer | Marius Balteanu <marius.balteanu@zitec.com> | 2023-11-26 13:20:27 +0000 |
commit | 9441710faebb04a8aafa7cf764a096178e96b3c4 (patch) | |
tree | 2e2bf5e68b133ca4485fe7dd0725058c7054384e | |
parent | 68fa4562231130eae0f3ebd13fd1c3dbae240655 (diff) | |
download | redmine-9441710faebb04a8aafa7cf764a096178e96b3c4.tar.gz redmine-9441710faebb04a8aafa7cf764a096178e96b3c4.zip |
Update database versions and MySQL related documentation to include the workaround for concurrency issues (#39737, #39592).
git-svn-id: https://svn.redmine.org/redmine/trunk@22476 e93f8b46-1217-0410-a6f0-8f06a7374b81
-rw-r--r-- | doc/INSTALL | 24 |
1 files changed, 22 insertions, 2 deletions
diff --git a/doc/INSTALL b/doc/INSTALL index 1487b8317..e8bc11d33 100644 --- a/doc/INSTALL +++ b/doc/INSTALL @@ -10,8 +10,8 @@ http://www.redmine.org/ * Ruby 2.7, 3.0, 3.1, 3.2 * A database: - * MySQL (tested with MySQL 5.7) - * PostgreSQL (tested with PostgreSQL 9.5) + * MySQL (tested with MySQL 8) + * PostgreSQL (tested with PostgreSQL 14) * SQLite3 (tested with SQLite 3.11) * SQLServer (tested with SQLServer 2012) @@ -86,6 +86,26 @@ The current version of Firefox, Safari, Chrome, Chromium and Microsoft Edge. Go to "Administration" to load the default configuration data (roles, trackers, statuses, workflow) and to adjust the application settings +== Database server configuration + +When using MySQL with Redmine 5.1.1 or later, it is necessary to change +the transaction isolation level from the default REPEATABLE READ to +READ_COMMITTED. To modify this setting, either change the database +configuration file or alter the settings on your MySQL server. + +To set the transaction isolation level in the database configuration file, +add transaction_isolation variable as below: + + production: + adapter: mysql2 + database: redmine + host: localhost + [...] + variables: + transaction_isolation: "READ-COMMITTED" + +More details can be found in https://www.redmine.org/projects/redmine/wiki/MySQL_configuration. + == SMTP server Configuration Copy config/configuration.yml.example to config/configuration.yml and |