my.cnf(1)

syxian

[root@vas3 ~]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
server-id=9002
master_host=10.29.131.250
master_user=slave
master_password=password
master_port=3306
master_connect-retry=10
replicate_do-db=vas
replicate_do-db=vis_home
replicate_wild_ignore_table=vas.vas_res_%

replicate_do_db=vis3news

default-character-set=gbk
tmpdir=/tmp/mysql
#skip-slave-start
#slave-skip-errors = 1062
#tmp_table_size=10777216
#query_cache_size=10554432
#join_buffer_size=531072
#thread_cache_size=30
log-slow-queries=slow-query.log
long-query-time=1
max_connections=400

#relay-log=mysqld-relay-bin

##innodb##
#innodb_buffer_pool_size= 500M
innodb_log_file_size = 256M
innodb_log_buffer_size = 32M
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=2
#########

##CNC###
thread_cache_size = 256
table_cache = 1024
log-error = error.log
max-heap-table-size = 256M
key_buffer_size = 512M
sort-buffer-size = 32M
join-buffer-size = 8M
read_buffer_size = 2M
read_rnd_buffer_size = 2M
query-cache-size = 256M
query-cache-limit = 2M
tmp-table-size = 256M

innodb-buffer-pool-size = 4G
innodb-additional-mem-pool-size = 128M
innodb-support-xa = 0

expire_logs_days = 3
relay-log = mysqld-relay-bin
relay-log-index = mysqld-relay-bin.index
relay-log-info-file = relay-log.info

########

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
You have new mail in /var/spool/mail/root
[root@vas3 ~]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
server-id=9002
master_host=10.29.131.250
master_user=slave
master_password=password
master_port=3306
master_connect-retry=10
replicate_do-db=vas
replicate_do-db=vis_home
replicate_wild_ignore_table=vas.vas_res_%

replicate_do_db=vis3news

default-character-set=gbk
tmpdir=/tmp/mysql
#skip-slave-start
#slave-skip-errors = 1062
#tmp_table_size=10777216
#query_cache_size=10554432
#join_buffer_size=531072
#thread_cache_size=30
log-slow-queries=slow-query.log
long-query-time=1
max_connections=400

#relay-log=mysqld-relay-bin

##innodb##
#innodb_buffer_pool_size= 500M
innodb_log_file_size = 256M
innodb_log_buffer_size = 32M
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=2
#########

##CNC###
thread_cache_size = 256
table_cache = 1024
log-error = error.log
max-heap-table-size = 256M
key_buffer_size = 512M
sort-buffer-size = 32M
join-buffer-size = 8M
read_buffer_size = 2M
read_rnd_buffer_size = 2M
query-cache-size = 256M
query-cache-limit = 2M
tmp-table-size = 256M

innodb-buffer-pool-size = 4G
innodb-additional-mem-pool-size = 128M
innodb-support-xa = 0

expire_logs_days = 3
relay-log = mysqld-relay-bin
relay-log-index = mysqld-relay-bin.index
relay-log-info-file = relay-log.info

########

[mysql.server]
user=mysql
basedir=/var/lib

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