Software update: MariaDB 10.2.16

MariaDB originated as a fork of MySQL after it was acquired by Oracle in 2009/2010. For an overview of the differences between MariaDB and MySQL you can visit: this one and this one pages right. MariaDB is a powerful open source database server, which is especially popular as a website and forum database. The developers have released version 10.2.16 in the stable branch with the following announcement:

MariaDB 10.2.16 Release Notes

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.16 is a Stable (GA) release.

Notable Changes

• MyRocks is now Stable (GA)
• MDEV-13779 – InnoDB fails to shut down purge workers, causing hang
• MDEV-16267 – Wrong INFORMATION_SCHEMA.INNODB_BUFFER_PAGE.TABLE_NAME
• MDEV-13834 – Upgrade failure from 10.1 innodb_encrypt_log
• MDEV-16283 – ALTER TABLE…DISCARD TABLESPACE still takes long on a large buffer pool
• MDEV-16376 – ASAN: heap-use-after-free in gcol.innodb_virtual_debug
• MDEV-15824 – innodb_defragment=ON trumps innodb_optimize_fulltext_only=ON in OPTIMIZE TABLE
• MDEV-16124 – fil_rename_tablespace() times out and crashes server during table-rebuilding ALTER TABLE
• MDEV-16416 – Crash on IMPORT TABLESPACE of a ROW_FORMAT=COMPRESSED table
• MDEV-16456 – InnoDB error “returned OS error 71” complains about wrong path
• MDEV-13103 – Deal with page_compressed page corruption
• MDEV-16496 – Mariabackup: Implement –verbose option to instrument InnoDB log apply
• MDEV-16087 – Inconsistent SELECT results when query cache is enabled
• MDEV-15114 – ASAN heap-use-after-free in mem_heap_dup or dfield_data_is_binary_equal (fix for indexed virtual columns)
• As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Ubuntu 17.10 Artful

changelog

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