mysql主从配置 my.cnf 文件_mysql主从配置文件-my.cnf 及错误排除

1、主库大概配置如下：

[client]

port            = 3306

socket          = /tmp/mysql.sock

[mysqld]

port            = 3306

socket          = /tmp/mysql.sock

log-error = /var/log/mysql_error.log

skip-locking

key_buffer = 256M

max_allowed_packet = 32M

table_cache = 512

sort_buffer_size = 6M

thread_stack = 256K

net_buffer_length = 8K

read_buffer_size = 4M

join_buffer_size = 8M

tmp_table_size = 256M

max_connections = 1000

wait_timeout = 10

query_cache_size = 256M

query_cache_type = 1

thread_cache_size = 64

log_slow_queries

log-queries-not-using-indexes

log_long_format

long_query_time = 2

read_rnd_buffer_size = 16M

myisam_sort_buffe