socket = /data/mysql57/db3306/mysql.sock
basedir = /data/mysql57
datadir = /data/mysql57/data/db3306
tmpdir = /data/mysql57/data/db3306
pid-file = /data/mysql57/db3306/mysql.pid
user = mysql
#bind-address = 192.168.107.157
bind-address = 0.0.0.0
server-id = 1071573175
log-error = /data/mysql57/db3306/mysql-error.log
slow_query_log = 1
long_query_time = 1
log_queries_not_using_indexes = 1
slow_query_log_file = /data/mysql57/db3306/mysql-slow.log
#performance_schema = 0
explicit_defaults_for_timestamp
lower_case_table_names = 1
skip-external-locking
log_timestamps=SYSTEM
#sql_mode=‘STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTIO
N’
评论