MYSQL之三(32G 配置文件MY.CNF)

------------------------------------------  主库 DB01 MY.CNF -----------------------------------------------------------

[mysqld]
datadir=/data/mysql
socket=/data/mysql/mysql.sock
user=mysql

#old_passwords=1

# default
character-set-server=utf8
default-storage-engine=INNODB

skip-slave-start
skip-name-resolve

# buffer cache
max_connections = 10000
key_buffer_size = 256M
myisam_sort_buffer_size = 64M
join_buffer_size = 8M
read_buffer_size = 4M
sort_buffer_size = 8M
table_cache = 2048
interactive_timeout = 1000
innodb_buffer_pool_size = 8G

tmp_table_size = 256M

# max
max_allowed_packet = 60M
max_connect_errors = 10
max_heap_table_size = 256M

# query
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1

# thread
#thread_cache = 24
thread_cache_size = 196
thread_concurrency = 16
group_concat_max_len = 10240
back_log = 50
wait_timeout = 600

# log
slow-query-log=ON
slow-query-log-file=/var/log/slow-queries.log
long_query_time=5
log-slow-admin-statements
log-queries-not-using-indexes
#log_queries_not_using_indexes
#log-slow-admin-statements

#log=/var/log/queries_log.log
log-error=/var/log/mysqld.log
#log-queries-not-using-indexes=1
#long_query_time = 5

ft_min_word_len = 2

expire_logs_days = 5

log-bin=mysql-bin
log_bin = /data/mysql/mysql-bin.log
log_bin_index = /data/mysql/mysql-bin.log.index
log-bin-trust-function-creators=1

max_binlog_size=1024M
#binlog_format=mixed
server-id = 1
#binlog-ignore-db=forums_games_la

#innodb_log_file_size = 256M
#innodb_log_buffer_size = 4M
#innodb_flush_method = O_DIRECT
#innodb_flush_log_at_trx_commit = 1

[client]
default-character-set=utf8

[mysqld_safe]
open_files_limit = 8192
log-error=/var/log/mysqld.log
#pid-file=/var/run/mysqld/mysqld.pid

------------------------------------------ 从库 DB02 MY.CNF -----------------------------------------------------------

[mysqld]
datadir=/data/mysql
socket=/data/mysql/mysql.sock
user=mysql

#old_passwords=1

# default
character-set-server=utf8
default-storage-engine=INNODB

skip-name-resolve
skip-slave-start
#slave-skip-errors=all
#slave-skip-errors=1062
#slave-skip-errors=1062 126 144
#slave-skip-errors=126

# buffer cache
max_connections = 10000
key_buffer = 256M
myisam_sort_buffer_size = 64M
join_buffer_size = 8M
read_buffer_size = 4M
sort_buffer_size = 8M
table_cache = 2048
interactive_timeout = 1000
innodb_buffer_pool_size = 8G

# myisam
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 30G
myisam_repair_threads = 1
myisam_recover

tmp_table_size = 256M

# max
max_allowed_packet = 100M
max_connect_errors = 10
max_heap_table_size = 256M

# query
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1

# thread
thread_cache = 24
thread_cache_size = 196
thread_concurrency = 16

back_log = 50
wait_timeout = 600

# log
log_error=/var/log/mysqld.log

slow-query-log=ON
slow-query-log-file=/var/log/slow-queries.log
long_query_time=5
log-slow-admin-statements
log-queries-not-using-indexes


ft_min_word_len = 2

expire_logs_days = 5

log-bin=mysql-bin
log_bin = /data/mysql/mysql-bin.log
log_bin_index = /data/mysql/mysql-bin.log.index
log-bin-trust-function-creators=1
max_binlog_size=1024M
server-id = 3838
relay-log=/data/mysql/replicate
relay-log-index=/data/mysql/replicate.index
read-only=1
#master-host = 10.68.38.42
#master-user = slave
#master-pass = weo2sw82l3dsWSk
#master-port = 3306
#master-connect-retry=60
replicate-ignore-db=mysql
log-slave-updates

[client]
default-character-set=utf8
[mysqld_safe]
open_files_limit = 8192
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid