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

UNDO logs still growing for write-intensive workloads

Details

    Description

      The issue with growing innodb_history_length (aka growing disk footprint of UNDO logs) that was originally reported in MDEV-29401 is still not solved for certain workloads.

      Attachments

        1. purge-bottleneck-5-10000-128-40s-50s.svg
          173 kB
          Marko Mäkelä
        2. screenshot-1.png
          28 kB
          Larry Adams
        3. screenshot-2.png
          36 kB
          Larry Adams
        4. screenshot-3.png
          47 kB
          Larry Adams

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-16260 Scale the purge effort according to the workload

          • Major - Major loss of function.
          • Open
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32788 CMAKE_BUILD_TYPE=Debug build failure with SUX_LOCK_GENERIC

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33819 The purge of committed history is mis-parsing some log

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34515 Contention between secondary index UPDATE and purge due to large innodb_purge_batch_size

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-17598 InnoDB index option for per-record transaction ID

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26356 Performance regression after dict_sys.mutex removal

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29401 InnoDB history list length increased in 10.6 compared to 10.5 for the same load

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30628 10.6 performance regression with sustained high-connection write-only OLTP workload (55-80% degradation)

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

          Task - A task that needs to be done. MDEV-32573 Document UNDO logs still growing for write-intensive workloads

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32588 InnoDB may hang when running out of buffer pool

          • 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-32820 Race condition between trx_purge_free_segment() and trx_undo_create()

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32873 Test innodb.innodb-index-online occasionally fails

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33213 History list is not shrunk unless there is a pause in the workload

          • 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-34259 Optimization in row_purge_poss_sec Function for Undo Purge Process

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35895 purge_sys_t::close_and_reopen() can busy loop for a long time

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-14602 Reduce malloc()/free() usage in InnoDB

          • Major - Major loss of function.
          • Confirmed

          Task - A task that needs to be done. MDEV-18746 Reduce the amount of mem_heap_create() or malloc()

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26356 Performance regression after dict_sys.mutex removal

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32622 [mariadb-galera] The undo log is very large, how can there be fewer undo log logs

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33137 Assertion `end_lsn == page_lsn' failed in recv_recover_page

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

          Page Loading...

          Activity

            Transition Time In Source Status Execution Times
            Marko Mäkelä made transition -
            Open In Progress
            		20d 5h 30m 1
            Marko Mäkelä made transition -
            In Progress In Testing
            		23d 2h 6m 1
            Matthias Leich made transition -
            In Testing Stalled
            		10d 17h 15m 1
            Marko Mäkelä made transition -
            Stalled In Testing
            		54m 25s 1
            Marko Mäkelä made transition -
            In Testing Closed
            		20h 46m 1

            People

              marko Marko Mäkelä
              axel Axel Schwenke
              Votes:
              3 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.