[client]
port		= 3306
socket		= /tmp/mysql.sock

[mysqld_safe]
socket		= /tmp/mysql.sock
nice		= 0

[mysqld]
user		= mysql
pid-file	= /var/run/mysql/mysqld.pid
socket		= /tmp/mysql.sock
port		= 3306
basedir		= /usr/local/mysql/5.0.45
datadir		= /var/lib/mysql
tmpdir		= /tmp
language	= /usr/local/mysql/5.0.45/share/mysql/english
skip-external-locking
thread_concurrency = 8
bind-address		= 127.0.0.1
key_buffer		= 32M
max_allowed_packet	= 16M
thread_stack		= 256K
thread_cache_size	= 16
query_cache_limit	= 4M
query_cache_size        = 32M
query_cache_type        = 1
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log		= /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
log_slow_queries	= /var/log/mysql/mysql-slow.log
#
# The following can be used as easy to replay backup logs or for replication.
#server-id		= 1
# log_bin			= /var/log/mysql/mysql-bin.log
# WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!
expire_logs_days	= 10
max_binlog_size         = 100M
#binlog_do_db		= include_database_name
#binlog_ignore_db	= include_database_name
#
# * BerkeleyDB
#
# Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
#skip-innodb
innodb_buffer_pool_size = 2G
innodb_additional_mem_pool_size = 128M
innodb_data_file_path = ibdata1:10M:autoextend
innodb_file_io_threads = 4
innodb_log_buffer_size = 8M
innodb_max_dirty_pages_pct = 90


[mysqldump]
quick
quote-names
max_allowed_packet	= 16M

[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition

[isamchk]
key_buffer		= 16M