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

Make transaction_isolation into a system variable

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

      Same has been done to transaction_read_only option:
      https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-20.html

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31746 Problems with tx_isolation after MDEV-21921

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          is part of

          Task - A task that needs to be done. MDEV-28906 MySQL 8.0 desired compatibility

          • Major - Major loss of function.
          • Open
          relates to

          New Feature - A new feature of the product, which has yet to be developed. CONJ-1087 handle mariadb-11.1+ transaction_isolation

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23520 Unknown system variable 'transaction_isolation'

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31576 Unknown system variable 'transaction_isolation'

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32109 Compatibility Broken with Mysql JDBC Connector

          • Major - Major loss of function.
          • Closed
          links to

          Web Link tx_isolation in MariaDB knowledge base

          Web Link tx_read_only in MariaDB knowledge base

          Activity

            Transition Time In Source Status Execution Times
            Daniel Black made transition -
            Open Closed
            		1126d 4h 15m 1

            People

              danblack Daniel Black
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.