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.
|
|
|
|
|
[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
|
