> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/release-notes/community-server/old-releases/10.1/10.1.2.md). # MariaDB 10.1.2 Release Notes The most recent release of [MariaDB 10.1](/docs/release-notes/community-server/old-releases/10.1/changes-improvements-in-mariadb-10-1.md) is:[**MariaDB 10.1.48**](/docs/release-notes/community-server/old-releases/10.1/10.1.48.md) Stable (GA) [Download Now](https://downloads.mariadb.org/mariadb/10.1.48/) [Download](https://downloads.mariadb.org/mariadb/10.1.2) | [Release Notes](/docs/release-notes/community-server/old-releases/10.1/10.1.2.md) | [Changelog](/docs/release-notes/community-server/changelogs/changelogs-mariadb-101-series/mariadb-10-1-2-changelog.md) | [Overview of 10.1](/docs/release-notes/community-server/old-releases/10.1/changes-improvements-in-mariadb-10-1.md) **Release date:** 7 Dec 2014 [MariaDB 10.1](/docs/release-notes/community-server/old-releases/10.1/changes-improvements-in-mariadb-10-1.md) is the current development series of MariaDB. It is an evolution of [MariaDB 10.0](/docs/release-notes/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0.md) with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7. This is an [***Alpha***](/docs/release-notes/community-server/about/release-criteria.md) release. **For an overview of** [**MariaDB 10.1**](/docs/release-notes/community-server/old-releases/10.1/changes-improvements-in-mariadb-10-1.md) **see the**[**What is MariaDB 10.1?**](/docs/release-notes/community-server/old-releases/10.1/changes-improvements-in-mariadb-10-1.md) **page.** Thanks, and enjoy MariaDB! ## Notable Changes This is the third alpha release in the [MariaDB 10.1](/docs/release-notes/community-server/old-releases/10.1/changes-improvements-in-mariadb-10-1.md) series. Notable changes of this release include: * [--mysql56-temporal-format](/docs/server/server-management/variables-and-modes/server-system-variables.md#mysql56_temporal_format) option to use the MySQL-5.6 low level formats to store [TIME](/docs/server/reference/data-types/date-and-time-data-types/time.md), [DATETIME](/docs/server/reference/data-types/date-and-time-data-types/datetime.md) and [TIMESTAMP](/docs/server/reference/data-types/date-and-time-data-types/timestamp.md) types. ([MDEV-5528](https://jira.mariadb.org/browse/MDEV-5528)) * Support for Spatial Reference systems for the GIS data ([MDEV-60](https://jira.mariadb.org/browse/MDEV-60)), new `REF_SYSTEM_ID` column attribute can be used to specify Spatial Reference System ID for columns of spatial data types: ```sql CREATE TABLE t1(g GEOMETRY(9,4) REF_SYSTEM_ID=101); ``` It can be queried via the [INFORMATION\_SCHEMA.GEOMETRY\_COLUMNS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-geometry_columns-table.md) table. * [INFORMATION\_SCHEMA.SPATIAL\_REF\_SYS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-spatial_ref_sys-table.md) table. * More functions from the [OGC](https://www.opengeospatial.org/) standard added ([MDEV-4045](https://jira.mariadb.org/browse/MDEV-4045)): * [ST\_Boundary](/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_boundary.md) * [ST\_ConvexHull](/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/st_convexhull.md) * [ST\_IsRing](/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_isring.md) * [ST\_PointOnSurface](/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/st_pointonsurface.md) * [ST\_Relate](/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_relate.md) * Per-query variables - see [SET STATEMENT](/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-statement.md) ([MDEV-5231](https://jira.mariadb.org/browse/MDEV-5231)) * [EXPLAIN FORMAT=JSON](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/explain-format-json.md) ([MDEV-6109](https://jira.mariadb.org/browse/MDEV-6109)) * Scalability fixes ([MDEV-7004](https://jira.mariadb.org/browse/MDEV-7004)). Up to 60% higher throughput in sysbench benchmarks on Power8. * [Password validation plugin API](/docs/server/reference/plugins/password-validation-plugins/password-validation.md) ([MDEV-6431](https://jira.mariadb.org/browse/MDEV-6431)). * [simple\_password\_check](/docs/server/reference/plugins/password-validation-plugins/simple-password-check-plugin.md) 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. * Assisted discovery in the [OQGRAPH Storage Engine](/docs/server/server-usage/storage-engines/oqgraph-storage-engine.md) ([MDEV-5871](https://jira.mariadb.org/browse/MDEV-5871)) * [cracklib\_password\_check](/docs/server/reference/plugins/password-validation-plugins/cracklib-password-check-plugin.md) password validation plugin. It only allows passwords that are strong enough to pass [CrackLib](https://sourceforge.net/projects/cracklib/) test. This is the same test that `pam_cracklib.so` does, installed by default on many Linux distributions. * The number of rows affected by a slow UPDATE or DELETE is now recorded in the [slow query log](/docs/server/server-management/server-monitoring-logs/slow-query-log.md) - see also [mysql.slow\_log Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-slow_log-table.md). ([MDEV-4412](https://jira.mariadb.org/browse/MDEV-4412)) * [GET\_LOCK()](/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/get_lock.md) now supports microseconds in the timeout, no longer rounding fractions to the nearest integer ([MDEV-4018](https://jira.mariadb.org/browse/MDEV-4018)) * domain\_id based replication filters - see [CHANGE MASTER TO](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/change-master-to.md) ([MDEV-6593](https://jira.mariadb.org/browse/MDEV-6593)) * Two new Information Schema tables for examining wsrep information, [WSREP\_MEMBERSHIP](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-wsrep_membership-table.md) and [WSREP\_STATUS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-wsrep_status-table.md) ([MDEV-7053](https://jira.mariadb.org/browse/MDEV-7053)) * [innodb\_log\_compressed\_pages](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md) is now set to `OFF` by default. * The Facebook Prefix Index Queries Optimization ([MDEV-6929](https://jira.mariadb.org/browse/MDEV-6929)), enabled with [innodb\_prefix\_index\_cluster\_optimization](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md) and two new status variables, [Innodb\_secondary\_index\_triggered\_cluster\_reads](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/innodb-status-variables.md) and [Innodb\_secondary\_index\_triggered\_cluster\_reads\_avoided](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/innodb-status-variables.md) to track its effectiveness. * Default size of [query\_alloc\_block\_size](/docs/server/server-management/variables-and-modes/server-system-variables.md#query_alloc_block_size) changed from `8192` to `16384` and [query\_prealloc\_size](/docs/server/server-management/variables-and-modes/server-system-variables.md#query_prealloc_size) from `8192` to `24576` to avoid the need for simple queries with one join to call `my_malloc`. * Other Webscale patches ([MDEV-6039](https://jira.mariadb.org/browse/MDEV-6039)) * Out parameters in PREPARE were removed, as it was decided to rather implement the feature in a standard way. **Do not use *****alpha***** releases on production systems!** Repositories exist for 10.1, but because 10.1 is still Alpha, they are not visible in the [repository configuration tool](https://downloads.mariadb.org/mariadb/repositories/). To configure a 10.1 apt, yum, or zypper repository using the tool, simply select 10.0 and then when executing the instructions, manually change all occurrences of '10.0' to '10.1'. For a complete list of changes made in [MariaDB 10.1.2](/docs/release-notes/community-server/old-releases/10.1/10.1.2.md), with links to detailed information on each push, see the [changelog](/docs/release-notes/community-server/changelogs/changelogs-mariadb-101-series/mariadb-10-1-2-changelog.md). {% hint style="info" %} Be notified of new MariaDB Server releases automatically by [subscribing](https://lists.mariadb.org/postorius/lists/announce.lists.mariadb.org/) to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services. MariaDB may already be included in your favorite OS distribution. More information can be found on the [Distributions which Include MariaDB](/docs/general-resources/distributions-including-mariadb.md) page. {% endhint %} *This page is licensed: CC BY-SA / Gnu FDL* {% @marketo/form formid="4316" formId="4316" %}