MariaDB 10.1.1 Release Notes

Download Release Notes Changelog Overview of 10.1

Release date: 17 October 2014

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

MariaDB 10.1.1 is an Alpha release.

Thanks, and enjoy MariaDB!

Notable Changes

This is the second alpha release in the MariaDB 10.1 series.

Notable changes of this release include:

• Triggers can now be run on the slave for row-based events.
• Default roles allow roles to be enabled automatically when a user connects.
• InnoDB: merged the Facebook/Kakao defragmentation patch (see Defragmenting InnoDB Tablespaces) which uses OPTIMIZE TABLE to defragment InnoDB tablespaces).
• Performance Schema tables no longer use .frm files.
• Galera is merged into MariaDB server, MariaDB 10.1.1 binaries automatically support Galera out of the box.
• InnoDB: report progress of inplace alter table (Kakao patch).
• Statements that exceed a certain execution time can now be aborted.
• PREPARE statement now supports out parameters.
• Compound statements can be used outside of stored programs.
• The engine_condition_pushdown optimizer_switch flag has been deprecated. Engine condition pushdown is now always enabled for all engines that support it.
• New Information Schema table SYSTEM_VARIABLES shows for every system variable its session and global variable values as well as various metadata.
• Information Schema plugins can now support SHOW and FLUSH statements. New statements in this release:
  • SHOW QUERY_RESPONSE_TIME
  • FLUSH QUERY_RESPONSE_TIME
  • SHOW LOCALES
• Two new columns added to the CLIENT_STATISTICS and USER_STATISTICS Information Schema tables (TOTAL_SSL_CONNECTIONS and MAX_STATEMENT_TIME_EXCEEDED).
• MariaDB can execute UNION ALL without a temporary table. (MySQL 5.7 patch)
• @@sql_log_slow is now a session variable, not global.
• Merge with MariaDB 10.0.14
• As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.1 for both Ubuntu 13.10 "Saucy" and Mint 16 "Petra".
• With the recent release of CentOS 7 and RHEL 7, we are pleased to now provide packages for both distributions. Instructions for how to enable the repositories can be found by visiting the "Installing MariaDB with YUM" page and the repository configuration tool.

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