The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-12-24. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB 10.2.9 Release Notes

The most recent release of MariaDB 10.2 is:
MariaDB 10.2.44 Stable (GA) Download Now

Download Release Notes Changelog Overview of 10.2

Release date: 27 Sep 2017

MariaDB 10.2 is the current stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.

MariaDB 10.2.9 is a Stable (GA) release.

For an overview of MariaDB 10.2 see the What is MariaDB 10.2? page.

Thanks, and enjoy MariaDB!

Notable Changes

Updates

  • TokuDB updated to 5.6.37-82.2

Bug Fixes

  • MDEV-13899: IMPORT TABLESPACE may corrupt ROW_FORMAT=REDUNDANT tables
  • MDEV-13847: Allow ALTER TABLE…ADD SPATIAL INDEX…ALGORITHM=INPLACE
  • MDEV-13678: DELETE with CASCADE takes a long time when Galera is enabled
  • MDEV-13826: CREATE FULLTEXT INDEX on encrypted table fails
  • MDEV-13318: Crash recovery failure after the server is killed during innodb_encrypt_log startup
  • MDEV-13488: InnoDB writes CRYPT_INFO even though encryption is not enabled (fixes upgrades from 5.5 to 10.1)
  • MDEV-13437: InnoDB fails to return error for XA COMMIT or XA ROLLBACK in read-only mode
  • MDEV-13637: InnoDB change buffer housekeeping can cause redo log overrun and possibly deadlocks
  • MDEV-13534: InnoDB STATS_PERSISTENT fails to ignore garbage delete-mark flag on node pointer pages (caused by MDEV-12698)
  • MDEV-13606: XA PREPARE transactions should survive innodb_force_recovery=1 or 2
  • MDEV-13167: InnoDB key rotation is not skipping unused pages
  • MDEV-12988: Mariabackup fails if innodb_undo_tablespaces>0
  • MDEV-13471: Test failure on innodb.log_file_size,4k (fixes Galera when using innodb_page_size=4k)
  • MDEV-13684: InnoDB race condition between fil_crypt_thread and btr_scrub_init

Backup

Encryption

  • Temporary files created by merge sort and row log are encrypted if innodb_encrypt_log is set to 1, regardless of whether the table encrypted or not (MDEV-12634).

Variables

The following variables have been deprecated, and will be removed in a future release (MDEV-13674):

Notes

For a complete list of changes made in MariaDB 10.2.9, with links to detailed information on each push, see the changelog.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

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.