From daa4d512ffd73c80777bfc226ea1065c3cabde4c Mon Sep 17 00:00:00 2001 From: Seunghun Lee Date: Fri, 24 Oct 2025 14:56:02 +0100 Subject: Increase innodb_log_file_size to 2GB Sometimes test_backup at test_mariadb.sh fails with message "try increasing innodb_log_file_size". This will fix random backup failure. Closes-bug: #2129930 Change-Id: I3d7c9f9b7b060f93bf2ef408b4b4495a32ef648e Signed-off-by: Seunghun Lee --- ansible/group_vars/all/mariadb.yml | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'ansible/group_vars') diff --git a/ansible/group_vars/all/mariadb.yml b/ansible/group_vars/all/mariadb.yml index 5a5439fea..c5a14817f 100644 --- a/ansible/group_vars/all/mariadb.yml +++ b/ansible/group_vars/all/mariadb.yml @@ -34,3 +34,9 @@ mariadb_backup_target: replica mariadb_shard_root_user_prefix: "root_shard_" mariadb_shard_backup_user_prefix: "backup_shard_" mariadb_shards_info: "{{ groups['mariadb'] | database_shards_info() }}" + +# Size in mega-bytes of each InnoDB redo log file in the log group. +# Allowed minimum is 4MB and maximum is 524288MB (512GB). +# Larger values mean less disk I/O due to less flushing checkpoint activity, +# but also slower recovery from a crash. +mariadb_innodb_log_file_size_mb: 2048 -- cgit v1.2.3