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

mysql.transaction_registry is not documented in KB

Details

    Description

      mysql.transaction_registry table exists and is used for transaction-precise versioning, but can't be found anywhere in the KB by search. Please document it, specifically the difference between transaction_id and commit_id, and between begin_timestamp and commit_timestamp – they seem to be not as obvious as they sound.

      begin_timestamp name appears misleading. In the context of transactions, one would expect that it's time when the transaction was started (implicitly or explicitly via BEGIN / START TRANSACTION), but experimentation shows it's not so. My best guess is that begin_timestamp is when execution of COMMIT started, and commit_timestamp is when execution of COMMIT finished. If this is indeed meant to be so, the naming is quite unfortunate.

      Attachments

        Issue Links

          Activity

            BEGIN_TIMESTAMP is the timestamp of transaction begin (i.e. BEGIN statement). This is the subject of MDEV-16024.

            midenok Aleksey Midenkov added a comment - BEGIN_TIMESTAMP is the timestamp of transaction begin (i.e. BEGIN statement). This is the subject of MDEV-16024 .

            People

              greenman Ian Gilfillan
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.