my.cnf配置

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[client]
port = 3306
socket = /usr/local/dbfiles/mysql/mysql.sock

[mysqld]
#指定mysql启动用户
user = mysql

#开启并指定binlog日志
log-bin=/usr/local/dbfiles/mysql/mysql-bin
#设定数据库中自动增长的起点
auto-increment-increment = 2
auto-increment-offset = 1001

#指定基础目录
basedir = /usr/local/mysql
#指定数据的存储路径
datadir = /usr/local/dbfiles/mysql
#指定使用myslq.sock
socket = /usr/local/dbfiles/mysql/mysql.sock
#指定error日志
log-error = error.log

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

innodb_flush_method=O_DIRECT
max_connections=1024
back_log=384
wait_timeout=60
interactive_timeout=7200
key_buffer_size=512M
query_cache_size=1024M
query_cache_type=1
query_cache_limit=1024M
max_connect_errors=20
sort_buffer_size=64M
max_allowed_packet=32M
join_buffer_size=16M
thread_cache_size=200
innodb_buffer_pool_size=2048M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=32M
innodb_log_file_size=128M
innodb_log_files_in_group=3
binlog_cache_size=8M
max_binlog_cache_size=32M
max_binlog_size=512M
read_buffer_size=32M
read_rnd_buffer_size=64M
bulk_insert_buffer_size=64M
tmp_table_size = 256M
innodb_thread_concurrency=8
max_length_for_sort_data=8192