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

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

    XMLWordPrintable

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

          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.