Page MenuHomePhorge
Files F117754774

No OneTemporary
Actions

Authored By
Unknown
Size
1 KB
Referenced Files
None
Subscribers
None

View Options

diff --git a/deployments/ansible/roles/kolab-node/files/my.cnf.j2 b/deployments/ansible/roles/kolab-node/files/my.cnf.j2
index da91b50..c13fc9d 100644
--- a/deployments/ansible/roles/kolab-node/files/my.cnf.j2
+++ b/deployments/ansible/roles/kolab-node/files/my.cnf.j2
@@ -1,45 +1,47 @@
[galera]
wsrep_on=1
#wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
#wsrep_provider_options="gcache.size=4G; gcache.page_size=4G"
wsrep_cluster_name="kolab"
wsrep_cluster_address="gcomm://{{ primary_ip }},{{ secondary_ip }}"
wsrep_sst_method=rsync
# Temporary change to force the resync donor
#wsrep_sst_donor="hostname"
bind-address={{ bind_address }}
[mysqld]
binlog_format=row
datadir=/data/mysql
default_storage_engine=innodb
innodb_autoinc_lock_mode=2
-#innodb_buffer_pool_size=8G
+# Set to ~50% - 75% of available system memory
+innodb_buffer_pool_size={{ mariadb_innodb_buffer_pool_size | default('1G') }}
innodb_defragment=1
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=0
-#innodb_log_file_size=4G
+innodb_log_file_size={{ mariadb_innodb_log_file_size | default('256M') }}
+innodb_log_buffer_size={{ mariadb_innodb_log_buffer_size | default('128M') }}
long_query_time=1
max_allowed_packet=68M
-max_connections=4096
+max_connections=512
max_heap_table_size=512M
query_cache_type=1
query_cache_limit=64M
query_cache_min_res_unit=1K
-#query_cache_size=256M
+query_cache_size={{ mariadb_query_cache_size | default('8M') }}
slow_query_log=0
slow_query_log_file=/var/log/mariadb/slow.log
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
-table_open_cache=100
+table_open_cache=300
thread_cache_size=20
#tmpdir=/var/tmp/mariadb
#tmp_table_size=512M
user=mysql
wait_timeout = 3600
lower_case_table_names = 0
[mysqld_safe]
log-error=/var/log/mariadb/error.log
pid-file=/var/run/mariadb/mariadb.pid

File Metadata

Mime Type
text/x-diff
Expires
Sat, Apr 4, 7:20 AM (1 w, 4 d ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
18822989
Default Alt Text
(1 KB)

Event Timeline