一個mysql的master的my.cnf

標籤：一個mysql的master的my.cnf

[mysqld]

port= 3306

socket= /tmp/mysql.sock

datadir=/data/mysql/data

server-id= 1

skip-name-resolve

expire_logs_days=15

log-bin=mysql-bin

binlog_format=mixed

replicate-do-db=allin_platform

replicate-do-db=allin_platform_log

slow_query_log = ON

long_query_time = 2

slow_query_log_file=/data/mysql/data/mysql-master-slow.log

#explicit_defaults_for_timestamp=true

query_cache_type=1   

key_buffer_size = 512M

max_allowed_packet = 8M

#table_open_cache = 2000

sort_buffer_size = 16M

#net_buffer_length = 8K

read_buffer_size = 32M

#read_rnd_buffer_size = 256K

myisam_sort_buffer_size = 16M

default-storage-engine=INNODB

max_connections=500

innodb_log_buffer_size=16M

innodb_buffer_pool_size=2048M

character_set_server=utf8 

innodb_sort_buffer_size = 8M

#innodb_buffer_pool_instances = 8

#innodb_flush_log_at_trx_commit = 1

innodb_file_per_table = OFF

#open_files_limit = 10000

query_cache_limit = 4M

query_cache_size = 512M

[client]

port              = 3306

socket          = /tmp/mysql.sock

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-auto-rehash

[myisamchk]

key_buffer_size = 20M

sort_buffer_size = 20M

read_buffer = 2M

write_buffer = 2M

[mysqlhotcopy]

interactive-timeout

一個mysql的master的my.cnf