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

History list is not shrunk unless there is a pause in the workload

    XMLWordPrintable

Details

    Description

      While testing MDEV-32050 and its follow-up changes MDEV-33009 and MDEV-33112, axel pointed out that the InnoDB history list is not being shrunk during a workload.

      Some initial debugging indicates that the purge_truncation_task (which was added in MDEV-32050) is being invoked but it is not doing anything. Also, the purge_sys.view is advancing; there are no old read views that would block the purge of history. Throttling the Sysbench workload for a few seconds would allow the history list to shrink immediately.

      Attachments

        1. 10.6-MDEV-33213.pdf
          107 kB
        2. 12x5.pdf
          58 kB
        3. 24x5_high_threads_pausing.pdf
          59 kB
        4. 24x5_high_threads.pdf
          56 kB
        5. 24x5.pdf
          59 kB
        6. no_pause.png
          no_pause.png
          36 kB
        7. with_pause.png
          with_pause.png
          47 kB

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              1 Vote for this issue
              Watchers:
              10 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.