Hi,
we plan to set the transaction isolation level to TRANSACTION_READ_COMMITTED globally with MySQL as the keycloak DB .
The purpose is to solve the deadlock issues that we saw increasing as the number of offline sessions increases in our DB.

According to the benchmark we've made this is working well and it dramatically reduces the number of dealocks.

Our question is whether this is something that could be recommended ?

FYI: we're currently stuck with KC 14.0.0 which shows major issues in the way the offline sessions are handled