maria:bb-10.2-danielblack-MDEV-23326-timezone-initialization-slow-on-aria

Last commit made on 2020-11-13
Get this branch:
git clone -b bb-10.2-danielblack-MDEV-23326-timezone-initialization-slow-on-aria https://git.launchpad.net/maria

Branch merges

Branch information

Name:
bb-10.2-danielblack-MDEV-23326-timezone-initialization-slow-on-aria
Repository:
lp:maria

Recent commits

6cffdd1... by Daniel Black

fix mysql_install_db

5862393... by Daniel Black

MDEV-23326: mysql_install_db - fix Debian patch

0d2029f... by Daniel Black

mysql_install_db test cases

Includes tests for MDEV-23494 and MDEV-23326

1b640fb... by Daniel Black

MDEV-23494: mysql_install_db add fd 3 to bootstrap

b586c8f... by Daniel Black

MDEV-23326: speed timezone loading on mysql_tzinfo_to_sql

LOCK TABLES on aria tables is a way to ensure fdatasync
happens at UNLOCK TABLES, so we use this to make the
timezone loading faster.

27c3b6e... by Daniel Black

MDEV-23494: mysql_install_db add --auth-root-password-env option

cfe0f1b... by Daniel Black

MDEV-23494: mysql_install_db add --auth-root-hostname option

This allows an install script to be specific on the hostname
for the root user.

8ecf8dc... by Daniel Black

MDEV-23326: mysql_install_db with --timezones option

743068c... by Daniel Black

MDEV-23495: mysql_install_db can run from srcdir

Backport part of 47334649752e109360c9e22b8f8019a0df51fe93

mysql_install_db will now automatically detect if run from srcdir

7ab972b... by Daniel Black

MDEV-23326: mysql_tzinfo_to_sql add --skip-wsrep-check

Several mysql_tzinfo_to_sql behaviours are dependent on
checking the wsrep_on==ON specificly for galera initialization
of timezone (or skipping of them).

There are two scenarios where the lack of the checking would
be very useful.

With the --skip-write-binary-log, binary logs are explictly
skipped, allowing for loading in classical replication scenarios.

Without the --skip-write-binary-log, innodb can be used for
loading the timezone tables signficantly faster than Aria
with TRANSACTIONAL=1.

The lack of checking the wsrep status also make it possible
to use mysql_tzinfo_to_sql in the mysqld --bootstrap input
allowing for a single initialization of all system tables.

In cleaning up part of MDEV-18778, when changing back from InnoDB
to MyISAM, include the ORDER BY, and don't include this if only
loading leap seconds.