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

AliSQL: [Performance] Issue #40 Optimize performance of semisync

    XMLWordPrintable

Details

    Description

      Description:
      		 
      ------------
      		 
      This diff includes:
      		 
          1. Make semisync buidin to completely remove overhead of plugin lock.
      		 
          2. Remove LOCK_log requirement from dump thread
      		 
          3. Now user threads can wait for ACK before innodb commit.
      		 
              add rpl_semi_sync_master_wait_point to control this behavior(AFTER_COMMIT/AFTER_SYNC)
      		 
          4. Add a new ACK thread to handle ACK from slave.
      		 
          5. The IO thread flushs master info only when ACK is needed
      		 
              add rpl_semi_sync_slave_delay_master to control this behavior
      		 
          6. Fix bug#70669, if sync_binlog = 1 ,then notify dump thread after fsync of binlog file.

      https://github.com/alibaba/AliSQL/commit/348783276913b0ad73d7a473498c0f8ea42ee9b0

      This patch makes the variable rpl_semi_sync_slave obsolete, which is why it was removed.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15238 rpl.perf_buildin_semisync_issue40 sporadically fails on BB

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30269 Remove rpl_semi_sync_[master,slave] plugin keyword usage in code

          • Major - Major loss of function.
          • Closed

          Activity

            People

              axel Axel Schwenke
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.