MariaDB 10.6 has a number of features that can be very useful for us (https://mariadb.com/kb/en/changes-improvements-in-mariadb-106/) like:
- Ignored Indexes
- Native sys DB support
- binlog_expire_logs_seconds
- CREATE, ALTER, DROP and RENAME are crash safe
A bunch of options have been removed, so we'd need to double check if we are still using them: (investigation at: T301879#7759265)
innodb_adaptive_max_sleep_delay innodb_background_scrub_data_check_interval innodb_background_scrub_data_compressed innodb_background_scrub_data_interval innodb_background_scrub_data_uncompressed innodb_buffer_pool_instances innodb_commit_concurrency innodb_concurrency_tickets innodb_file_format innodb_large_prefix innodb_lock_schedule_algorithm innodb_log_checksums innodb_log_compressed_pages innodb_log_files_in_group innodb_log_optimize_ddl innodb_page_cleaners innodb_replication_delay innodb_scrub_log innodb_scrub_log_speed innodb_sync_array_size innodb_thread_concurrency innodb_thread_sleep_delay innodb_undo_logs