# The following options will be passed to all MySQL clients
[client]
port                = 3306
socket              = /data01/mydata/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
user                = mysql
port                = 3306

basedir             = /opt/mysql/product/5.1.56-gpl-64
datadir             = /data01/mydata/data
pid-file            = /data01/mydata/mysql.pid
socket              = /data01/mydata/mysql.sock
tmpdir              = /log01/mydata/tmp
slave_load_tmpdir   = /log01/mydata/tmp
log-bin             = /log01/mydata/binlogs/-bin
log-bin-index       = /log01/mydata/binlogs/-bin.index
expire_logs_days    = 7
log_slave_updates
relay-log           = /log01/mydata/relaylogs/-relay
relay-log-index     = /log01/mydata/relaylogs/-relay.index
relay-log-info-file = /log01/mydata/relaylogs/-relay.info
master-info-file    = /data01/mydata/master.info
log-error           = /data01/mydata/mysql-error.log
slow_query_log_file = /data01/mydata/mysql-slow.log
slow_query_log          = 0
long_query_time     = 30
log-warnings        = 0
#log-queries-not-using-indexes

key_buffer_size           = 256M
max_allowed_packet        = 512M
table_cache               = 2048
sort_buffer_size          = 256K
read_buffer_size          = 256K
read_rnd_buffer_size      = 8M
myisam_max_sort_file_size = 3072M
myisam_sort_buffer_size   = 256M
max_heap_table_size       = 256M
join_buffer_size          = 16M
tmp_table_size            = 64M
query_cache_type          = 1
query_cache_size          = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency        = 8
thread_cache_size         = 128
# Turn off delayed inserts
max_delayed_threads       = 0
max_connections           = 1000
max_connect_errors        = 999999999
interactive_timeout       = 600
wait_timeout              = 600
back_log                  = 25

skip-external-locking
skip-show-database
skip-name-resolve
#skip-networking

#read-only

server-id            = 1393658717
#skip-slave-start
master-host          = 10.21.9.86
master-user          = repl
master-password      = 0r30C00k135!
master-port          = 3306
master-connect-retry = 30
report-host          = glispa-c.db.prd.drt2.digitalriver.com
slave-skip-errors    = 1146

skip-innodb

[mysqldump]
quick
max_allowed_packet = 512M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
prompt = '\u@\d\> '

[isamchk]
key_buffer       = 256M
sort_buffer_size = 256M
read_buffer      = 2M
write_buffer     = 2M

[myisamchk]
key_buffer       = 1G
sort_buffer_size = 1G
read_buffer      = 4M
write_buffer     = 4M

[mysqlhotcopy]
interactive-timeout