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

Create parameter to limit how many Page Store files can be created

    XMLWordPrintable

Details

    Description

      Galera has two types of on-disk files to manage write-sets, a ring buffer file, and an on-demand page store. The ring-buffer size is controlled by gcache.size, but when a transaction write-set is large enough to exceed the size of the ring-buffer page ('gcache.page_size = 128M;'), then independent pages are allocated to cache write-sets.

      An unusually large accumulation of on-demand page files can be caused by a combination of large transactions running on the cluster due to a data import or batch job at the time of an SST or if joiners are slow to process transactions.

      What can happen then is the disk fills up with gcache pages and SST hangs indefinitely until manual intervention happens.

      One thing that can save the disk from filling up in this case is to have a new variable that creates a global limit on size that can be written.

      Attachments

        Activity

          People

            manjot Manjot Singh (Inactive)
            manjot Manjot Singh (Inactive)
            Votes:
            1 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.