---
title: "Announcing MariaDB Community Server 10.11 GA"
publish_date: 2023-02-17
author: "Ralf Gebhardt"
channel:
  - name: "Product"
    url: "/resources/blog/channel/product.md"
tags:
  - name: "Community Server"
    url: "/resources/blog/tag/community-server.md"
  - name: "InnoDB"
    url: "/resources/blog/tag/innodb.md"
  - name: "Privileges"
    url: "/resources/blog/tag/privileges.md"
  - name: "System Versioning"
    url: "/resources/blog/tag/system-versioning.md"
---

# Announcing MariaDB Community Server 10.11 GA

We are pleased to announce the general availability (GA) of MariaDB Community Server 10.11.

Big highlights of the [MariaDB Community Server 10.11](https://staging-mdb.com/downloads/community/community-server/) release include optimizations to information schema system tables, the new GRANT TO PUBLIC, changes to privileges to allow real read only replicas and enhancements for analyzing the time spent in the query optimizer. We also enhanced our [system versioned table](https://staging-mdb.com/docs/server/sql/features/temporal-tables/enterprise-server/#System-Versioned_Tables) feature – a flagship feature to store, access and audit past data – so it can now not only create a logical dump with all history data, it can also restore the history data together with the currently valid data from a dump file.

More detail about these features can be found below:

###### FOR DEVELOPERS

- Optimizations to information schema system tables 
    - The information schema provides tables with metadata about stored procedures and stored routines, which are often used by third party tools and MariaDB Connectors to retrieve details about existing routines. Previously, a high number of rows in these tables would have resulted in a performance impact. We have made a number of internal improvements to eliminate the performance impact completely for use cases, where metadata had to be queried regularly

###### FOR DEVOPS AND DBAS

- The new SQL syntax `GRANT .. TO PUBLIC` can now be used to easily grant privileges to databases or tables for any user, who has access to the server. 
    - `SHOW GRANTS FOR PUBLIC` is an enhancement to the existing `SHOW GRANTS` syntax to retrieve all privileges granted to public
- `SUPER` and `READ ONLY ADMIN` privileges are now separated 
    - The `READ ONLY ADMIN` privileges now needs to be granted to a user with the `SUPER` privilege explicitly, if this user should have write access to a read only replica (a replica having `read_only=1` set).
    - Read-only replicas are used to ensure that they stay consistent with the primary. This can now be ensured also if `SUPER` users try to update data on the replica
- System versioned tables can now be dumped and restored by mariadb-dump 
    - The new parameter mariadb-dump parameter `--dump-history` dumps all historical data
    - To restore from a dump file the new parameter `system_versioning_insert_history` needs to be enabled to allow direct inserts into `ROW_START` and `ROW_END` columns
    - The existing parameter `secure_timestamp` needs to be set to a value which allows changing session timestamps
- `ANALYZE FORMAT=JSON` now shows the time spent in the query optimizer 
    - In some cases optimizing the query can take a while. `ANALYZE FORMAT=JSON` now reports time as `"query_optimization": {  "r_total_time_ms": NNNN.NNN }` in the JSON string
- The system variables `innodb_write_io_threads` and `innodb_read_io_threads` are now dynamic, and their values can be changed without restarting the server

[Download the latest release of MariaDB Community Server](https://staging-mdb.com/downloads/) now. To experience MariaDB database products in the cloud, try [MariaDB SkySQL](https://staging-mdb.com/products/skysql/get-started/), a multi-cloud database service.