# /etc/mysql/my.cnf: The global mysql configuration file.
[client]
port						= 3306
socket						= /tmp/mysql5.sock

[mysql]
character-sets-dir				= /usr/share/mysql/charsets
default-character-set				= utf8

[mysqladmin]
character-sets-dir				= /usr/share/mysql/charsets
default-character-set				= utf8

[mysqlcheck]
character-sets-dir				= /usr/share/mysql/charsets
default-character-set				= utf8

[mysqldump]
quick
max_allowed_packet				= 64M
character-sets-dir				= /usr/share/mysql/charsets
default-character-set				= utf8

[myisamchk]
character-sets-dir				= /usr/share/mysql/charsets
key_buffer					= 256M
sort_buffer_size				= 32M
read_buffer					= 32M
write_buffer					= 32M

[mysqld]
large_pages
skip-external-locking
skip-name-resolve
skip-innodb
skip-slave-start

back_log					= 256
max_connections					= 512
port						= 3306
net_buffer_length				= 16K

server-id					= 2
slave-skip-errors				= 1062,1050,1051,1053,1146,1007
#slave_net_timeout				= 5
master-retry-count				= 1
relay-log					= mysqld-relay-bin
#relay-log					= /data/mysql_db/logs/web1-relaylog
#replicate-wild-do-table				= BankService.%
#replicate-wild-do-table				= _ss%.%
#replicate-wild-do-table				= ss%.%
#replicate-wild-do-table				= doska%.%

#query_cache_size				= 700M
#query_cache_min_res_unit			= 1K
#query_cache_limit				= 4M
table_cache					= 2048

character-set-server				= utf8
#language					= /usr/share/mysql/english
user 						= mysql
socket 						= /tmp/mysql5.sock
log_warnings					= 2
pid-file 					= /data/mysql_db/logs/mysqld.pid
log-error 					= /data/mysql_db/logs/mysqld.err
basedir 					= /usr
datadir 					= /data/mysql_db/data/
tmpdir						= /data/tmp/mysql/
default-storage-engine				= myisam
slow-query-log-file				= /data/mysql_db/logs/slow_queries.log
long-query-time					= 2

max_binlog_size					= 1m
log-bin						= /data/mysql_db/logs/dba-logbin
binlog-ignore-db				= mysql
sync_binlog					= 0
log-slave-updates				= 1

key_buffer 					= 2G
max_allowed_packet 				= 128M
sort_buffer_size 				= 64M
read_buffer_size 				= 32M
read_rnd_buffer_size 				= 32M
myisam_sort_buffer_size	 			= 32M
join_buffer_size				= 64M
max_sort_length					= 32
myisam_recover					= BACKUP,FORCE
sync_frm					= 0