[mysqld]
#innodb_force_recovery=4
default-character-set = gbk
character-set-server = gbk
replicate-ignore-db = mysql
replicate-ignore-db = test
replicate-ignore-db = information_schema
user = mysql
port = 3306
socket = /tmp/mysql.sock
basedir = /usr/local/webserver/mysql
datadir = /data0/mysql/3306/data
log-error = /data0/mysql/3306/mysql_error.log
pid-file = /data0/mysql/3306/mysql.pid
open_files_limit = 10240
back_log = 600
max_connections = 50
max_connect_errors = 600
table_cache = 614
external-locking = FALSE
max_allowed_packet = 32M
sort_buffer_size = 1M
join_buffer_size = 1M
thread_cache_size = 300
thread_concurrency = 8
query_cache_size = 512M
query_cache_limit = 2M
query_cache_min_res_unit = 2k
default-storage-engine = MyISAM
thread_stack = 192K
transaction_isolation = READ-COMMITTED
tmp_table_size = 246M
max_heap_table_size = 246M
long_query_time = 3
log-slave-updates
log-bin = /data0/mysql/3306/binlog/binlog
binlog_cache_size = 128M
binlog-do-db = discuz
binlog-ignore-db=test
binlog-ignore-db=mysql
binlog-ignore-db=information_schema
binlog_format = MIXED
max_binlog_cache_size = 256M
max_binlog_size = 6M
relay-log-index = /data0/mysql/3306/relaylog/relaylog
relay-log-info-file = /data0/mysql/3306/relaylog/relaylog
relay-log-info-file = /data0/mysql/3306/relaylog/relaylog
53 relay-log = /data0/mysql/3306/relaylog/relaylog
54 expire_logs_days = 30
55 key_buffer_size = 8M
56 read_buffer_size = 6M
57 read_rnd_buffer_size = 16M
58 bulk_insert_buffer_size = 64M
59 myisam_sort_buffer_size = 128M
60 myisam_max_sort_file_size = 1G
61 myisam_repair_threads = 1
62 myisam_recover
63
64 interactive_timeout = 120
65 wait_timeout = 120
66
67 skip-name-resolve
68 master-connect-retry = 10
69 slave-skip-errors = 1032,1062,126,1114,1146,1048,1396
70
71 #master-host = 192.168.1.2
72 #master-user = username
73 #master-password = password
74 #master-port = 3306
75
76 server-id = 1
77
78 innodb_additional_mem_pool_size = 16M
79 innodb_buffer_pool_size =512M
80 innodb_data_file_path = ibdata1:256M:autoextend
81 innodb_file_io_threads = 4
82 innodb_thread_concurrency = 8
83 innodb_flush_log_at_trx_commit = 2
84 innodb_log_buffer_size = 16M
85 innodb_log_file_size = 128M
86 innodb_log_files_in_group = 3
87 innodb_max_dirty_pages_pct = 90
88 innodb_lock_wait_timeout = 120
89 innodb_file_per_table = 0
90
91 #log-slow-queries = /data0/mysql/3306/slow.log
92 #long_query_time = 10
93
94 [mysqldump]
95 quick
96 max_allowed_packet = 32M
