Software-update: MariaDB 11.0.2 / 10.11.4 / 10.10.5 / 10.9.7 / 10.6.14 / 10.5.21 / 10.4.30
MariaDB is ontstaan als fork van MySQL, nadat dit door Oracle werd overgenomen. Voor een overzicht van de verschillen tussen MariaDB en MySQL kun je op deze en deze pagina's terecht. MariaDB is een krachtige opensourcedatabaseserver, die vooral populair is als website- en forumdatabase. De ontwikkelaars hebben begin deze maand versies 11.0.2, 10.11.4, 10.10.5, 10.9.7, 10.6.14, 10.5.21 en 10.4.30 uitgebracht. De belangrijkste veranderingen en verbeteringen die in deze versies zijn aangebracht zijn hieronder voor je op een rijtje gezet:
MariaDB 11.0.2 Release NotesInnoDBInnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)InnoDB hang fixes (MDEV-31158, MDEV-31343, MDEV-31350)Innodb_buffer_pool_read_requests is not updated correctly (MDEV-31309)InnoDB monitor trx_rseg_history_len was accidentally disabled by default (MDEV-31308)Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"OptimizerNew optimizer_switch option, hash_join_cardinality, is added. It is ON by default. When set to ON, the optimizer will produce tighter bounds for hash join output cardinality. (MDEV-30812)Crash with condition pushable into derived and containing outer reference (MDEV-31403 MDEV-31240)Crash with EXPLAIN EXTENDED for multi-table update of system table (MDEV-31224)
InnoDBInnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)InnoDB hang fixes (MDEV-31158, MDEV-31343, MDEV-31350)Innodb_buffer_pool_read_requests is not updated correctly (MDEV-31309)InnoDB monitor trx_rseg_history_len was accidentally disabled by default (MDEV-31308)Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"InnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)InnoDB hang fixes (MDEV-31158, MDEV-31343, MDEV-31350)Innodb_buffer_pool_read_requests is not updated correctly (MDEV-31309)InnoDB monitor trx_rseg_history_len was accidentally disabled by default (MDEV-31308)Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"
InnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)InnoDB hang fixes (MDEV-31158, MDEV-31343, MDEV-31350)Innodb_buffer_pool_read_requests is not updated correctly (MDEV-31309)InnoDB monitor trx_rseg_history_len was accidentally disabled by default (MDEV-31308)Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"OptimizerNew optimizer_switch option, hash_join_cardinality, is added. It is ON by default. When set to ON, the optimizer will produce tighter bounds for hash join output cardinality. (MDEV-30812)Crash with condition pushable into derived and containing outer reference (MDEV-31403 MDEV-31240)Crash with EXPLAIN EXTENDED for multi-table update of system table (MDEV-31224)New optimizer_switch option, hash_join_cardinality, is added. It is ON by default. When set to ON, the optimizer will produce tighter bounds for hash join output cardinality. (MDEV-30812)Crash with condition pushable into derived and containing outer reference (MDEV-31403 MDEV-31240)Crash with EXPLAIN EXTENDED for multi-table update of system table (MDEV-31224)
New optimizer_switch option, hash_join_cardinality, is added. It is ON by default. When set to ON, the optimizer will produce tighter bounds for hash join output cardinality. (MDEV-30812)Crash with condition pushable into derived and containing outer reference (MDEV-31403 MDEV-31240)Crash with EXPLAIN EXTENDED for multi-table update of system table (MDEV-31224)MariaDB 10.11.4 Release NotesInnoDBServer crashes in st_join_table::choose_best_splitting (MDEV-31403)Crash with condition pushable into derived and containing outer reference (MDEV-31240)InnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)InnoDB hang fixes (MDEV-31158, MDEV-31343, MDEV-31350)Innodb_buffer_pool_read_requests is not updated correctly (MDEV-31309)InnoDB monitor trx_rseg_history_len was accidentally disabled by default (MDEV-31308)Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"OptimizerCrash with condition pushable into derived and containing outer reference (MDEV-31403 MDEV-31240)Crash with EXPLAIN EXTENDED for multi-table update of system table (MDEV-31224)
InnoDBServer crashes in st_join_table::choose_best_splitting (MDEV-31403)Crash with condition pushable into derived and containing outer reference (MDEV-31240)InnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)InnoDB hang fixes (MDEV-31158, MDEV-31343, MDEV-31350)Innodb_buffer_pool_read_requests is not updated correctly (MDEV-31309)InnoDB monitor trx_rseg_history_len was accidentally disabled by default (MDEV-31308)Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"Server crashes in st_join_table::choose_best_splitting (MDEV-31403)Crash with condition pushable into derived and containing outer reference (MDEV-31240)InnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)InnoDB hang fixes (MDEV-31158, MDEV-31343, MDEV-31350)Innodb_buffer_pool_read_requests is not updated correctly (MDEV-31309)InnoDB monitor trx_rseg_history_len was accidentally disabled by default (MDEV-31308)Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"
Server crashes in st_join_table::choose_best_splitting (MDEV-31403)Crash with condition pushable into derived and containing outer reference (MDEV-31240)InnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)InnoDB hang fixes (MDEV-31158, MDEV-31343, MDEV-31350)Innodb_buffer_pool_read_requests is not updated correctly (MDEV-31309)InnoDB monitor trx_rseg_history_len was accidentally disabled by default (MDEV-31308)Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"OptimizerCrash with condition pushable into derived and containing outer reference (MDEV-31403 MDEV-31240)Crash with EXPLAIN EXTENDED for multi-table update of system table (MDEV-31224)Crash with condition pushable into derived and containing outer reference (MDEV-31403 MDEV-31240)Crash with EXPLAIN EXTENDED for multi-table update of system table (MDEV-31224)
Crash with condition pushable into derived and containing outer reference (MDEV-31403 MDEV-31240)Crash with EXPLAIN EXTENDED for multi-table update of system table (MDEV-31224)MariaDB 10.10.5 Release NotesInnoDBServer crashes in st_join_table::choose_best_splitting (MDEV-31403)Crash with condition pushable into derived and containing outer reference (MDEV-31240)InnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)InnoDB hang fixes (MDEV-31158, MDEV-31343, MDEV-31350)Innodb_buffer_pool_read_requests is not updated correctly (MDEV-31309)InnoDB monitor trx_rseg_history_len was accidentally disabled by default (MDEV-31308)Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"OptimizerCrash with condition pushable into derived and containing outer reference (MDEV-31403 MDEV-31240)Crash with EXPLAIN EXTENDED for multi-table update of system table (MDEV-31224)
InnoDBServer crashes in st_join_table::choose_best_splitting (MDEV-31403)Crash with condition pushable into derived and containing outer reference (MDEV-31240)InnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)InnoDB hang fixes (MDEV-31158, MDEV-31343, MDEV-31350)Innodb_buffer_pool_read_requests is not updated correctly (MDEV-31309)InnoDB monitor trx_rseg_history_len was accidentally disabled by default (MDEV-31308)Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"Server crashes in st_join_table::choose_best_splitting (MDEV-31403)Crash with condition pushable into derived and containing outer reference (MDEV-31240)InnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)InnoDB hang fixes (MDEV-31158, MDEV-31343, MDEV-31350)Innodb_buffer_pool_read_requests is not updated correctly (MDEV-31309)InnoDB monitor trx_rseg_history_len was accidentally disabled by default (MDEV-31308)Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"
Server crashes in st_join_table::choose_best_splitting (MDEV-31403)Crash with condition pushable into derived and containing outer reference (MDEV-31240)InnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)InnoDB hang fixes (MDEV-31158, MDEV-31343, MDEV-31350)Innodb_buffer_pool_read_requests is not updated correctly (MDEV-31309)InnoDB monitor trx_rseg_history_len was accidentally disabled by default (MDEV-31308)Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"OptimizerCrash with condition pushable into derived and containing outer reference (MDEV-31403 MDEV-31240)Crash with EXPLAIN EXTENDED for multi-table update of system table (MDEV-31224)Crash with condition pushable into derived and containing outer reference (MDEV-31403 MDEV-31240)Crash with EXPLAIN EXTENDED for multi-table update of system table (MDEV-31224)
Crash with condition pushable into derived and containing outer reference (MDEV-31403 MDEV-31240)Crash with EXPLAIN EXTENDED for multi-table update of system table (MDEV-31224)MariaDB 10.9.7 Release NotesInnoDBServer crashes in st_join_table::choose_best_splitting (MDEV-31403)Crash with condition pushable into derived and containing outer reference (MDEV-31240)InnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)InnoDB hang fixes (MDEV-31158, MDEV-31343, MDEV-31350)Innodb_buffer_pool_read_requests is not updated correctly (MDEV-31309)InnoDB monitor trx_rseg_history_len was accidentally disabled by
Source: Tweakers.net