What is MariaDB 10.2?
You are viewing an old version of this article. View
the current version here.
The most recent release of MariaDB 10.2 is:
MariaDB 10.2.44 Stable (GA) Download Now
Do not use alpha releases on production systems!
Contents
MariaDB 10.2 will be the next major development version.
The following lists the major new features in MariaDB 10.2:
Implemented Features
Syntax
- Window functions 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 computation.
- The SHOW CREATE USER statement was introduced.
- New CREATE USER options for limiting resource usage and tls/ssl.
- New ALTER USER statement.
Information Schema
- An information schema plugin to report all user variables, which creates the Information Schema USER_VARIABLES Table - MDEV-7331.
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 was a long-standing problem with roots back in MySQL. Now, after MDEV-8646 and related fixes, the problem doesn't exist anymore. (For test cases, see MDEV-7982, MDEV-8857, MDEV-7885, MDEV-326)
Optimizations
- Connection setup was was improved by moving creation of THD to new thread (MDEV-6150)
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
Scripts
- Continuous binary log backup has been added to mysqlbinlog - MDEV-8713.
- mysql_zap and mysqlbug have been removed - MDEV-7376, MDEV-8654.
Code
- "fast mutexes" have been removed. These aren't faster than normal mutexes, and have been disabled by default for years - MDEV-8111.
See also
- Plans for 10.x for features under consideration.
- 10.2 Features/fixes by vote (JIRA)
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.