[mysqld]
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
socket = /tmp/mysql.sock
local-infile=0
skip_symbolic_links=yes
lower_case_table_names=1
key_buffer_size = 16M
max_allowed_packet = 100M
table_open_cache = 64
sort_buffer_size = 8M
join_buffer_size = 8M
net_buffer_length = 512K
read_buffer_size = 8M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 32M
max_connections = 1000
#default-storage-engine = MYISAM
default_storage_engine=InnoDB
log-bin = mysql-bin
binlog_format = mixed
server-id = 1
character_set_server=utf8mb4
auto-increment-increment = 1
auto-increment-offset = 1
slave-skip-errors = all
event_scheduler = on
skip-name-resolve
local-infile=0
skip_symbolic_links=yes
innodb_open_files=10240
open_files_limit=20480
join_buffer_size = 2M
tmp_table_size = 64M
max_heap_table_size = 64M
table_open_cache = 128M
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER
