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

Discard temporary undo logs at transaction commit

Details

    Description

      Starting with MySQL 5.7, temporary tables in InnoDB are handled differently from persistent tables. Because temporary tables are private to a connection, concurrency control and multi-versioning (MVCC) are not applicable. For performance reasons, purge is disabled as well. Rollback is supported for temporary tables.

      Because MVCC and purge are disabled for temporary tables, we should discard all temporary undo logs already at transaction commit, just like we discard the persistent insert_undo logs. Currently, update_undo logs are being preserved.

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Marko Mäkelä made transition -
            Open In Progress
            19h 48m 1
            Marko Mäkelä made transition -
            In Progress In Review
            59s 1
            Jan Lindström (Inactive) made transition -
            In Review Stalled
            3d 1h 3m 1
            Marko Mäkelä made transition -
            Stalled Closed
            3h 49m 1

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              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.