diff options
| author | Jenkins <jenkins@review.openstack.org> | 2016-11-06 21:26:07 +0000 |
|---|---|---|
| committer | Gerrit Code Review <review@openstack.org> | 2016-11-06 21:26:07 +0000 |
| commit | 8b830f5e1a0af8bf2c1600c22fb2c49ce4f18d69 (patch) | |
| tree | e697fc57cc26e56d0fa3b48d73e1552a3dd6de8b | |
| parent | 57f7df7b703c2d785ecaaa49f937f9965634d646 (diff) | |
| parent | 2d95514b5936e7ef9fce29183718814f5ea745d6 (diff) | |
| download | kolla-8b830f5e1a0af8bf2c1600c22fb2c49ce4f18d69.tar.gz kolla-8b830f5e1a0af8bf2c1600c22fb2c49ce4f18d69.zip | |
Merge "Mariadb performance tuning"
| -rw-r--r-- | ansible/roles/mariadb/templates/galera.cnf.j2 | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/ansible/roles/mariadb/templates/galera.cnf.j2 b/ansible/roles/mariadb/templates/galera.cnf.j2 index 3d7eb938e..d74c74f29 100644 --- a/ansible/roles/mariadb/templates/galera.cnf.j2 +++ b/ansible/roles/mariadb/templates/galera.cnf.j2 @@ -43,5 +43,15 @@ wsrep_notify_cmd=/usr/local/bin/wsrep-notify.sh max_connections=10000 +key_buffer_size = '64M' +max_heap_table_size = '64M' +tmp_table_size = '64M' +{% set dynamic_pool_size_mb = (hostvars[inventory_hostname]['ansible_memtotal_mb'] * 0.4) | round | int %} +{% if dynamic_pool_size_mb < 8192 %} +innodb_buffer_pool_size = '{{ dynamic_pool_size_mb }}M' +{% else %} +innodb_buffer_pool_size = '8192M' +{% endif %} + [server] pid-file=/var/lib/mysql/mariadb.pid |