Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21921

Make transaction_isolation into a system variable

    XMLWordPrintable

    Details

      Description

      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:

      https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_transaction_isolation

      It may be a good idea for MariaDB to make the same change.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              ralf.gebhardt@mariadb.com Ralf Gebhardt
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated: