Configure my.cnf default values

character-set-server is set to utf8, default is latin1 [1]
collation-server is set to utf8_general_ci, default is latin1_swedish_ci

innodb_buffer_pool_size is set to 512M, the default value is 128M.
innodb_file_format is set to Barracuda, the default value is Antelope.
innodb_file_per_table is set to 1, the default value is 0.
innodb_flush_log_at_trx_commit is set to 2, the default value is 1.
innodb_flush_method is set to O_DIRECT, the deefault value is NULL
innodb_io_capacity is set to 500, the default vaule is set to 200
innodb_read_io_threads is set to 8, the default vaue is 4
innodb_write_io_threads is set to 8, the default value is 4

open_files_limit is set to 102400, the default value is 5000 [3]

[1] https://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_character-set-server
[2] https://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html
[3] https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html

Change-Id: I5bec63612d9230ab1a69c5d32528b0021473dff1
This commit is contained in:
Sergii Golovatiuk 2016-09-29 12:22:31 +02:00
parent b7b06980b0
commit 423b3adb23
1 changed files with 14 additions and 0 deletions

View File

@ -6,10 +6,24 @@ datadir=/var/lib/mysql/
log-error=/var/log/ccp/mysql/mysql.log
max_connections=10000
character-set-server = utf8
collation-server = utf8_general_ci
log-bin=mariadb-bin
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
innodb_buffer_pool_size = 512M
innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
innodb_io_capacity = 500
innodb_read_io_threads = 8
innodb_write_io_threads =8
open_files_limit = 102400
wsrep_on=OFF
wsrep_provider="/usr/lib/galera/libgalera_smm.so"