> 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/13.0/mariadb-13.0-changes-and-improvements.md).

# MariaDB 13.0 Changes & Improvements

{% hint style="info" %}

<p align="center">The most recent release of MariaDB Community Server 13.0 is: <a href="/pages/CjsmQ41OsIrzN6yJbglA"><strong>13.0.1</strong></a> RC</p>

<p align="center"><a href="https://downloads.mariadb.org/mariadb/13.0.1/" class="button primary">Download Community Server 13.0.1 RC</a></p>
{% endhint %}

MariaDB 13.0 is a [rolling release](/docs/release-notes/community-server/about/release-model.md). It is an evolution of [MariaDB 12.3](/docs/release-notes/community-server/12.3/mariadb-12.3-changes-and-improvements.md) with several entirely new features.

## New Features

* Add support for [`TYPE .. IS REF CURSOR`](/docs/server/reference/sql-statements/programmatic-compound-statements/declare-type.md#ref-cursor-types) ([MDEV-10152](https://jira.mariadb.org/browse/MDEV-10152))
* One can specify [timestamp format for the audit plugin log](/docs/server/reference/plugins/mariadb-audit-plugin/mariadb-audit-plugin-log-format.md) ([MDEV-18386](https://jira.mariadb.org/browse/MDEV-18386))
* Atomic [`CREATE OR REPLACE TABLE`](/docs/server/server-usage/tables/create-table.md#create-or-replace) ([MDEV-25292](https://jira.mariadb.org/browse/MDEV-25292))
* [`INFORMATON_SCHEMA.SYSTEM_VARIABLES`](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-system_variables-table.md) shows if a variable is deprecated ([MDEV-35369](https://jira.mariadb.org/browse/MDEV-35369))
* [`INFORMATON_SCHEMA.STATISTICS`](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-statistics-table.md) and [`INFORMATON_SCHEMA.COLUMNS`](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-columns-table.md) shows engine specific create options ([MDEV-36444](https://jira.mariadb.org/browse/MDEV-36444))
* [Optimizer Trace](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-trace.md) includes used optimizer statistics ([MDEV-36511](https://jira.mariadb.org/browse/MDEV-36511))
* New [`innodb_log_archive`](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_log_archive) variable makes InnoDB preserve the write-ahead log in a continuous sequence of files instead of overwriting a ring buffer, enabling point-in-time recovery and incremental backups ([MDEV-37949](https://jira.mariadb.org/browse/MDEV-37949))
* New [`QB_NAME()` optimizer hint](/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints/query-block-naming.md) ([MDEV-38045](https://jira.mariadb.org/browse/MDEV-38045))
* Support [`RECORD`](/docs/server/reference/sql-statements/programmatic-compound-statements/declare-type.md#record-types) in routine parameters and function `RETURN` clause ([MDEV-38768](https://jira.mariadb.org/browse/MDEV-38768))
* Reversed [executable comments](/docs/server/reference/sql-statements/comment-syntax.md#executable-comments) ([MDEV-7381](https://jira.mariadb.org/browse/MDEV-7381))

## Notable Items

* [`CHANGE MASTER`](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/change-master-to.md) now resets `Master_Server_Id` in [`SHOW SLAVES STATUS`](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/legacy-replication-statements/legacy-commands-show-slave-status.md) ([MDEV-15327](https://jira.mariadb.org/browse/MDEV-15327))
* Faster unique indexes over [`CHAR`](/docs/server/reference/data-types/string-data-types/char.md) columns in MEMORY tables (incl. temporary tables) ([MDEV-21543](https://jira.mariadb.org/browse/MDEV-21543))
* [`PERFORMANCE_SCHEMA`](/docs/server/server-usage/storage-engines/performance_schema-storage-engine.md) now uses `XXH3_128` hash for digest. Looks like MD5, but much faster and no problems in FIPS mode. ([MDEV-31669](https://jira.mariadb.org/browse/MDEV-31669))
* [`binlog_row_event_max_size`](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#binlog_row_event_max_size) default value was increased to 64k ([MDEV-37608](https://jira.mariadb.org/browse/MDEV-37608))
* [`default_master_connection`](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#default_master_connection) can now be set on global level ([MDEV-9247](https://jira.mariadb.org/browse/MDEV-9247))

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formid="4316" formId="4316" %}