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

mysql_tzinfo_to_sql under innodb is slow

    XMLWordPrintable

Details

    Description

      When MDEV-18778 added ENGINE=InnoDB to allow timezone to be replicated via galera the obvious extension of wrapping the inserts in a transaction was missed.

      As a result an innodb initialization in a stand alone mode takes ~27 seconds instead of 1.2 seconds (timing per MDEV-23326)

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18778 mysql_tzinfo_to_sql does not work correctly in MariaDB Galera

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23326 aria TRANSACTIONAL=1 significantly slow on timezone intialisation (was: time zone initialision significantly slower in 10.4 compared to 10.3 (myisam))

          • Major - Major loss of function.
          • Closed
          links to

          Web Link mysql-5.7.7

          Activity

            People

              danblack Daniel Black
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.