[client]
port=3306
socket=/tmp/mysql.sock
default-character-set=utf8mb4
[mysqld]
master
server-id=3306225
log-bin=/mysqldata/mysql-bin
max_binlog_size=50M
max_binlog_cache_size=200M
binlog_cache_size=32M
binlog_format=row
expire_logs_days=7
transaction_isolation=READ-COMMITTED
slave_type_conversions=ALL_NON_LOSSY
binlog-ignore-db=mysql,information_schema,performance_schema,sys
symbolic-links=0
port=3306
user=mysql
basedir=/mysqlsoft/mysql
datadir=/mysqldata/data
default-storage-engine=innodb
innodb_data_home_dir=/mysqldata/data
innodb_log_group_home_dir=/mysqldata/log
socket=/tmp/mysql.sock
pid-file=/mysqldata/tmp/mysql.pid
log-error=/mysqldata/log/mysql-error.log
long_query_time=2
slow_query_log=1
slow_query_log_file=/mysqldata/log/slow.log
federated
skip-external-locking
key_buffer_size=1024M
max_allowed_packet=8M
table_open_cache=512
sort_buffer_size=2M
join_buffer_size=2M
net_buffer_length=8k
read_buffer_size=2M
read_rnd_buffer_size=2M
myisam_sort_buffer_size=8M
character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
character_set_filesystem=utf8mb4
lower_case_table_names=1
group_concat_max_len=104857600
max_connections=1000
max_connect_errors=10000
max_user_connections=0
thread_cache_size=64
#query_cache_size=0
#query_cache_type=0
open_files_limit=10240
innodb_buffer_pool_size=10240M
innodb_data_file_path=ibdata1:128M:autoextend
innodb_read_io_threads=16
innodb_write_io_threads=16
innodb_io_capacity = 600
innodb_thread_concurrency=32
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=32M
innodb_log_file_size=1024M
innodb_log_files_in_group=3
innodb_max_dirty_pages_pct=80
innodb_lock_wait_timeout=500
innodb_file_per_table=1
innodb_strict_mode=1
#innodb_file_format=barracuda
#innodb_large_prefix=on
#key
auto_increment_offset=2
auto_increment_increment=2
#explicit_defaults_for_timestamp=true
#sql_mode =STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
sql_mode =STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
default_authentication_plugin=mysql_native_password
[mysqld_safe]
basedir=/mysqlsoft/mysql
datadir=/mysqldata/data
pid-file=/mysqldata/tmp/mysql.pid
log-error=/mysqldata/log/mysql-error.log
[mysql]
default-character-set=utf8mb4
no-auto-rehash
