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

Mariabackup: huge speed degradation

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3.18
    • 10.3
    • mariabackup
    • None
    • Debian 10.1

    Description

      Hello

      We are trying to make a backup to setup one more slave, and we are using the `mariabackup` for this. We do not have enough space on the first slave server, so we are using a streaming (xbstream) backup to second slave. The database is about 1.5TB.
      The problem is: the backup process starts without problems. But after some hours the backup speed reduced hundreds of times. It may takes days!
      To exclude problems from the `mbstream` side, we connected the NFS share and started up without xbstream. And we saw the same picture:

      The first backup was started with the command:

      mariabackup --backup --slave-info --safe-slave-backup --user=root --target-dir=/var/lib/mysql-nfs --rsync --parallel=8 2> dump-nfs.log
      

      When we found that the rate has fallen, we restart the process with some small changes:

      mariabackup --backup --slave-info --safe-slave-backup --innodb_checksum_algorithm=innodb --user=root --target-dir=/var/lib/mysql-nfs --rsync --parallel=8 2> dump-nfs.log
      

      As you can see, the backup process begins at a good speed, but after a while the speed drops a hundred times.
      May it be related to the InnoDB table compression, which we are using? How can we avoid this behavior?

      Attachments

        Activity

          People

            vlad.lesin Vladislav Lesin
            banzayats Vadim Kalsin
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.