Software Update: MariaDB 10.5.16 / 10.6.8 / 10.7.4 / 10.8.3 / 10.9.1RC

Spread the love

MariaDB originated as a fork of MySQL, after it was taken over by Oracle. For an overview of the differences between MariaDB and MySQL you can visit: this one and this one pages right. MariaDB is a powerful open source database server, which is especially popular as a website and forum database. The developers have versions 10.5.1610.6.810.7.410.8.3 and 10.9.1 released. The most important changes and improvements made in version 10.8.3 are listed below:

InnoDB

Replication

  • Semisync-slave server recovery is refined to correctly rollback prepared transaction (MDEV-28461
  • Circular semisync setup endless event circulation is handled (MDEV-27760
  • Semisync-slave server recovery is extended to work on new server_id server (MDEV-27342
  • Server initialization time gtid_slave_pos purge related reason of crashing in binlog background thread is removed (MDEV-26473
  • Shutdown of the semisync master can’t produce inconsistent state anymore (MDEV-11853
  • Blogs disappear after rsync IST (MDEV-28583
  • autocommit=0 slave hang is eliminated (DBAAS-7828)
  • master crash is eliminated in compressed semisync replication protocol with packet counting amendment (MDEV-25580
  • OPTIMIZE on a sequence does not cause counterfactual ER_BINLOG_UNSAFE_STATEMENT anymore (MDEV-24617
  • Automatically generated Gtid_log_list_event is made to recognize within replication event group as a formal member (MDEV-28550
  • Replication unsafe INSERT .. ON DUPLICATE KEY UPDATE using two or more unique key values ​​at a time with MIXED format binlogging is corrected (MDEV-28310
  • Replication unsafe INSERT .. ON DUPLICATE KEY UPDATE stops issuing unnessary “Unsafe statement” with MIXED binlog format (MDEV-21810
  • Incomplete replication event groups are detected to error out by the slave IO thread (MDEV-27697
  • mysqlbinlog –stop-never –raw now flushes the result file to disk after each processed event so the file can be listed with the actual bytes (MDEV-14608

backup

  • Incorrect binlogs after Galera SST using rsync and mariabackup (MDEV-27524
  • mariabackup does not detect multi-source replication slave (MDEV-21037
  • Useless warning “InnoDB: Allocated tablespace ID
  • mariabackup prepare fails for incrementals if a new schema is created after full backup is taken (MDEV-28446

Optimizer

  • Query performance degradation in newer MariaDB versions when using many tables (MDEV-28073
  • A SEGV in Item_field::used_tables/update_depend_map_for_order… (MDEV-26402
  • ANALYZE FORMAT=JSON fields are incorrect for UNION ALL queries (MDEV-27699
  • Subquery in an UPDATE query uses full scan instead of range (MDEV-22377
  • Assertion `item1->type() == Item::FIELD_ITEM … (MDEV-19398
  • Server crashes in Expression_cache_tracker::fetch_current_stats (MDEV-28268
  • MariaDB server crash at Item_subselect::init_expr_cache_tracker (MDEV-26164MDEV-26047
  • Crash with union of my_decimal type in ORDER BY clause (MDEV-25994
  • SIGSEGV in st_join_table::cleanup(MDEV-24560
  • Assertion `!eliminated’ failed in Item_subselect::exec (MDEV-28437

spider

General

  • Server error messages are now available in ChineseMDEV-28227
  • For RHEL/CentOS 7, non x86_64 architectures are no longer supported upstream and so our support will also be dropped with this release
  • Packages for Ubuntu 22.04 LTS “Jammy” and Fedora 36 are now available in this release

changelog

For a complete list of changes made in MariaDB 10.8.3with links to detailed information on each push, see the changelog

Version number 10.5.16 / 10.6.8 / 10.7.4 / 10
Release status Final
Operating systems Windows 7, Linux, BSD, macOS, Solaris, Windows Server 2008, Windows Server 2012, Windows 8, Windows 10, Windows Server 2016, Windows Server 2019, Windows 11
Website MariaDB
Download
License type Conditions (GNU/BSD/etc.)
.fb-background-color { background: #ffffff !important; } .fb_iframe_widget_fluid_desktop iframe { width: 100% !important; }
FedoraFreeBSDLTSMariaDBMySQLSoftwareUbuntuWindowsWindows Server
Share