mysql 配置文件

配置文件必配置参数

[mysqld]
user=mysql
basedir=/app/database/mysql
datadir=/data/3306/
port=3306
socket=/tmp/mysql.sock
log_error=/data/3306/mysql.log
log_timestamps=system
port=3306

log_bin=/binlog/3306/mysql-bin


server_id=6
sync_binlog=1
binlog_format=row
gtid-mode=on
enforce-gtid-consistency=true

slow_query_log=1 
slow_query_log_file=/data/3306/slow.log
long_query_time=10
log_queries_not_using_indexes

secure-file-priv=/tmp
innodb_data_file_path=ibdata1:512M;ibdata2:512M;ibdata3:512M:autoextend
innodb_autoextend_increment=64
autocommit=0
innodb_flush_log_at_trx_commit=1
innodb_flush_method=fsync

innodb_log_buffer_size=16777216
innodb_log_file_size=50331648
innodb_log_files_in_group = 3

[mysql]
socket=/tmp/mysql.sock
prompt=3306 [\d]>