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

MariaDB 10.6.x slower mysqldump etc.

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.6.7, 10.6.9
    • N/A
    • Backup
    • #server1 - CentOS 7.9, DirectAdmin 1.642, MariaDB 10.6.9
      #server2 - CentOS 8.5 (AlmaLinux 8.5), DirectAdmin 1.642, MariaDB 10.6.7

    Description

      Hi,
      We have over 2000 databases (innodb)

      In April 2022 we moved from #server 1 to #server 2 (which is few times faster than #server1) and we have some troubles:

      1. On #server1 there was mariadb 10.4.x and any backups/upgrades were creating really fast (30-60 seconds)

      2. We uploaded backups to #server2 but installed there MariaDB 10.6.7 and.... dumping databases is taking ~60-70 minutes + after for example do command on SSH like "service mariadb restart" is making some crash recovery etc.... which is taking 1-2 hours also.... on #server1 with mariadb 10.4.x there wasn't any problems like that, I could restart mariadb anytime and there wasn't any problems...

      3. Today (20.08.2022) I logged to #server1 and thinking "hmmm maybe i'll upgrade mariadb 10.4.x to 10.6.x to check if anything will happened like in #server2" - and what? If there were mariadb 10.4.x mysqldump make dumps in 30-60seconds (2100 databases).... after successfully upgrade to mariadb 10.6.x, I tried to reinstall mariadb from 10.6.9 to 10.6.9 (to check how fast is mysqldump) and that stupid mariadb 10.6.9 is doing mysqldump like 1 database every 2 seconds...so 2100 databases give us 60-70 minutes - why it's so much slower than 10.4.x? What should I do? It's terrible problem for us and I don't know how to fix that.... I'm also scared to upgrade mariadb 10.6.7 to 10.6.9 on #server2 (production server) because of recovery crashes after restart etc.

      Any ideas??

      Attachments

        Issue Links

          Activity

            emil89 Emilian Lanowski created issue -
            emil89 Emilian Lanowski made changes -
            Field Original Value New Value
            Description Hi,
            We have over 2000 databases (innodb)

            In April 2022 we moved from #server 1 to #server 2 (which is few times faster than #server1) and we have some troubles:

            1. On #server1 there was mariadb 10.4.x and any backups/upgrades were creating really fast (30-60 seconds)

            2. We uploaded backups to #server2 but installed there MariaDB 10.6.7 and.... dumping databases is taking few hours + after for example do command like "service mariadb restart" is making some crash recovery etc.... which is taking 1-2 hours also.... on #server1 with mariadb 10.4.x there wasn't any problems like that, I could restart mariadb anytime and there wasn't any problems...

            3. Today (20.08.2022) I logged to #server1 and thinking "hmmm maybe i'll upgrade mariadb 10.4.x to 10.6.x to check if anything will happened like in #server2" - and what? If there were mariadb 10.4.x mysqldump make dumps in 30-60seconds (2100 databases).... after successfully upgrade to mariadb 10.6.x, I tried to reinstall mariadb from 10.6.9 to 10.6.9 (to check how fast is mysqldump) and that stupid mariadb 10.6.9 is doing mysqldump like 1 database every 2 seconds...so 2100 databases give us 60-70 minutes - why it's so much slower than 10.4.x? What should I do? It's terrible problem for us and I don't know how to fix that.... I'm also scared to upgrade mariadb 10.6.7 to 10.6.9 on #server2 (production server) because of recovery crashes after restart etc.

            Any ideas??
            Hi,
            We have over 2000 databases (innodb)

            In April 2022 we moved from #server 1 to #server 2 (which is few times faster than #server1) and we have some troubles:

            1. On #server1 there was mariadb 10.4.x and any backups/upgrades were creating really fast (30-60 seconds)

            2. We uploaded backups to #server2 but installed there MariaDB 10.6.7 and.... dumping databases is taking ~60-70 minutes + after for example do command on SSH like "service mariadb restart" is making some crash recovery etc.... which is taking 1-2 hours also.... on #server1 with mariadb 10.4.x there wasn't any problems like that, I could restart mariadb anytime and there wasn't any problems...

            3. Today (20.08.2022) I logged to #server1 and thinking "hmmm maybe i'll upgrade mariadb 10.4.x to 10.6.x to check if anything will happened like in #server2" - and what? If there were mariadb 10.4.x mysqldump make dumps in 30-60seconds (2100 databases).... after successfully upgrade to mariadb 10.6.x, I tried to reinstall mariadb from 10.6.9 to 10.6.9 (to check how fast is mysqldump) and that stupid mariadb 10.6.9 is doing mysqldump like 1 database every 2 seconds...so 2100 databases give us 60-70 minutes - why it's so much slower than 10.4.x? What should I do? It's terrible problem for us and I don't know how to fix that.... I'm also scared to upgrade mariadb 10.6.7 to 10.6.9 on #server2 (production server) because of recovery crashes after restart etc.

            Any ideas??
            serg Sergei Golubchik made changes -
            Epic/Theme Performance
            serg Sergei Golubchik made changes -
            Status Open [ 1 ] Needs Feedback [ 10501 ]
            emil89 Emilian Lanowski made changes -
            Comment [ But it's two different servers and two different system versions so... I guess it's not only "my setup" ? :D

            What do you mean by "show variables" ?
            I have to log in SSH and log in to mariadb and do that command? ]
            serg Sergei Golubchik made changes -
            Status Needs Feedback [ 10501 ] Open [ 1 ]
            serg Sergei Golubchik made changes -
            marko Marko Mäkelä made changes -
            Status Open [ 1 ] Needs Feedback [ 10501 ]
            serg Sergei Golubchik made changes -
            Fix Version/s N/A [ 14700 ]
            Resolution Incomplete [ 4 ]
            Status Needs Feedback [ 10501 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            danblack Daniel Black made changes -
            valerii Valerii Kravchuk made changes -
            Resolution Incomplete [ 4 ]
            Status Closed [ 6 ] Stalled [ 10000 ]
            marko Marko Mäkelä made changes -
            Status Stalled [ 10000 ] Needs Feedback [ 10501 ]
            serg Sergei Golubchik made changes -
            Resolution Incomplete [ 4 ]
            Status Needs Feedback [ 10501 ] Closed [ 6 ]

            People

              Unassigned Unassigned
              emil89 Emilian Lanowski
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.