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

DDL operations very slow under macOS

    XMLWordPrintable

Details

    Description

      Under MacOS, MariaDB appears to be an order of magnitude slower than either linux or mysql8 when executing DDL statements. Executing the attached script (simply creating/dropping a table repeatedly) gives the following results:

      • macOS, mysql8: ~500ms
      • linux/docker, maria: similiar, ~500ms
      • macOS, MariaDB 11.2: about 5 seconds
      • macOS, MariaDB 10.11: about 5 seconds

      this makes running unit tests that do a lot of tight-loop DDL more or less unusable under mac/maria. Thanks for your time, LMK if you need any more info.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24105 restore innodb osx F_FULLFSYNC to full glory (innodb)

          • Major - Major loss of function.
          • Open

          Activity

            People

              serg Sergei Golubchik
              osheroff Ben Osheroff
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.