summaryrefslogtreecommitdiffstats
path: root/setup
diff options
context:
space:
mode:
authorSuren A. Chilingaryan <csa@suren.me>2018-03-24 03:05:47 +0100
committerSuren A. Chilingaryan <csa@suren.me>2018-03-24 03:05:47 +0100
commit5a15f65db3dfb245919bdd534e93bd711db2eb60 (patch)
tree431e6cc7476a0c2e135983a937a9d2e6f184fe5e /setup
parentc163108c0c0c7b7a4f05da411e98ac0f503e31e0 (diff)
downloadands-5a15f65db3dfb245919bdd534e93bd711db2eb60.tar.gz
ands-5a15f65db3dfb245919bdd534e93bd711db2eb60.tar.bz2
ands-5a15f65db3dfb245919bdd534e93bd711db2eb60.tar.xz
ands-5a15f65db3dfb245919bdd534e93bd711db2eb60.zip
Minor tunning
Diffstat (limited to 'setup')
-rw-r--r--setup/projects/adei/vars/mysql.yml7
1 files changed, 3 insertions, 4 deletions
diff --git a/setup/projects/adei/vars/mysql.yml b/setup/projects/adei/vars/mysql.yml
index 072d946..dd9aa0e 100644
--- a/setup/projects/adei/vars/mysql.yml
+++ b/setup/projects/adei/vars/mysql.yml
@@ -26,8 +26,8 @@ mysql:
- { name: "MYSQL_MASTER_PASSWORD", value: "secret@adei/service-password" }
- { name: "MYSQL_PMA_PASSWORD", value: "secret@adei/pma-password" }
- { name: "MYSQL_MAX_CONNECTIONS", value: "500" }
- - { name: "MYSQL_INNODB_BUFFER_POOL_SIZE", value: "32G" }
- - { name: "MYSQL_INNODB_BUFFER_POOL_INSTANCES", value: "32" }
+ - { name: "MYSQL_INNODB_BUFFER_POOL_SIZE", value: "16G" }
+ - { name: "MYSQL_INNODB_BUFFER_POOL_INSTANCES", value: "8" }
- { name: "MYSQL_INNODB_LOG_FILE_SIZE", value: "2G" }
- { name: "MYSQL_INNODB_LOG_BUFFER_SIZE", value: "16M" }
- { name: "MYSQL_SYNC_BINLOG", value: "0" }
@@ -36,9 +36,8 @@ mysql:
- { name: "MYSQL_INNODB_FLUSH_LOG_TYPE", value: "2" }
- { name: "MYSQL_INNODB_FLUSH_METHOD", value: "O_DIRECT" }
- { name: "MYSQL_INNODB_FLUSH_LOG_TIMEOUT", value: "300" }
-# - { name: "MYSQL_BINLOG_FORMAT", value: "MIXED" }
- { name: "MYSQL_BINLOG_FORMAT", value: "ROW" }
-# - { name: "MYSQL_BINLOG_FORMAT", value: "STATEMENT" }
+# - { name: "MYSQL_BINLOG_FORMAT", value: "MIXED" }
mappings:
- { name: "adei_master", mount: "/var/lib/mysql/data" }
resources: { request: { cpu: 2000m, mem: 16Gi } }