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

              Assignee:
              greenman Ian Gilfillan
              Reporter:
              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.