Jump to content

MariaDB 10.2 Stable

Recommended Posts


MariaDB 10.2.6 is stable GA

MariaDB 10.2 is the current major stable version. It will be supported until May 2022.

The following lists the major new features in MariaDB 10.2:

Implemented Features

InnoDB as default

  • InnoDB is now the default storage engine. Until MariaDB 10.1, MariaDB used the XtraDB storage engine as default. XtraDB in 10.2 is not up to date with the latest features of InnoDB and cannot be used. The main reason for this change is that most of the important features of XtraDB are nowadays implemented in InnoDB . As the MariaDB team is doing a lot more InnoDB development than ever before, we can't anymore manage updating two almost identical engines. The InnoDB version in MariaDB contains the best features of MySQL InnoDB and XtraDB and a lot more. As the InnoDB on disk format is identical to XtraDB's this will not cause any problems when upgrading to MariaDB 10.2.

Syntax / general features


Replication / binary log


Information Schema


  • 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)


  • 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
  • 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)


  • 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)


System variables

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

New status variables


Other changes

  • Added support for OpenSSL 1.1 and LibreSSL (MDEV-10332)
  • Persistent AUTO_INCREMENT for InnoDB (MDEV-6076)
  • "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)


Link to comment
Share on other sites

  • 3 months later...
  • 3 weeks later...


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...