Changes and Improvements in MariaDB 10.11

MariaDB 10.11 is a current development branch. See Plans for MariaDB 10.11.

New Features & Improvements

Authentication

• GRANT to PUBLIC (MDEV-5215) (blog post)
• Separate SUPER and READ ONLY ADMIN privileges (MDEV-29596)

Optimizer

• Semi-join optimization for single-table update/delete statements (MDEV-7487)
• Allow pushdown of queries involving UNIONs in outer select to foreign engines (MDEV-25080)
• Make ANALYZE FORMAT=JSON show time spent in the query optimizer (MDEV-28926)

Information Schema

• Performance Issues reading the Information Schema Parameters table (MDEV-29104)
• Full table scan in the Information Schema Parameters and Information Schema Routines tables (MDEV-20609)

System versioning

• System versioning setting, system_versioning_insert_history, to allow history modification (MDEV-16546)
• mariadb-dump: dump and restore historical data (MDEV-16029)

InnoDB

• innodb_write_io_threads and innodb_read_io_threads are now dynamic, and their values can be changed without restarting the server (MDEV-11026)

Windows

• Windows - passwordless login for mariadb root user, for OS admin users (MDEV-26715)

General

• Rename slow queries variables (MDEV-7567)
  • log_slow_min_examined_row_limit (min_examined_row_limit)
  • log_slow_query (slow_query_log)
  • log_slow_query_file (slow_query_log_file). This was named log_slow_query_file_name in the MariaDB 10.11.0 preview release.
  • log_slow_query_time (long_query_time)

• replicate_rewrite_db is now a system variable, no longer just an option (MDEV-15530)

Variables

• For a list of all new variables, see System Variables Added in MariaDB 10.11 and Status Variables Added in MariaDB 10.11.

List of All MariaDB 10.11 Releases