Performance improvements

• Segmented key cache for (MDEV-24)

  • system variable

• MDL scalability improvements (MDEV-19749)

• Parallel replication for Galera replicas (MDEV-20065)

• Buffered logging for ()

• Faster distance calculations via extrapolation ()

Compatibility features

• caching_sha2_password plugin (MDEV-9804)

• ( + ) for outer join syntax (MDEV-13817)

• Add variable, (MDEV-18983)

• Associative arrays: DECLARE TYPE .. TABLE OF .. INDEX BY (MDEV-34319)

• will now by default issue a warning if the user has active sessions, or fail in ()

• Optimizer hints: [NO_]JOIN_INDEX, [NO_]GROUP_INDEX, [NO_]ORDER_INDEX, [NO_]INDEX ()

• Optimizer hints: [NO_]SPLIT_MATERIALIZED ()

• Optimizer hints: [NO_]DERIVED_CONDITION_PUSHDOWN, [NO_]MERGE ()

Miscellaneous

• Add option to not collect statistics for long char/varchars (MDEV-36536)

• Retry applying of write sets on galera nodes (MDEV-36077)

• now supports wildcards with the -L or --wildcards option (MDEV-21376)

• Per-table unique FOREIGN KEY constraint names ()

• Support for functional indexes in GROUP/ORDER BY ()

• Include definitions of tables and views in the optimizer trace ()

Changelog

For a complete list of changes made in MariaDB 12.1.1, with links to detailed information on each push, see the changelog.

Performance improvements

• Segmented key cache for (MDEV-24)

  • The new system variable defines how many segments are used, default is 1, maximum 128

• MDL scalability improvements (MDEV-19749)

• Asyncronous replication between two can now use parallel replication

  • This is managed by the new system variable ()

• The now supports buffered logging

  • The size of the buffer is defined using the new system variable ()

• Faster distance calculations via extrapolation ()

Compatibility features

• New authentication plugin for MySQL compatibility (MDEV-9804)

• (MDEV-13817)

• Associative arrays: DECLARE TYPE .. TABLE OF .. INDEX BY (MDEV-34319) (blog post)

• will now by default issue a warning if the user has active sessions, or fail in Oracle mode (MDEV-35617)

• : , , , ()

• : ()

• : , ()

Miscellaneous

• Retry applying of write sets on Galera nodes (MDEV-36077)

  • Controlled through the system variable

• now supports with the -L or --wildcards option (MDEV-21376)

• constraint names no longer need to be unique per database, only per table () ()

• Support for functional indexes in GROUP/ORDER BY ()

• Include definitions of tables and views in the ()

  • system variable.

Changelog

For a complete list of changes made in MariaDB 12.1.2, with links to detailed information on each push, see the changelog.

_{This page is licensed: CC BY-SA / Gnu FDL}

_{This page is licensed: CC BY-SA / Gnu FDL}

_{This page is licensed: CC BY-SA / Gnu FDL}