MariaDB 12.0 Changes & Improvements
An overview of changes, improvements, and what's new in MariaDB Community Server 12.0
The most recent release of MariaDB 12.0 is:
MariaDB 12.0.2 Stable (GA) Download Now
MariaDB 12.0 is a rolling release. It is an evolution of MariaDB 11.8 with several entirely new features.
New Features
Security
Support for passphrase protected keys (MDEV-14091)
ssl_passphrase system variable
New statement SET SESSION AUTHORIZATION for performing actions as another user (MDEV-20299)
Implement SHA2 support for file_key_management.so plugin (TDE) (MDEV-34712)
Data types
Comparison ROW(stored_func(),1)=ROW(1,1) erroneously called stored_func() twice per row. It led to a performance degradation, as well as to a double execution of the possible stored function side effects. (MDEV-36322)
Stored Routines
Add support for the pre-defined weak SYS_REFCURSOR (MDEV-20034)
max_open_cursors system variable limits the number of cursors opened at the same time
Server
Add the FM format to TO_CHAR, which suppresses following padding (MDEV-36216)
mariadb-check and CHECK TABLE now support SEQUENCE tables (MDEV-22491)
Optimizer
Rowid Filtering optimization can now be applied for reverse-ordered scans (MDEV-36094)
Index Condition Pushdown optimization can now applied for reverse-ordered scans (MDEV-34413)
Loose Index Scan ("Use index for group-by") optimization can now use indexes with DESC key parts (MDEV-32732)
find_order_in_list mismatch when order item needs fixing() (MDEV-36607)
If the join_condition is specified via USING (column_list), the query plan depends on the sequence of tables in the query (MDEV-36592)
Optimizer hints
Add support for subquery optimizer hints (MDEV-34888)
Add support for join order hints (MDEV-34870)
JOIN_FIXED_ORDER similar to existing STRAIGHT_JOIN hint
JOIN_ORDER to apply the specified table order
JOIN_PREFIX to hint what tables should be first in the join
JOIN_SUFFIX to hint what tables should be last in the join
Add support for the MAX_EXECUTION_TIME hint (MDEV-34860)
GIS
New GIS functions. These functions improve compatibility with MySQL 8.
Trigger
Add support for TRIGGERS that fire on multiple events (MDEV-10164)
Replication
Server displays if it was started with the skip-slave-start option (MDEV-27669)
show_slave_auth_info has been added as a system variable (previously it was just an option). It determines whether to show the user and password in SHOW REPLICA HOSTS (SHOW SLAVE HOSTS) on the primary.
replicate_same_server_id system variable added (previously it was just an option), which permits not skipping events having our server id.
Ensure that creation and usage of temporary tables in replication is predictable (MDEV-36099)
create_tmp_table_binlog_formats system variable.
Galera
In Galera, needless foreign key checks during Incremental State Transfers are now avoided (MDEV-34822)
Audit Plugin
The Audit Plugin now logs HOST:PORT of incoming connections instead of just the host (MDEV-1282)
Added tls_version field for connection audit plugins (MDEV-33834)
Configuration
Get option group suffix from
$MARIADB_GROUP_SUFFIXin addition to$MYSQL_GROUP_SUFFIX(MDEV-21375)
mariadb Client
Can set an alternative directory path for searching scripts invoked via the source command, with the --script-dir mariadb client option (MDEV-23818)
Variables
For a list of all new variables, see System Variables Added in MariaDB 12.0.
Removed
big_tables, deprecated in MariaDB 10.5.0
large_page_size, deprecated in MariaDB 10.5.3
storage_engine, deprecated in MariaDB 5.5.
List of All MariaDB 12.0 Releases
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?