diff options
author | 2016-02-15 22:14:45 -0500 | |
---|---|---|
committer | 2016-02-24 01:54:19 -0500 | |
commit | e72bc045fd467a442a0ffb1c78e710a270a59dfa (patch) | |
tree | de36cb10caf65af125d3815733c92abd561d8866 /deploy/adapters/ansible/roles/database/templates/my_redhat.cnf | |
parent | 00ba12cbc900cb1cb38bee938544cc95583ab416 (diff) |
Support version Liberty of OpenStack for CENTOS7
JIRA:COMPASS-315
-Support version Liberty of OpenStack for CENTOS7
Change-Id: I81abbb37a295a0ea733398ad1f278bafc3525d87
Signed-off-by: grakiss <grakiss.wanglei@huawei.com>
Diffstat (limited to 'deploy/adapters/ansible/roles/database/templates/my_redhat.cnf')
-rw-r--r-- | deploy/adapters/ansible/roles/database/templates/my_redhat.cnf | 59 |
1 files changed, 59 insertions, 0 deletions
diff --git a/deploy/adapters/ansible/roles/database/templates/my_redhat.cnf b/deploy/adapters/ansible/roles/database/templates/my_redhat.cnf new file mode 100644 index 00000000..68e0fca2 --- /dev/null +++ b/deploy/adapters/ansible/roles/database/templates/my_redhat.cnf @@ -0,0 +1,59 @@ +[client] +port = 3306 +socket = /var/run/mysqld/mysqld.sock + + +[mysqld_safe] +socket = /var/run/mysqld/mysqld.sock +nice = 0 + + +[mysql] +default-character-set = utf8 + +[mysqld] +user = mysql +collation-server = utf8_unicode_ci +init-connect = 'SET NAMES utf8' +character-set-server = utf8 +datadir = /var/lib/mysql +bind-address = {{ internal_ip }} + +max-allowed-packet = 16M +max-connect-errors = 1000000 + +max_connections = {{ ansible_processor_vcpus * 100 }} + +wait_timeout = 28800 +tmp-table-size = 32M +max-heap-table-size = 32M +query-cache-type = 0 +query-cache-size = 0M +thread-cache-size = 50 +open-files-limit = 65535 +table-definition-cache = 4096 +table-open-cache = 10240 + +innodb-flush-method = O_DIRECT +innodb-additional-mem-pool-size = 24M +innodb-log-file-size = 1024M +innodb-file-per-table = 1 +innodb-buffer-pool-size = 4096M + +innodb-read-io-threads = 4 +innodb-write-io-threads = 4 +innodb-doublewrite = 1 +innodb-log-buffer-size = 1024M +innodb-buffer-pool-instances = 8 +innodb-log-files-in-group = 2 +innodb-thread-concurrency = {{ ansible_processor_vcpus * 2 }} + +innodb_stats_on_metadata = 0 + +[mysqldump] +quick +quote-names +max_allowed_packet = 16M + + +!includedir /etc/my.cnf.d/ |