[client]
port = 22066
socket = /usr/local/mysql/mysqld.sock

# The MySQL server
[mysqld]
port = 22066
socket = /usr/local/mysql/mysqld.sock
datadir = /usr/local/db/mysql/data
skip-external-locking
skip-name-resolve
back_log = 100
max_connections = 2048
max_connect_errors = 30
table_open_cache = 2048
open_files_limit = 16384
max_allowed_packet = 256M
read_buffer_size = 8M
read_rnd_buffer_size = 32M
sort_buffer_size = 2M
join_buffer_size = 2M
thread_cache_size = 16
query_cache_size = 128M
query_cache_limit = 4M
slow_query_log = 1
long_query_time = 2
lower_case_table_names = 1
innodb_file_per_table = 1
max_allowed_packet = 64M
server-id = 1
log-bin = mysql-bin
expire_logs_days = 7
binlog_format = ROW

#加载密码复杂度审计插件
#plugin-load=simple_password_check.so
#密码长度，默认8位
#simple_password_check_minimal_length=8
#特殊符号，1代表至少1位
#simple_password_check_other_characters=1
#字母数，1代表至少1位
#simple_password_check_letters_same_case=1
#数字数，1代表至少1位
#simple_password_check_digits=1
#默认密码过期时间 单位天 每过30天就要修改密码
#default_password_lifetime=30
#最大错误登录次数
#max_password_errors=5


innodb_data_file_path = ibdata1:10M:autoextend
innodb_buffer_pool_size = 2G
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 800M
innodb_log_file_size = 500M
innodb_strict_mode = 0
innodb_lock_wait_timeout = 60