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 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 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 now. To experience MariaDB database products in the cloud, try MariaDB SkySQL, a multi-cloud database service.