MariaDB 10.0.4 Release Notes

You are viewing an old version of this article. View the current version here.

Note: This page describes features in the source repository for MariaDB 10.0. There are currently no official packages or binaries available for download which contain the features. If you want to try out any of the new features described here you will need to get and compile the code yourself.

MariaDB 10.0 目前是 MariaDB 开发版本。MariaDB 10.0是在 MariaDB 5.5 series 的基础上从 MySQL 5.6 集成了 backported 和 reimplemented 和一些你不能在其他地方找到新特性。

MariaDB 10.0.4 is an Alpha release. This is the fifth 10.0-based release, and we are releasing it now to get it into the hands of any who might want to test it. Not all features planned for the MariaDB 10.0 series are included in this release. Additional features will be pushed in future releases. Do not use alpha releases on production systems.

For an overview of MariaDB 10.0 see the What is MariaDB 10.0? page.

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

Based on MariaDB 5.5

The MariaDB 10.0 series builds off of the MariaDB 5.5 series. It also includes features imported from MySQL 5.6, and completely new features.

In most respects MariaDB will work exactly as MySQL: all commands, interfaces, libraries and APIs that exist in MySQL also exist in MariaDB.

Newly Implemented Features

  • MDEV-4438 - Spider storage engine
  • MDEV-4568 - Port Percona response time distribution as audit plugin
  • MDEV-4594 - CREATE SERVER crashes embedded
  • MDEV-4702 - Reduce usage of LOCK_open

Features and Fixes Merged or Backported from 5.6

  • MDEV-330 - merge microsecond feature from mysql-5.6. MariaDB now can open tables created in MySQL-5.6 that have columns of types TIME(N), DATETIME(N) and TIMESATMP(N). Previously, an attempt to open such a table in MariaDB would return an error.
  • MDEV-3838 - Standard SQL temporal literals are recognized by MySQL 5.6 but ignored by MariaDB 10.0
  • MDEV-4058 - Merge the host_cache P_S table
  • MDEV-4710 - Merge Performance Schema test cases from MySQL 5.6.10
  • WL#5185 Remove deprecated 5.1 features
  • Performance schema + new defaults;
  • InnoDB + Information Schema + new defaults;
  • Online ALTER for InnoDB + thread information for in-place operations;
  • EXHANGE PARTITION
  • Partition selection
  • Partition lock pruning (MySQL Bug #37252, Bug #11748732)
  • The maximum number of partitions for a user-partitioned table is increased from 1024 to 8192. (Bug #11755685)
  • The server now includes the thread ID in rows written to the slow query log
  • The mysql client program now has a --binary-mode option that helps when processing mysqlbinlog output that may contain BLOB values (MySQL Bug #33048, Bug #11747577)
  • For temporary tables created with the CREATE TEMPORARY TABLE statement, the privilege model has changed (MySQL Bug #27480, Bug #11746602)
  • MySQL now supports the GET DIAGNOSTICS statement. In addition several deficiencies in condition handler processing rules were corrected so that MySQL behavior is more like standard SQL (Bug #12951117, MySQL Bug #38806, Bug #11749343, MySQL Bug #55852, Bug #11763171, MySQL Bug #61392, Bug #12652873, MySQL Bug #11660, Bug #11745196)
  • Syntax for temporal literals now produces temporal values
  • MySQL now provides more information about the causes of errors that occur when clients connect to the server, as well as improved access to the host cache
  • Traditional EXPLAIN output has also changed so that empty columns contain NULL rather the empty string (? something definitely changed here)
  • For the WITH_SSL CMake option, no is no longer a permitted value or the default value. The default is now bundled.
  • The WITH_SSL option for CMake now accepts a path_name value that indicates the path name to the OpenSSL installation to use (MySQL Bug #61619, Bug #12762891)
  • new default values for max_connect_errors, open_files_limit

For full details, see the changelog.

Other Features

Other features are planned for inclusion in the Stable (GA) version of MariaDB 10.0. They are listed on the What is MariaDB 10.0? and Plans for 10x pages.

Thanks, and enjoy MariaDB!


Be notified of new releases automatically by adding the releases rss feed to your favorite feed reader or by subscribing to the announce 'at' mariadb.org announcement list (this is a low traffic, announce-only list).

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

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.