MariaDB

パラメータ内容 [#s2548f9f]

これだけは最低限記述しておいて、あとからサーバーごとに調整しようっていう値。

 # cd /etc/
 # cp -p my.cnf mysql.org
 # vim my.cnf
 [mysqld]
 skip-character-set-client-handshake
 character-set-server=utf8
 collation-server = utf8_general_ci
 init-connect = SET NAMES utf8
 
 # common
 max_connections = 1000
 interactive_timeout = 3600
 lock_wait_timeout = 3600
 wait_timeout = 3600
 
 # MyISAM
 key_buffer_size=8M
 thread_cache_size=16
 query_cache_limit=5M
 query_cache_min_res_unit=4k
 query_cache_size=8M
 query_cache_type=1
 sort_buffer_size=8M
 read_buffer_size=8M
 join_buffer_size=8M
 read_rnd_buffer_size=8M
 
 # InnoDB
 innodb_buffer_pool_size=1024M
 innodb_additional_mem_pool_size=16M
 innodb_log_file_size=512M
 innodb_log_buffer_size=16M
 innodb_file_per_table = 1
 
 [client]
 default-character-set=utf8