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

Index Condition Pushdown for multi-table UPDATEs/DELETEs

    XMLWordPrintable

Details

    Description

      Index Condition Pushdown optimization is currently not used for multi-table UPDATEs/DELETEs.

      It is not used for

      • Tables that are not updated
      • When UPDATE/DELETE is buffered - i.e. when it has read phase followed by update phase.

      Start to use it.

      One thing to check is locking:
      When UPDATE reads records, it acquires locks on the records being read (so that nobody changes the value while we're changing it). If the record doesn't match the WHERE, it is unlocked with unlock_row call.
      When we do a locking read and use ICP which filters out records - do we end up with the right kind of locks?

      Attachments

        Activity

          People

            Unassigned Unassigned
            psergei Sergei Petrunia
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.