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

AliSQL: [perf] Issue#12 OPTIMIZE INNODB READ-ONLY WORKLOAD

Details

    Description

      Description:
      ------------
      These path introduces several improvement for InnoDB read-only
      workload:
       
      1. Remove trx_sys_t::ro_trx_list, all transaction will start with
      read only mode, and change to rw mode while encountering DML
      statement. For more details, refer to mysql worklog WL#6047.
       
      2. Read view object is cached for read-only statement if no rw
      statement happens during two read only statements of the same
      session.
       
      3. Ignore acquiring lock_sys mutex contention while commiting
      read only transaction.
      

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

      Attachments

        Activity

          plinux, I believe this is backport from InnoDB 5.7. At least we have most of these changes in 10.2 and the rest are not applicable as is. Could you check if there're still anything to merge here?

          svoj Sergey Vojtovich added a comment - plinux , I believe this is backport from InnoDB 5.7. At least we have most of these changes in 10.2 and the rest are not applicable as is. Could you check if there're still anything to merge here?
          plinux Lixun Peng added a comment -

          svoj Weixiang comfirmed if MariaDB merged InnoDB 5.7, then this issue is unnecessary.

          plinux Lixun Peng added a comment - svoj Weixiang comfirmed if MariaDB merged InnoDB 5.7, then this issue is unnecessary.

          Closing per plinux comment.

          svoj Sergey Vojtovich added a comment - Closing per plinux comment.

          People

            plinux Lixun Peng
            svoj Sergey Vojtovich
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.