MariaDB 10.2.0 Release Notes

The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

Download | Release Notes | Changelog | Overview of 10.2

Release date: 18 Apr 2016

MariaDB 10.2 is the current development series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.

MariaDB 10.2.0 is an Alpha release.

Do not use alpha releases on production systems!

For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

Thanks, and enjoy MariaDB!

Notable Changes

This is the first alpha release in the series.

Notable changes of this release include:

Syntax:

• have been introduced. This release adds support for a limited set of functions, and the basic execution algorithm. Development continues to expand the set of supported functions and optimize the execution.

• The statement was introduced.

• New options for limiting resource usage and tls/ssl.

• New statement.

Scripts:

• Continuous binary log backup has been added to - .

• and mysqlbug have been removed - , .

Information Schema:

• Added an information schema plugin to report all user variables, which creates the - .

Variables:

• has been renamed to - .

• The server version can now be faked to work around dated applications that require a particular version string -

• is now an alias for slave_parallel_threads.

• New status variables , and .

EXPLAIN:

• now shows outer_ref_condition field which contains the condition that the(?) SELECT checks on each re-execution - .

• now shows sort_key field which shows the sort criteria used by filesort operation. ()

• EXPLAIN used to show incorrect information about how the optimizer resolved ORDER BY

Optimizations:

• Connection setup was made faster by moving creation of THD to new thread ()

Code:

• "fast mutexes" have been removed. These aren't faster than normal mutexes, and have been disabled by default for years - .

Notes

Do not use alpha releases on production systems!

• Repositories exist for 10.2, but because 10.2 is still alpha, it is not visible in the . To configure a 10.2 apt, yum, or zypper repository using the tool, simply select 10.1 and then when executing the instructions, change all occurrences of '10.1' to '10.2'.

• - APT 1.2.7 (and later) prefers SHA2 GPG keys and now prints warnings when a repository is signed using a SHA1 key. We have created a new SHA2 key for use with our Debian "sid" repository. When we add an Ubuntu 16.04 "xenial" repository, it will also use this new key.

  • The Key ID is: C74CD1D8

Changelog

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