I want to install NextCloud to use the same MariaDB/MySQL database as some other applications on the same host. As such, I don’t want to set transaction_isolation = READ-COMMITTED for the whole server. It seems that it ought to be possible to set the transaction isolation mode on a per-connection basis – indeed, it seems like it was done that way in the NextCloud codebase at some point in the past.
Can anyone speak to why this was removed, and what options might be available to me? Thank you so much!
There’s an open thread on this in both the server repo and in docs. My reading of it so far is that it’s set in NC in the session so probably unnecessary to globally enable it.