MariaDB 13.0 Changes & Improvements
An overview of changes, improvements, and what's new in MariaDB Community Server 13.0
MariaDB 13.0 is a rolling release. It is an evolution of MariaDB 12.3 with several entirely new features.
New Features
Add support for
TYPE .. IS REF CURSOR(MDEV-10152)In 13.0,
REF CURSORcan be declared inside package routines and in aPACKAGE BODY, and used as a package routine local variable, package routine parameter, or package functionRETURNtype. It cannot yet be used as a parameter orRETURNtype for global (non-package) routines.
Support
RECORDin routine parameters and functionRETURNclause (MDEV-38768)Same scope as
REF CURSORabove: usable as a package routine parameter or package functionRETURNtype, not yet as a parameter orRETURNtype for global (non-package) routines.
Add
init_rpl_roletoSHOW VARIABLESoutput (MDEV-38202)The replication role set via the
--init-rpl-rolestartup option can now be queried withSHOW VARIABLES LIKE 'init_rpl_role'orSELECT @@init_rpl_role, instead of only being visible in the server's configuration file.
One can specify timestamp format for the audit plugin log (MDEV-18386)
Atomic
CREATE OR REPLACE TABLE(MDEV-25292)Implement
UPDATE ... RETURNINGfor single-table updates (MDEV-5092)Combined with
OLD_VALUE(), an application can read back both the pre- and post-update values of changed columns in one round trip, without a separateSELECT. Only single-tableUPDATEsupportsRETURNING; multi-tableUPDATEdoes not yet.
INFORMATION_SCHEMA.SYSTEM_VARIABLESshows if a variable is deprecated (MDEV-35369)Adds
IS_DEPRECATEDandDEPRECATED_REPLACEMENTcolumns, so tooling can query deprecation status directly instead of relying on release notes.
INFORMATION_SCHEMA.STATISTICSandINFORMATION_SCHEMA.COLUMNSshows engine specific create options (MDEV-36444)Optimizer Trace includes used optimizer statistics (MDEV-36511)
New
innodb_log_archivevariable makes InnoDB preserve the write-ahead log in a continuous sequence of files instead of overwriting a ring buffer, enabling point-in-time recovery and incremental backups (MDEV-37949)mariadb-backupdoes not yet support theinnodb_log_archive=ONlog format, and fails if run against a server running with it enabled. See InnoDB Log Archiving and Point-in-Time Recovery for the manual procedure in the meantime.
New
QB_NAME()optimizer hint (MDEV-38045)Every view, CTE, and derived table now automatically gets an implicit query block name based on its own alias, so hints can target objects inside them without adding an explicit
QB_NAME()hint first.A new locator form of
QB_NAME(),QB_NAME(name, query_block_path), lets a hint specify a path to a query block nested inside a view, CTE, or derived table that isn't reachable by its implicit or explicit name alone.
Reversed executable comments (MDEV-7381)
Notable Items
CHANGE MASTERnow resetsMaster_Server_IdinSHOW SLAVES STATUS(MDEV-15327)Faster unique indexes over
CHARcolumns in MEMORY tables (incl. temporary tables) (MDEV-21543)PERFORMANCE_SCHEMAnow usesXXH3_128hash for digest. Looks like MD5, but much faster and no problems in FIPS mode. (MDEV-31669)binlog_row_event_max_sizedefault value was increased to 64k (MDEV-37608)default_master_connectioncan now be set on global level (MDEV-9247)
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?

