MariaDB 10.3.3 Release Notes
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.
Thanks, and enjoy MariaDB!
This is the first beta release in the MariaDB 10.3 series.
Notable changes of this release include:
- 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
- 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_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!
Be notified of new MariaDB Server, Galera Cluster and Connector releases automatically by subscribing to the MariaDB Foundation community announce 'at' mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB Corporation customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB Corporation 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.