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

[perf] #57 Preferred to chose index with auto_increment column when slave apply binlog

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Replication

    Description

        Description
        -----------
        In row binlog format, slave chose index when apply binlog use such order:
        1) primary key
        2) unique key without null columns
        3) normal index or unique key with null columns
       
        Actually, in situation 3 we should chose index with auto_increment column
        first, after this patch, the new order is
        1) primary key
        2) unique key without null columns
        3) normal index with auto_increment columns
        4) normal index without auto_increment columns or unique key with null columns
      
      

      https://github.com/alibaba/AliSQL/commit/9d1a800eea8df864ea28f1018d895cfd271a3142

      Attachments

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              anel Anel Husakovic
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.