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

wsrep_sst_method = mariabackup very slow when reading sparse files

    XMLWordPrintable

Details

    Description

      when page compression is enabled SST using mariabackup is only reading/transferring data with 200 Mbit for .ibd files with PAGE_COMPRESSED=1 , while running at about 5Gbit for uncompressed files.

      So, I assume sparse files are not handled correct. Time for adding a node to a cluster with a 20GB database file took >15 minutes. For a 1TB database file size it will therefore take >> 12 hours instead of less than 1h, making a rotation of nodes during maintenance a task for multiple days, if not running into timeouts in between. Basically unusable for production.

      Attachments

        Activity

          People

            thiru Thirunarayanan Balathandayuthapani
            it-admin@gleif.org Christian Schulze
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.