The most recent release of MariaDB Community Server 10.11 is: 10.11.18 Stable (GA)
Download Community Server 10.11.18
Alternate download from mariadb.org
{% endhint %} Download Release Notes Overview of 10.11 **Release date:** 26 Sep 2022 {% hint style="danger" %} **Do not use non-stable (non-GA) releases in production!** {% endhint %} [MariaDB 10.11](/docs/release-notes/community-server/10.11/what-is-mariadb-1011.md) is a current development series of MariaDB. It is an evolution\ of [MariaDB 10.10](/docs/release-notes/community-server/old-releases/10.10/what-is-mariadb-1010.md) with several entirely new features. Unlike recent new releases, [MariaDB 10.11.0](/docs/release-notes/community-server/10.11/10.11.0.md) is a single preview release. Features are to be considered preview, and none are guaranteed to make it into [MariaDB 10.11](/docs/release-notes/community-server/10.11/what-is-mariadb-1011.md). The preview is available as a container **quay.io/mariadb-foundation/mariadb-devel:10.11-preview**. **For an overview of** [**MariaDB 10.11**](/docs/release-notes/community-server/10.11/what-is-mariadb-1011.md) **see the** [**What is MariaDB 10.11?**](/docs/release-notes/community-server/10.11/what-is-mariadb-1011.md) **page.** Thanks, and enjoy MariaDB! ### Authentication * Windows - passwordless login for mariadb root user, for OS admin users, using the [gssapi authentication plugin](/docs/server/reference/plugins/authentication-plugins/authentication-plugin-gssapi.md) ([MDEV-26715](https://jira.mariadb.org/browse/MDEV-26715)) * [GRANT to PUBLIC](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md#to-public) ([MDEV-5215](https://jira.mariadb.org/browse/MDEV-5215)) ([blog post](https://mariadb.org/grant-to-public-in-mariadb/)) * Separate [SUPER](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md#super) and [READ ONLY ADMIN](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md#read_only-admin) privileges ([MDEV-29596](https://jira.mariadb.org/browse/MDEV-29596)) ### Optimizer * Semi-join optimization for single-table update/delete statements ([MDEV-7487](https://jira.mariadb.org/browse/MDEV-7487)) * Allow pushdown of queries involving UNIONs in outer select to foreign engines ([MDEV-25080](https://jira.mariadb.org/browse/MDEV-25080)) * Make [ANALYZE FORMAT=JSON](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/analyze-format-json.md) show time spent in the query optimizer ([MDEV-28926](https://jira.mariadb.org/browse/MDEV-28926)) ### Information Schema * Performance Issues reading the [Information Schema Parameters table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-parameters-table.md) ([MDEV-29104](https://jira.mariadb.org/browse/MDEV-29104)) * Full table scan in the [Information Schema Parameters](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-parameters-table.md) and [Information Schema Routines](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-routines-table.md) tables ([MDEV-20609](https://jira.mariadb.org/browse/MDEV-20609)) ### System versioning * [System versioning](/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables.md) setting, [system\_versioning\_insert\_history](/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables.md#system_versioning_insert_history), to allow history modification ([MDEV-16546](https://jira.mariadb.org/browse/MDEV-16546)) * [mariadb-dump](/docs/server/clients-and-utilities/legacy-clients-and-utilities/mysqldump.md): dump and restore historical data ([MDEV-16029](https://jira.mariadb.org/browse/MDEV-16029)) ### InnoDB * [innodb\_write\_io\_threads](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_write_io_threads) and [innodb\_read\_io\_threads](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_read_io_threads) are now dynamic, and their values can be changed without restarting the server ([MDEV-11026](https://jira.mariadb.org/browse/MDEV-11026)) ### General * Rename [slow queries](/docs/server/server-management/server-monitoring-logs/slow-query-log.md) variables ([MDEV-7567](https://jira.mariadb.org/browse/MDEV-7567)) * [log\_slow\_min\_examined\_row\_limit](/docs/server/server-management/variables-and-modes/server-system-variables.md#log_slow_min_examined_row_limit) (min\_examined\_row\_limit) * [log\_slow\_query](/docs/server/server-management/variables-and-modes/server-system-variables.md#log_slow_query) (slow\_query\_log) * [log\_slow\_query\_file\_name](/docs/server/server-management/variables-and-modes/server-system-variables.md#log_slow_query_file) (slow\_query\_log\_file) This will be renamed to [log\_slow\_query\_file](/docs/server/server-management/variables-and-modes/server-system-variables.md#log_slow_query_file) in the next [MariaDB 10.11](/docs/release-notes/community-server/10.11/what-is-mariadb-1011.md) release. * [log\_slow\_query\_time](/docs/server/server-management/variables-and-modes/server-system-variables.md#log_slow_query_time) (long\_query\_time) * [replicate\_rewrite\_db](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#replicate_rewrite_db) is now a system variable, no longer just an option ([MDEV-15530](https://jira.mariadb.org/browse/MDEV-15530)) **Do not use *****alpha***** releases on production systems!**\ For a complete list of changes made in [MariaDB 10.11.0](/docs/release-notes/community-server/10.11/10.11.0.md), with links to detailed\ information on each push, see the [changelog](/docs/release-notes/community-server/changelogs/changelogs-mariadb-101-series/mariadb-10110-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" %}