What is MariaDB 10.0?

MariaDB 10.0 is the development version of MariaDB. It is built on the MariaDB 5.5 series with backported features from MySQL 5.6 and entirely new features not found anywhere else.

Implemented Features

Features that are in a release, or in the source tree on launchpad.

It is important to note that MariaDB 10.0.1 is now available, and there is a good amount of information on what is available in the release listed: What does MariaDB 10.0.1 include – available now.

New Features

• Better error messages (all error numbers now include a descriptive text what the number means)
• SHOW EXPLAIN command
• Multi source replication — Original code from Taobao, developed by Peng Lixun.
• Per thread memory usage. — Original code from Taobao, developed by Peng Lixun.
  • information_schema.processlist has two new columns: MEMORY_USAGE and EXAMINED_ROWS.
  • SHOW STATUS has a new variable: Memory_used.
• Cassandra storage engine
• MDEV-377 Named dynamic columns.
• MDEV-539 Faster UNIQUE key generation with ALTER TABLE
• MDEV-532 Implement async commit checkpoint in InnoDB and XtraDB
• MDEV-3806 Engine independent statistics

New Features Re-implemented from a similar MySQL feature

• MDEV-452 CURRENT_TIMESTAMP as DEFAULT for DATETIME columns

New Features Backported from MySQL 5.6

• New InnoDB — from MySQL 5.6.5
• Performance schema — from MySQL 5.6.5 (without host cache)
• Optimized read only transaction (for InnoDB). This includes support for TRANSACTION READ ONLY.
• LIMIT ... ORDER BY optimization
• MDEV-3860 backport --plugin-load-add

Features that will definitely be in the final 10.0 release

• Support for automatic updating of timestamps in DATETIME
• Memory tables with efficient VARCHAR and BLOB support
• Online ALTER TABLE

Rolling features

• EXISTS-to-IN optimization

See Also

The following features may or may not be in 10.0. It depends on if we can find a sponsors for these or if someone in the community will help us with developing them:

• Plans for 10.x