[mysqld]
port=4316
character_set_server=utf8
lower_case_table_names=0
max_allowed_packet=1024M
innodb_file_per_table=1
innodb_buffer_pool_size=2G
max_connections=1000
sort_buffer_size=12M
join_buffer_size=12M
bulk_insert_buffer_size=128M
innodb_flush_log_at_trx_commit=0

sql_mode=NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER

server-id = 1
log-bin = binlog
log-bin-index = binlog.index
binlog-format=mixed

 

posted on 2018-01-24 16:05  网络终结者  阅读(102)  评论(0编辑  收藏  举报