CentOS 6.3编译安装LAMP环境笔记

2019-10-14 12:38:20王旭

skip_name_resolve
sql_mode                       = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY
sysdate_is_now                     = 1
innodb                                     = FORCE
innodb_strict_mode              = 1
 
# DATA STORAGE #
datadir                                     = /usr/local/mysql/data
 
# BINARY LOGGING #
log-bin                                    =/usr/local/mysql/log/bin.log
expire_logs_days                 = 30
sync_binlog                           = 1
 
# CACHES AND LIMITS #
key_buffer                                 = 256M
max_allowed_packet              = 32M
sort_buffer_size                       = 16M
read_buffer_size                     = 4M
read_rnd_buffer_size             = 16M
thread_stack                            = 8M
tmp_table_size                        = 32M
max_heap_table_size            = 32M
query_cache_type                   = 1
query_cache_size                   = 128M