# Example mysql config file.

#
# I hope the following parameters will once get into the upstream
# version... <ch@debian.org> 
#
# debian_error_log	This logfile contains the start and stop time of the
#			daemon and the reason that prevents its startup.
# 
[debian]
debian_error_log	= /var/log/mysql.err

# You can copy this to one of:
# /etc/mysql/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
# 
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options

# This will be passed to all mysql clients
[client]
#password	= 
port		= 3306
socket		= /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# The MySQL server
#
[mysqld]
#Path to InnoDB data:
#innodb_data_home_dir=/var/lib/mysql/innodb 

#InnoDB filename and size
#innodb_data_file_path=ibdata:50M;ibdata2:50M

#InnoDB lock wait timeout
#set-variable = innodb_lock_wait_timeout=30

#Additional memory pool size - if logs indicate to increase this, do so, but to what?
#set-variable = innodb_additional_mem_pool_size=20M

#skip-networking
skip-innodb
skip-bdb
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
#log		= /var/log/mysql/mysql.log
log-bin		= /var/log/mysql/mysql-bin
server-id	= 4
skip-slave-start
# Required to cascade replication from slave to slave
# (used in transfer of master from db-1 to craven)
log-slave-updates
#Comment in the following 4 lines if enabling this machine as a slave
#master-host	= db-1
#master-user	= repl
#master-password	= anThr4x
#master-port	= 3306
basedir		= /usr/local/mysql
datadir		= /var/lib/mysql
tmpdir		= /tmp
language	= /usr/share/mysql/english
skip-locking

set-variable = delayed_insert_limit=1000
set-variable = delayed_queue_size=10000

#set-variable    = key_buffer=384M
#set-variable    = key_buffer=640M
set-variable    = key_buffer=512M

set-variable    = table_cache=4000
set-variable    = tmp_table_size=4194304
set-variable    = record_buffer=1M
set-variable    = sort_buffer=1M
set-variable    = max_binlog_size=104857600
set-variable    = myisam_sort_buffer_size=128M
set-variable    = query_buffer_size=1M
set-variable    = max_allowed_packet=16M
set-variable    = thread_cache_size=200
set-variable    = thread_stack=128K
set-variable    = back_log=300
set-variable    = connect_timeout=10
set-variable    = max_connections=600
set-variable    = max_connect_errors=10000
set-variable	= max_write_lock_count=100
set-variable	= long_query_time=8
set-variable	= wait_timeout=3600

[mysqldump]
quick
set-variable	= max_allowed_packet=1M

[mysql]
no-auto-rehash

[isamchk]
set-variable	= key_buffer=16M