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

Do not write for null update (properly fix MySQL Bug#29157)

    XMLWordPrintable

Details

    Description

      monty noted that InnoDB takes a lot of time to perform null updates. The reason is that even though an empty update vector was created, InnoDB will go on to write undo log records and update the system columns DB_TRX_ID and DB_ROLL_PTR in the clustered index, and of course write redo log for all this.

      This could have been fixed properly when MySQL Bug #29157 was addressed over 10 years ago.

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.