Changes & Improvements in MariaDB 10.3

MariaDB 10.3 is the previous major stable version. The first stable release was in May 2018, and it will be supported until May 2023.

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

MariaDB Server 10.3 is included in MariaDB TX 3.0. Watch the webinar recording to learn more about the new features included in this release.

The following lists the major new features in MariaDB 10.3:

Implemented Features

Syntax / General Features

Compatibility

Compression

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

Optimizer/Performance

Storage Engines

InnoDB

Spider

The Spider storage engine has been updated to 3.3.13. The partitioning storage engine has been updated to support all the new Spider features including:

Most of the features were done as part of MDEV-7698.

OQGRAPH

  • OQGraph now supports the "leaves" algorithm (MDEV-11271) — contribution by Heinz Wiesinger

Partition Engine

  • Numerous improvements for the partition engine (MDEV-7698) — contribution by Kentoku Shiba
    • Full text support.
    • Multi-range-read (Gives better performance when handling multiple ranges).
    • Support for condition pushdown.
    • HANDLER support
  • Aggregate pushdown
  • Bulk update/delete

Information Schema

Logging

Replication

  • Per-engine mysql.gtid_slave_pos tables (MDEV-12179) — Implemented by Kristian Nielsen funded by Booking.com.

Data Type API

10.3 continues refactoring for the data type API started in 10.2, which will make it possible to have user data type plugins. This work is still in progress (see MDEV-4912 for the current status and subtasks). Most of the task in this category do not change the server behavior. Some tasks do have a visible effect.

Idle Transactions

Connections with idle transactions can be automatically killed after a specified time period by means of the idle_transaction_timeout, idle_readonly_transaction_timeout and idle_write_transaction_timeout system variables.

System Variables

For a list of all new variables, see System Variables Added in MariaDB 10.3 and Status Variables Added in MariaDB 10.3.

Comparison with MySQL

List of All MariaDB 10.3 Releases

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.