mysql-my.cnf

2018/01/15 08:45
阅读数 17

[client]
port=3306
socket=/mysql/conf/mysql.sock

#The MySQL server
[mysqld]
server_id=0612
port=3306
user=mysql
socket=/mysql/conf/mysql.sock
pid-file=/mysql/conf/mysql.pid
basedir=/mysql
datadir=/mysql/data
tmpdir=/mysql/tmp
open_files_limit=10240
explicit_defaults_for_timestamp
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
federated
secure_file_priv='/mysql/tmp'

#Buffer
max_allowed_packet=256M
max_heap_table_size=256M
net_buffer_length=8k
sort_buffer_size=2M
join_buffer_size=4M
read_buffer_size=2M
read_rnd_buffer_size=16M

#log
log-bin=/mysql/binlog/mysql-bin
binlog_cache_size=32M
max_binlog_cache_size=512M
max_binlog_size=512M
binlog_format=mixed
log_output=FILE
log-error=/mysql/logs/mysql-error.log
slow_query_log=1
slow_query_log_file=/mysql/logs/slow_query.log
general_log=0
general_log_file=/mysql/logs/general_query.log
expire-logs-days=14
relay-log=/mysql/relaylog/mysql-relay-bin
relay-log-index=/mysql/relaylog/mysql-relay-bin.index
master-info-file=/mysql/conf/master.info
relay-log-info-file=/mysql/conf/relay-log.info
#InnoDB
innodb_data_file_path=ibdata1:2048M:autoextend
innodb_log_file_size=256M

#replcation_slave
rpl_semi_sync_slave_enabled=1

innodb_log_files_in_group=3
innodb_buffer_pool_size=10240M

[mysql]
auto-rehash
prompt=\u@\d>\
#prompt=(\u@\h) [\d]>\
default-character-set=gbk

展开阅读全文
打赏
0
0 收藏
分享
加载中
更多评论
打赏
0 评论
0 收藏
0
分享
返回顶部
顶部