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 the What is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
Notable Changes
This is the first alpha release in the MariaDB 10.2 series.
Notable changes of this release include:
Syntax:
- Window functions 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 SHOW CREATE USER statement was introduced.
- New CREATE USER options for limiting resource usage and tls/ssl.
- New ALTER USER statement.
- New reserved-words: OVER and RECURSIVE. These can no longer be used as identifier-names without being quoted.
Scripts:
- Continuous binary log backup has been added to mysqlbinlog - MDEV-8713.
- mysql_zap and mysqlbug have been removed - MDEV-7376, MDEV-8654.
Information Schema:
- Added an information schema plugin to report all user variables, which creates the Information Schema USER_VARIABLES Table - MDEV-7331.
Variables:
- aria_recover has been renamed to aria_recover_options - MDEV-8542.
- The server version can now be faked to work around dated applications that require a particular version string - MDEV-7780
- slave_parallel_workers is now an alias for slave_parallel_threads.
- New status variables com_alter_user, com_multi and com_show_create_user.
EXPLAIN:
- EXPLAIN FORMAT=JSON now shows
outer_ref_condition
field which contains the condition that the(?) SELECT checks on each re-execution - MDEV-9652. - EXPLAN FORMAT=JSON now shows
sort_key
field which shows the sort criteria used byfilesort
operation. (commit 2078392)
- EXPLAIN used to show incorrect information about how the optimizer resolved
ORDER BY
clause orDistinct
. This is a long-standing problem coming from MySQL. Now, after MDEV-8646 and related fixes, the problem doesn't exist anymore. (For testcases, see MDEV-7982, MDEV-8857, MDEV-7885)
Optimizations:
- Connection setup was made faster by moving creation of THD to new thread (MDEV-6150)
Code:
- "fast mutexes" have been removed. These aren't faster than normal mutexes, and have been disabled by default for years - MDEV-8111.
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 repository configuration tool. 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'.
- MDEV-9781 - 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
- The full fingerprint of the new key is:
177F 4010 FE56 CA33 3630 0305 F165 6F24 C74C D1D8
- The key can be added using the following command:
- The Key ID is:
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
Changelog
For a complete list of changes made in MariaDB 10.2.0, with links to detailed information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More
information can be found on the
Distributions which Include MariaDB
page.