mysql

[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