September 20, 2020

MariaDB 10.5.5 releases, MySQL branch version

3 min read
MariaDB database management system is a branch of MySQL, mainly by the open-source community in the maintenance, using GPL license. MariaDB is designed to be fully compatible with MySQL, including API and command line.

MariaDB 10.5.5 is released, the main updates for this release include:

Deprecated variables

InnoDB

Replication

  • Make the binlog dump thread to log into errorlog a requested GTID position (MDEV-20428)
  • Fix stop of the optimistic parallel slave at requested START-SLAVE-UNTIL position (MDEV-15152)
  • Properly handle RESET MASTER TO value, when the value exceeds the max allowed 2147483647 (MDEV-22451)
  • Correct ‘relay-log.info’ updating by concurrent parallel workers (MDEV-22806)
  • Eliminate deadlock involving parallel workers, STOP SLAVE and FLUSH TABLES WITH READ LOCK (MDEV-23089)
  • Correct master-slave automatic reconnection by slave to always pass through all steps of the initial connect. Specifically, do not skip master notification about slave binlog checksum awareness (MDEV-14203)
  • Refine mysqlbinlog output to print out START TRANSACTION at Gtid_log_event processing which satisfies clients that submit the output with sql_mode=oracle (MDEV-23108)
  • Replication aborts with ER_SLAVE_CONVERSION_FAILED upon CREATE ... SELECT in ORACLE mode (MDEV-19632)

Optimizer

  • ALTER TABLE … ANALYZE PARTITION … with EITS reads and locks all rows … (MDEV-21472)
  • Print ranges in the optimizer trace created for non-indexed columns when optimizer_use_condition_selectivity >2 Now the optimizer trace shows the ranges constructed while getting estimates from EITS (MDEV-22665)
  • LATERAL DERIVED is not clearly visible in EXPLAIN FORMAT=JSON, make LATERAL DERIVED tables visible in EXPLAIN FORMAT=JSON output (MDEV-17568)
  • Crash on WITH RECURSIVE large query (MDEV-22748)
  • Crash with Prepared Statement with a ‘?’ parameter inside a re-used CTE (MDEV-22779)

Other

Download