my.cnf(2)

syxian

[root@vas11 ~]# 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=4011
master_host=10.10.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_%

default-character-set=gbk     

#for bestv mysql optimization
tmp_table_size=16777216
query_cache_size=33554432
join_buffer_size=531072
thread_cache_size=30
log-slow-queries=slow-query.log
long-query-time=1
max_connections=700

skip-slave-start

key_buffer_size = 256M


##innodb##
innodb_buffer_pool_size= 1500M
innodb_log_file_size = 256M
innodb_log_buffer_size = 32M
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=2
innodb-file-per-table
innodb_support_xa = 0
#########

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

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