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

LSN allocation is a bottleneck

Details

    Description

      MySQL #WL10310 optimizes the redo log(unlock and write concurrently). Does MariaDB plan to optimize redo log?

      Reference material - https://dev.mysql.com/blog-archive/mysql-8-0-new-lock-free-scalable-wal-design/

      Attachments

        1. 1.sysbench_rw_128_QPS.png
          34 kB
          Debarun Banerjee
        2. 2.sysbench_rw_128_LSN.png
          22 kB
          Debarun Banerjee
        3. 3.sysbench_rw_128_Free_Page.png
          21 kB
          Debarun Banerjee
        4. 4.sysbench_rw_128_Purge_History_Length.png
          24 kB
          Debarun Banerjee
        5. mdev-21923b.PNG
          23 kB
          Steve Shaw
        6. mdev-21923c.PNG
          8 kB
          Steve Shaw

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36760 log_t::append_prepare_wait(): Bogus assertion ‘… < buf_size’

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-14425 Change the InnoDB redo log format to reduce write amplification

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14462 Confusing error message: ib_logfiles are too small for innodb_thread_concurrency=0

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27774 Reduce scalability bottlenecks in mtr_t::commit()

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33515 log_sys.lsn_lock causes excessive context switching

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36159 mariabackup failed after upgrade 10.11.10

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled
          links to

          Web Link MySQL 8.0: New Lock free, scalable WAL design

          Web Link WL#10310: Redo log optimization: dedicated threads and concurrent log buffer

          Activity

            People

              marko Marko Mäkelä
              yaojiapeng peng
              Votes:
              2 Vote for this issue
              Watchers:
              12 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.