Changes & Improvements in MariaDB 10.2

MariaDB 10.2 is a previous major stable version. The first stable release was in May 2017, and it will be supported until May 2022.

For details on upgrading from MariaDB 10.1, see Upgrading from MariaDB 10.1 to 10.2.

The following lists the major new features in MariaDB 10.2:

Implemented Features

InnoDB as Default

Syntax / General Features

Incompatible Changes

  • TokuDB has been split into a separate package, mariadb-plugin-tokudb.
  • SQL_MODE has been changed; in particular, NOT NULL fields with no default will no longer fall back to a dummy value for inserts which do not specify a value for that field.
  • Replication from legacy MySQL servers may require setting binlog_checksum to NONE.
  • New reserved words: OVER, RECURSIVE, and ROWS.

Triggers

Replication / Binary Log

GeoJSON / JSON

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-9652)
  • 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, condition-pushdown-into-derived-table-optimization ) — Original code from Galina Shalygina
  • ANALYZE TABLE has been re-implemented so as not to lock the entire table when collecting engine independent statistics (MDEV-7901)
  • Internal CRC32 routines use the optimized implementation on Power8 — MDEV-9872
  • Table cache can automatically partition itself as needed to reduce the contention (MDEV-10296)

Compatibility

  • 88 new NO PAD collations added. In NO PAD collations, end spaces 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

System Variables

For a list of all new system variables, see System Variables Added in MariaDB 10.2. Variable changes include:

Status Variables

For a list of all new status variables, see Status Variables Added in MariaDB 10.2.

Scripts

Other Changes

  • Added support for OpenSSL 1.1 and LibreSSL (MDEV-10332)
  • Persistent AUTO_INCREMENT for InnoDB (MDEV-6076)
  • 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)
  • Old GPL client library is gone; now MariaDB Server comes with the LGPL Connector/C client library (MDEV-9055)
  • MariaDB is no longer compiled with jemalloc
  • TokuDB is now a separate package, not part of the server RPM (because TokuDB still needs jemalloc).
  • Upgrading to a new major release no longer requires setting innodb_fast_shutdown to 0. Omitting it can make the upgrade process a lot faster. (MDEV-12289)

Comparison with MySQL

List of All MariaDB 10.2 Releases

DateReleaseStatusRelease NotesChangelog
11 Sep 2019MariaDB 10.2.27Stable (GA)Release NotesChangelog
31 Jul 2019MariaDB 10.2.26Stable (GA)Release NotesChangelog
17 Jun 2019MariaDB 10.2.25Stable (GA)Release NotesChangelog
9 May 2019MariaDB 10.2.24Stable (GA)Release NotesChangelog
25 Mar 2019MariaDB 10.2.23Stable (GA)Release NotesChangelog
11 Feb 2019MariaDB 10.2.22Stable (GA)Release NotesChangelog
2 Jan 2019MariaDB 10.2.21Stable (GA)Release NotesChangelog
24 Dec 2018MariaDB 10.2.20Stable (GA)Release NotesChangelog
19 Nov 2018MariaDB 10.2.19Stable (GA)Release NotesChangelog
25 Sep 2018MariaDB 10.2.18Stable (GA)Release NotesChangelog
14 Aug 2018MariaDB 10.2.17Stable (GA)Release NotesChangelog
26 Jun 2018MariaDB 10.2.16Stable (GA)Release NotesChangelog
17 May 2018MariaDB 10.2.15Stable (GA)Release NotesChangelog
27 Mar 2018MariaDB 10.2.14Stable (GA)Release NotesChangelog
13 Feb 2018MariaDB 10.2.13Stable (GA)Release NotesChangelog
4 Jan 2018MariaDB 10.2.12Stable (GA)Release NotesChangelog
28 Nov 2017MariaDB 10.2.11Stable (GA)Release NotesChangelog
31 Oct 2017MariaDB 10.2.10Stable (GA)Release NotesChangelog
27 Sep 2017MariaDB 10.2.9Stable (GA)Release NotesChangelog
18 Aug 2017MariaDB 10.2.8Stable (GA)Release NotesChangelog
12 Jul 2017MariaDB 10.2.7Stable (GA)Release NotesChangelog
23 May 2017MariaDB 10.2.6Stable (GA)Release NotesChangelog
5 Apr 2017MariaDB 10.2.5RCRelease NotesChangelog
17 Feb 2017MariaDB 10.2.4RCRelease NotesChangelog
24 Dec 2016MariaDB 10.2.3BetaRelease NotesChangelog
27 Sep 2016MariaDB 10.2.2BetaRelease NotesChangelog
4 Jul 2016MariaDB 10.2.1AlphaRelease NotesChangelog
18 Apr 2016MariaDB 10.2.0AlphaRelease NotesChangelog

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.