[client]
#password        = [your_password]
port             = 3306
socket           = /opt/mysql/tmp/mysql.sock
# *** Application-specific options follow here ***
 
#
# The MySQL server
#
[mysqld]
# *** generic configuration options ***
port             = 3306
socket           = /opt/mysql/tmp/mysql.sock
pid-file         = /opt/mysql/var/mysqld.pid
user             = mysql
 
basedir          = /opt/mysql
datadir          = /opt/mysql/var
 
wait_timeout     = 10
skip-name-resolve
 
back_log = 512
#skip-networking
max_connections = 2000
max_connect_errors = 20
table_open_cache = 2048
#external-locking
max_allowed_packet = 16M
binlog_cache_size = 1M
max_heap_table_size = 256M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
sort_buffer_size = 16M
join_buffer_size = 8M
thread_cache_size = 64
thread_concurrency = 8
query_cache_size = 128M
query_cache_limit = 2M
ft_min_word_len  = 4
#memlock
default-storage-engine = InnoDB
thread_stack     = 192K
transaction_isolation = REPEATABLE-READ
tmp_table_size   = 128M
#event_scheduler = ON
 
 
# ***  Replication related settings ***
 
# master-host
server-id        = 1
log-bin          = mysql-bin
#binlog-do-db     = 107db_zhs
binlog-ignore-db = mysql,information_schema
expire_logs_days = 9
binlog_format    = mixed
sync_binlog      = 0
log_bin_trust_function_creators = 1
 
 
 
# method two
#server-id       = 2
# (Not recommended to enable the following parameters)
#master-host     = 192.168.100.10
#master-user     = repl
#master-password = passwd
#master-port     = 3306
# (The following parameters can be enabled)
#master-connect-retry = 60
#replicate-do-db = 107db_zhs
#replicate-ignore-db = mysql,information_schema
#replicate-wild-ignore-table = dbname.%
#relay-log       = relay-bin
 
#read-only
#skip-slave-start
#log-slave-updates
 
 
# *** log ***
general_log      = OFF
general_log_file = /opt/mysql/var/mysql.log
#log_warnings
log-error        = /opt/mysql/var/mysql.err
 
slow_query_log
slow_query_log_file = /opt/mysql/var/mysql-slow.log
long_query_time  = 3
 
 
# *** MyISAM Specific options ***
key_buffer_size  =   32M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
myisam_recover
innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 4G
innodb_read_io_threads = 4
innodb_write_io_threads = 4
#innodb_force_recovery = 1
innodb_thread_concurrency = 8
innodb_flush_log_at_trx_commit = 1
#innodb_fast_shutdown
innodb_log_buffer_size = 48M
innodb_log_file_size = 256M
innodb_log_files_in_group = 3
#innodb_log_group_home_dir
innodb_max_dirty_pages_pct = 90
innodb_flush_method=O_DIRECT
innodb_lock_wait_timeout = 120
innodb-file-per-table = 1 
 
 
 
[mysqldump]
quick
max_allowed_packet  = 16M
 
 
[mysql]
prompt = "\\u@\\h: \\d \\R:\\m:\\s>"
no-auto-rehash
#safe-updates
 
 
[myisamchk]
key_buffer_size  = 512M
sort_buffer_size = 512M
read_buffer      = 8M
write_buffer     = 8M
 
 
[mysqlhotcopy]
interactive-timeout
 
 
[mysqld_safe]
open-files-limit = 8192