MariaDB 10.1 Changes & Improvements

MariaDB 10.1 is no longer maintained. Please use a more recent release.

The most recent release of MariaDB 10.1 is:MariaDB 10.1.48 Stable (GA) Download Now

MariaDB 10.1 is a previous stable version of MariaDB. The first stable release was in October 2014.

For details on upgrading from MariaDB 10.0, see .

The following lists the major new features in MariaDB 10.1:

Implemented Features

Galera

• , a true multi-master solution, is a standard part of .

• Two new Information Schema tables for examining wsrep information, and ()

Encryption

• .

Page Compression

• Page compression for .

Replication

• ()

• domain_id based replication filters - see ()

• Enhanced semisync replication; Wait for at least one slave to acknowledge transaction before committing ().

• for row-based events.

Roles

• ().

• New columns for the table.

Optimization

• by several fixes for real-world cases.

• Don't create frm files for temporary tables ().

• can be used to automatically abort long running queries. ().

• works without usage of a temporary table (). The feature was backported from MySQL 5.7

GIS

• Support for Spatial Reference systems for the GIS data (), new REF_SYSTEM_ID column attribute can be used to specify Spatial Reference System ID for columns of spatial data types:

• More functions from the standard added ():

Syntax

• Consistent support for IF EXISTS, IF NOT EXISTS, and OR REPLACE clauses:

  • ()

  • ()

XtraDB / InnoDB

• Allow up to 64K pages in InnoDB (old limit was 16K) ().

• The Facebook/Kakao defragmentation patch (see ) which uses to defragment InnoDB tablespaces).

Collations

• Added the utf8_thai_520_w2, utf8mb4_thai_520_w2, ucs2_thai_520_w2, utf16_thai_520_w2 and utf32_thai_520_w2 .

Variables

For a list of all new variables, see and . Some of these, and other variable-related changes, include:

• gives information, like description and value origin, for system variables ().

• New server variable

• New status variables to show the number of grants on different objects (see )

• Default size of changed from 8192

Plugins

• ().

• password validation plugin. It can enforce a minimum password length and guarantee that a password contains at least a specified number of uppercase and lowercase letters, digits, and punctuation characters.

• password validation plugin. It only allows passwords that are strong enough to pass test. This is the same test that pam_cracklib.so does, installed by default on many Linux distributions.

Security

• Enhance security using special compilation options - MariaDB is now compiled with security hardening options by default. It is an additional protection layer that makes new, yet unknown, security vulnerabilities more difficult to exploit. ()

Security Vulnerabilities Fixed in

For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.

• : : : : : : : : : : : : : : : : : : : : : : : : : : : : :

Comparison with MySQL

List of all releases

See Also