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

mysql.transaction_registry is not documented in KB

    XMLWordPrintable

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

            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.