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

Mysqldump 2-3 times slower since MariaDB upgrade to 10.1.29

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.1.29
    • N/A
    • Scripts & Clients
    • None
    • CentOS 7.4.1708 (VMWare)
      45GB RAM
      550GB disk space
      8vCPU
      innodb tables
      2 production servers upgraded from 10.1.15 to 10.1.29
    • 10.1.32

    Description

      We upgraded 2 of our production database servers to 10.1.29 (from 10.1.15). We also updated some other yum packages at the same time. After the upgrade, the nightly mysqldump backup time has increased from around 4 hours and 15 minutes to 14 hours and 40 minutes (3 times increase) on our first database server and from 6 hours and 30 minutes to 13 hours and 40 minutes (2 times increase) on our second database server.

      Normal database performance (sql query times) was not visibly impacted.

      We use the following command for our mysqldumps:

      echo 'show databases' | /usr/bin/mysql --defaults-extra-file=<file> | grep -v -f <file> | while read DB; do
        /usr/bin/mysqldump --defaults-extra-file=<file> --routines --events $DB > <file>.sql
      

      Attachments

        Activity

          People

            axel Axel Schwenke
            stijn Stijn
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.