[client]
socket = ${MYSQL_DEF_SCK}/mysqld.sock

[mysql]
socket = ${MYSQL_DEF_SCK}/mysqld.sock

# skip-host-cache
# skip-name-resolve
# datadir = ${MYSQL_DEF_DAT}
# user = ${MY_USER}
# port = 3306
# bind-address = 0.0.0.0
# socket = ${MYSQL_DEF_SCK}/mysqld.sock
# pid-file = ${MYSQL_DEF_PID}/mysqld.pid
# general_log_file = ${MYSQL_LOG_QUERY}
# slow_query_log_file = ${MYSQL_LOG_SLOW}
# log-error = ${MYSQL_LOG_ERROR}
# log-bin=/var/lib/mysql/mysql-bin
# server-id=1

[mysqld]
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
datadir		= /var/lib/mysql
log-error	= /var/log/mysql/error.log
symbolic-links=0

max_connections = 1000

log-bin=/var/lib/mysql/mysql-bin
binlog-format=ROW #选择row模式
server_id=1 #配置mysql replaction需要定义，不能和canal的slaveId重复

innodb_buffer_pool_size = 512M           
innodb_buffer_pool_instances = 1         
bulk_insert_buffer_size = 32M            
query_cache_type = 0                     
query_cache_size = 0                     
max_connections = 4096                   
max_connect_errors = 10                  
table_open_cache = 4096                  
max_allowed_packet = 512M                
binlog_cache_size = 1M                   
max_heap_table_size = 64M                
read_buffer_size = 8M                    
read_rnd_buffer_size = 16M               
sort_buffer_size = 32K                   
join_buffer_size = 32K                   
thread_cache_size = 64