MariaDB 12.1 Changes & Improvements

MariaDB 12.1 is a rolling release. It is an evolution of MariaDB 12.0 with several entirely new features.

New Features

Performance improvements

• Segmented key cache for ()

  • The new system variable defines how many segments are used, default is 1, maximum 128

• MDL scalability improvements ()

Compatibility features

• New authentication plugin for MySQL compatibility ()

• ()

• Associative arrays: DECLARE TYPE .. TABLE OF .. INDEX BY () ()

• will now by default issue a warning if the user has active sessions, or fail in ()

Optimizer

• Optimizations for GROUP/ORDER BY can make use of indexes on virtual columns ()

• Include definitions of tables and views in the ()

  • system variable.

Optimizer hints

• : , , , ()

• : ()

• : , ()

Miscellaneous

• Retry applying of write sets on nodes ()

  • Controlled through the system variable

• now supports with the -L or --wildcards option ()

Development release only

This feature was only available in the 12.1 development releases, and will be implemented in a later series.

• Add variable, ()

List of All MariaDB 12.1 Releases