> 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.4/10.4.3.md).

# MariaDB 10.4.3 Release Notes

MariaDB 10.4.3 is an RC release of MariaDB Community Server 10.4, released on 2019-02-25

The most recent release of [MariaDB 10.4](/docs/release-notes/community-server/old-releases/10.4.md) is:[**MariaDB 10.4.34**](/docs/release-notes/community-server/old-releases/10.4/10.4.34.md) Stable (GA) [Download Now](https://downloads.mariadb.org/mariadb/10.4.34/)

[Download](https://downloads.mariadb.org/mariadb/10.4.3) | [Release Notes](/docs/release-notes/community-server/old-releases/10.4/10.4.3.md) | [Changelog](/docs/release-notes/community-server/changelogs/changelogs-mariadb-10-4-series/mariadb-1043-changelog.md) | [Overview of 10.4](/docs/release-notes/community-server/old-releases/10.4/what-is-mariadb-104.md)

**Release date:** 25 Feb 2019

[MariaDB 10.4](/docs/release-notes/community-server/old-releases/10.4.md) is the current *development* series of MariaDB. It is an evolution of [MariaDB 10.3](/docs/release-notes/community-server/old-releases/10.3/what-is-mariadb-103.md) with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

[MariaDB 10.4.3](/docs/release-notes/community-server/old-releases/10.4/10.4.3.md) is a [***Release Candidate***](/docs/release-notes/community-server/about/release-criteria.md) release.

**Do not use non-stable (non-GA) releases in production!**

**For an overview of** [**MariaDB 10.4**](/docs/release-notes/community-server/old-releases/10.4.md) **see the**[**What is MariaDB 10.4?**](/docs/release-notes/community-server/old-releases/10.4/what-is-mariadb-104.md) **page.**

Thanks, and enjoy MariaDB!

## Notable Changes

Notable changes of this release include:

* [MDEV-12484](https://jira.mariadb.org/browse/MDEV-12484): The [unix\_socket authentication plugin](/docs/server/reference/plugins/authentication-plugins/authentication-plugin-unix-socket.md) is now default on Unix-like systems, which is a major change to authentication in MariaDB
* [MDEV-11340](https://jira.mariadb.org/browse/MDEV-11340): Allow multiple alternative authentication methods for the same user
* [MDEV-7597](https://jira.mariadb.org/browse/MDEV-7597): [User password expiry](/docs/server/security/user-account-management/user-password-expiry.md)
* [MDEV-6111](https://jira.mariadb.org/browse/MDEV-6111): Implementation of the [optimizer trace](https://mariadb.com/docs/general-resources/development-articles/mariadb-internals/mariadb-internals-documentation-query-optimizer/mariadb-internals-documentation-optimizer-trace), one can enable the optimizer trace by enabling the system variable [optimizer\_trace](/docs/server/server-management/variables-and-modes/server-system-variables.md#optimizer_trace)
* [Temporal tables](/docs/server/reference/sql-structure/temporal-tables.md) extended with support for [application-time periods](/docs/server/reference/sql-structure/temporal-tables/application-time-periods.md) ([MDEV-16973](https://jira.mariadb.org/browse/MDEV-16973), [MDEV-16974](https://jira.mariadb.org/browse/MDEV-16974), [MDEV-16975](https://jira.mariadb.org/browse/MDEV-16975), [MDEV-17082](https://jira.mariadb.org/browse/MDEV-17082))
* [MDEV-18551](https://jira.mariadb.org/browse/MDEV-18551): The default for [eq\_range\_index\_dive\_limit](/docs/server/server-management/variables-and-modes/server-system-variables.md#eq_range_index_dive_limit) is now `200` (previously `0`)
* [MDEV-17903](https://jira.mariadb.org/browse/MDEV-17903): The [optimizer switch](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizer-switch.md) flag `optimize_join_buffer_size` now defaults to `on`
* New [optimizer switch](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizer-switch.md) flags `rowid_filter` and `condition_pushdown_from_having`
* [MDEV-18439](https://jira.mariadb.org/browse/MDEV-18439): [core\_file](/docs/server/server-management/variables-and-modes/server-system-variables.md#core_file) on Windows now defaults to `ON`
* [MDEV-18608](https://jira.mariadb.org/browse/MDEV-18608): [Histograms](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/histogram-based-statistics.md) are now used (but not collected) by default.
* [MDEV-13916](https://jira.mariadb.org/browse/MDEV-13916): The [JSON\_VALID](/docs/server/reference/sql-functions/special-functions/json-functions/json_valid.md) function is automatically used as a [CHECK constraint](/docs/server/reference/sql-statements/data-definition/constraint.md#check-constraints) for the [JSON data type alias](/docs/server/reference/data-types/string-data-types/json.md) in order to ensure that a valid json document is inserted
* [Spider](/docs/server/server-usage/storage-engines/spider.md) updated to 3.3.14
* Unique indexes can be created on [BLOB](/docs/server/reference/data-types/string-data-types/blob.md) or [TEXT](/docs/server/reference/data-types/string-data-types/text.md) fields ([MDEV-371](https://jira.mariadb.org/browse/MDEV-371))
* [MDEV-18564](https://jira.mariadb.org/browse/MDEV-18564): [wsrep\_load\_data\_splitting](/docs/galera-cluster/reference/galera-cluster-system-variables.md#wsrep_load_data_splitting) is deprecated and now set to `OFF` by default
* [analyze\_sample\_percentage](/docs/server/server-management/variables-and-modes/server-system-variables.md#analyze_sample_percentage) system variable
* InnoDB ALTER TABLE fixes: [MDEV-18222](https://jira.mariadb.org/browse/MDEV-18222), [MDEV-18256](https://jira.mariadb.org/browse/MDEV-18256), [MDEV-18016](https://jira.mariadb.org/browse/MDEV-18016), [MDEV-18295](https://jira.mariadb.org/browse/MDEV-18295), [MDEV-16849](https://jira.mariadb.org/browse/MDEV-16849), [MDEV-18219](https://jira.mariadb.org/browse/MDEV-18219)
* mariadb-backup fixes: [MDEV-18194](https://jira.mariadb.org/browse/MDEV-18194), [MDEV-18415](https://jira.mariadb.org/browse/MDEV-18415), [MDEV-18611](https://jira.mariadb.org/browse/MDEV-18611)
* New InnoDB features:
  * [MDEV-12026](https://jira.mariadb.org/browse/MDEV-12026): Implement [innodb\_checksum\_algorithm=full\_crc32](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_checksum_algorithm)
  * [MDEV-15563](https://jira.mariadb.org/browse/MDEV-15563): More Instant VARCHAR extension
  * [MDEV-15564](https://jira.mariadb.org/browse/MDEV-15564): Instant collation or charset changes for non-indexed columns
  * [MDEV-16188](https://jira.mariadb.org/browse/MDEV-16188): Use in-memory PK filters built from range index scans
* Debian has stopped supporting the ppc64el architecture for Debian 8\
  Jessie and so this is the last release of [MariaDB 10.4](/docs/release-notes/community-server/old-releases/10.4.md) on Jessie for that architecture
* Fixes for the following [security vulnerabilities](/docs/server/security/cve.md):
  * CVE-\`-\`\`\`

## Changelog

For a complete list of changes made in [MariaDB 10.4.3](/docs/release-notes/community-server/old-releases/10.4/10.4.3.md), with links to detailed information on each push, see the [changelog](/docs/release-notes/community-server/changelogs/changelogs-mariadb-10-4-series/mariadb-1043-changelog.md).

## Contributors

For a full list of contributors to [MariaDB 10.4.3](/docs/release-notes/community-server/old-releases/10.4/10.4.3.md), see the [MariaDB Foundation release announcement](https://mariadb.org/mariadb-10-4-3-now-available/).

{% 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 %}

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

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