MariaDB 10.3.3 Release Notes

The most recent release of MariaDB 10.3 is:MariaDB 10.3.39 Stable (GA) Download Now

DownloadRelease NotesChangelogOverview of 10.3

Release date: 23 Dec 2017

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

MariaDB 10.3.3 is a Beta release.

For an overview of MariaDB 10.3 see theWhat is MariaDB 10.3? page.

Thanks, and enjoy MariaDB!

Notable Changes

This is the first beta release in the MariaDB 10.3 series.

Notable changes of this release include:

General

• Table Value Constructors. As a result, the VALUES function has been renamed to VALUE() (MDEV-12172) — GSoC 2017 project by Galina Shalygina

• Transform [NOT] IN predicate with long list of values INTO [NOT] IN subquery (MDEV-12176) — GSoC 2017 project by Galina Shalygina

• ROW TYPE OF now supports local SP variables (MDEV-14139)

• Aggregate stored functions (MDEV-7773) — GSoC 2016 project by Varun Gupta

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

• Support for LIMIT clause in GROUP_CONCAT() (MDEV-11297)

• PERCENTILE_CONT, PERCENTILE_DISC, and MEDIAN window functions (MDEV-12985)

• FOR ... END FOR statement (MDEV-14415)

• XA RECOVER FORMAT='SQL' (MDEV-14593)

• Oracle compatible SUBSTR() function (MDEV-14012) — contribution by Jérôme Brauge

• INVISIBLE columns (MDEV-10177) — GSoC 2016 project by Sachin Setiya

• Various scalability improvements (MDEV-14529, MDEV-14505)

• Sequences can now be used with DEFAULT.

• Semi-sync plugin merged into the server (MDEV-13073) — contribution by Alibaba

• Numerous improvements for the partition engine (MDEV-7698) — contribution by Kentoku Shiba

  • HANDLER support, condition pushdown, MRR, fulltext search, aggregate pushdown, bulk update/delete

• Spider updated to version 3.3.13

• Join push-down for Spider 3.3 (MDEV-7698) — contribution by Kentoku Shiba

• As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.3 for RHEL 7.2 and CentOS 7.2. Starting with the next 10.3 release we will be building MariaDB for CentOS 7 and RHEL 7 on version 7.3.

• Galera wsrep library updated to 25.3.22

• Repositories for Ubuntu 17.10 Artful added

InnoDB

• MDEV-14717 crash-safe RENAME TABLE

• MDEV-14585 Automatically remove #sql- tables in InnoDB dictionary during recovery

• MDEV-12323 Rollback progress log messages during crash recovery are intermixed with unrelated log messages

• MDEV-14589 InnoDB should not lock a delete-marked record

• MDEV-14511 Use fewer transactions for updating InnoDB persistent statistics

• MDEV-14374 - UT_DELAY code : Removing hardware barrier for arm64 bit platform

• MDEV-14477 InnoDB update_time is wrongly updated after partial rollback or internal COMMIT

• Support CRC32 SSE4.2 implementation under Windows

Variables and Modes

• New sql_mode, EMPTY_STRING_IS_NULL (MDEV-14013) — contribution by Jérôme Brauge

• Added bind_address as a system variable (MDEV-12542).

• New status variables Table_open_cache_active_instances, Table_open_cache_hits, Table_open_cache_misses, Table_open_cache_overflows (MDEV-11153)

• innodb_page_cleaners is now dynamic (MDEV-11025)

• binlog_file_cache_size (MDEV-14114) — contribution by Jun Su.

• plugin_maturity is now set by default to one level less than server maturity. This may cause plugins below that maturity level that were previously working to no longer load (MDEV-12501).

• version_malloc_library now correctly detects and reports tcmalloc (MDEV-14315)

• New variables tcp_keepalive_time, tcp_keepalive_interval, tcp_keepalive_probes (MDEV-14412) — contribution by Oleg Obleukhov

• tcp_linger, tcp_linger_timeout (MDEV-14113) — contribution by Shuode Li

• slave_transaction_retry_errors, allowing one to specify certain operations resulting in an error during replication to be retried, and slave_transaction_retry_interval allowing the retry interval for a failed transaction to be set (MDEV-7698) — contribution by Kentoku Shiba

• In addition to K, M, and G, numeric command-line options now support T, P, and E suffixes — contribution by Daniel Black

Do not use beta releases on production systems!

For a complete list of changes made in MariaDB 10.3.3, 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.

_{This page is licensed: CC BY-SA / Gnu FDL}