diff options
| author | Seunghun Lee <seunghun@stackhpc.com> | 2025-10-24 14:56:02 +0100 |
|---|---|---|
| committer | Seunghun Lee <seunghun@stackhpc.com> | 2025-10-30 09:30:48 +0000 |
| commit | daa4d512ffd73c80777bfc226ea1065c3cabde4c (patch) | |
| tree | bc7f23aad92aac969f050c382b86aa9551350c27 /ansible/group_vars | |
| parent | ea5675f49941b33eb0dd465e0a7f7b9092917b93 (diff) | |
| download | kolla-ansible-daa4d512ffd73c80777bfc226ea1065c3cabde4c.tar.gz kolla-ansible-daa4d512ffd73c80777bfc226ea1065c3cabde4c.zip | |
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 <seunghun@stackhpc.com>
Diffstat (limited to 'ansible/group_vars')
| -rw-r--r-- | ansible/group_vars/all/mariadb.yml | 6 |
1 files changed, 6 insertions, 0 deletions
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 |