The most recent release of MariaDB 10.2 is:
MariaDB 10.2.4 RC 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 / binary log

GeoJSON / JSON

Information Schema

EXPLAIN

  • 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

  • NO PAD collations, which means that end space are significant in comparisons (MDEV-9711). — Original code from Daniil Medvedev
  • MariaDB now works when started with a MySQL 5.7.6+ data directory. (MDEV-11170)

CONNECT

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

Other changes

  • Persistent AUTO_INCREMENT for InnoDB (MDEV-6076).
  • Support COM_RESET_CONNECTION (MDEV-10340).
  • Support COM_RESET_CONNECTION (MDEV-10340).
  • "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...
Loading