# 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

[safe_mysqld]
err-log = /var/log/mysql.err
open-files=8192

# 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]
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]
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
log-err		= /var/log/mysql.err
log-slow-queries= /var/log/mysql.slowlog
log-warnings
datadir		= /db/mysql
tmpdir		= /var/tmp
language	= english
myisam-recover	= BACKUP,FORCE
skip-locking
skip-bdb
safe-user-create
safe-show-database
key_buffer=64M
max_allowed_packet=10M
table_cache=64
sort_buffer=512K
myisam_sort_buffer_size=8M
max_connections=240
max_connect_errors=1000
wait_timeout=60
interactive_timeout=3600
flush_time=300
long_query_time=3
open_files_limit=768
default_week_format=3
query_cache_type = 1
query_cache_size = 32M
innodb_data_home_dir =
innodb_data_file_path = /db/mysql/ibdata1:10M:autoextend
innodb_additional_mem_pool_size=20M
innodb_buffer_pool_size=128M
innodb_lock_wait_timeout=60
thread_cache_size=20
log-warnings
skip-name-resolve
log = /var/log/mysql.log
max_user_connections=18


[mysqld-4.0]
default-character-set=german1
basedir		= /usr/

[mysqld-4.1]
collation-server=latin1_german2_ci
old-passwords
basedir		= /usr/local/mysql

[mysqld-5.0]
collation-server=latin1_german2_ci
old-passwords
basedir		= /usr/local/mysql5

[mysqldump]
quick
set-variable	= max_allowed_packet=10M
set-variable	= net_buffer_length=512K
quote-names

[mysql]
no-auto-rehash

[isamchk]
set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[myisamchk]
set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M
force
tmpdir=/db/check

[mysqlcheck]
force
auto-repair

[mysqladmin]
connect_timeout=20
shutdown_timeout=180