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

MariaDB 10.2 is the current major development version.

The following lists the major new features in MariaDB 10.2:

Implemented Features

Syntax

Trigger

Replication

Information Schema

EXPLAIN

  • EXPLAIN FORMAT=JSON now shows outer_ref_condition field which contains the condition that the(?) SELECT checks on each re-execution - MDEV-9 — Original code from Galina Shalygina652.
  • EXPLAN FORMAT=JSON now shows sort_key field which shows the sort criteria used by filesort operation. (commit 2078392)
  • EXPLAIN used to show incorrect information about how the optimizer resolved ORDER BY clause or Distinct. 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 made faster by moving creation of THD to new thread (MDEV-6150)
  • Pushdown conditions into non-mergeable views/derived tables (MDEV-9197). — Original code from Galina Shalygina

Compatibility

Variables

For a list of all new variables, see System Variables Added in MariaDB 10.2 and Status Variables Added in MariaDB 10.2. These include:

Scripts

Code

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

List of all MariaDB 10.2 releases

See also

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.