You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.
[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
#密码长度，
#simple_password_check_minimal_length=8
#特殊符号，
#simple_password_check_other_characters=1
#字母数，
#simple_password_check_letters_same_case=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
