In MariaDB, we have a confusing problem where:
- The transaction_isolation option can be set in a configuration file, but it cannot be set dynamically.
- The tx_isolation system variable can be set dynamically, but it cannot be set in a configuration file.
Therefore, we have two different names for the same thing in different contexts. This is needlessly confusing, and it complicates the documentation.
MySQL 5.7 solved this problem by making transaction_isolation into a system variable:
It may be a good idea for MariaDB to make the same change.