Change mysql configuration or add a Session Variable in the connection string

[Deleted user]

For a new installation of confluence, what do you this that can be a good solution, 

If this server ( MySQL ) is shared with Jira, Jira can be affected? 

Add to my.cnf this: 

[mysqld]
...
transaction-isolation=READ-COMMITTED
...

or make the connection string like this : 

jdbc:mysql://127.0.0.1:3306/confdb?sessionVariables=tx_isolation='READ-COMMITTED'

Ref : 

https://ja.confluence.atlassian.com/confkb/confluence-fails-to-start-and-throws-mysql-session-isolation-level-repeatable-read-is-no-longer-supported-error-241568536.html

[Gonchik Tsymzhitov]

That one is ok. One minus is to have many commits