###
#
# DO NOT MAKE CHANGES TO THIS FILE, use /etc/my-server.cnf to
# overwrite or add any other settings.
#
###
[client]
port=3306
socket=/var/lib/mysql/mysql.sock

[mysqld]
# Connection information
socket=/var/lib/mysql/mysql.sock
port=3306

# Logs
log-error=/var/lib/mysql/log/error.log
log_warnings
slow_query_log=1
slow_query_log_file=/var/lib/mysql/log/slow_queries.log

long_query_time=2

log-bin=mysql-bin
expire_logs_days=2

default-storage-engine=InnoDB
binlog_cache_size=1M
max_allowed_packet=16M
max_connect_errors=10
max_connections=500
max_heap_table_size=64M
tmp_table_size=64M
pid-file=mysqld.pid
query_cache_limit=0
query_cache_size=0
query_cache_type=0
skip-name-resolve
table_cache=2048
thread_cache_size=8
thread_concurrency=8
thread_stack=256K
tmpdir=/var/lib/mysql/tmp
bulk_insert_buffer_size=8M

#per thread
join_buffer_size=256k
read_buffer_size=131072
read_rnd_buffer_size=262144
sort_buffer_size=1048576

#*** MyISAM Specific options
key_buffer_size=8M
myisam_sort_buffer_size=8M
myisam_repair_threads=1
myisam_recover

#*** INNODB Specific options ***
innodb_additional_mem_pool_size=16M
innodb_data_file_path=ibdata1:10M:autoextend
innodb_flush_method=O_DIRECT
innodb_thread_concurrency=16
innodb_log_buffer_size=8M
innodb_log_file_size=256M
innodb_log_files_in_group=2
innodb_lock_wait_timeout=120


[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=512M
sort_buffer_size=512M
read_buffer=8M
write_buffer=8M

[myisamchk]
key_buffer=512M
sort_buffer_size=512M
read_buffer=8M
write_buffer=8M

[mysqlhotcopy]
interactive-timeout

[mysqld_safe]
open-files-limit=8192

# Server specific information.
!include /etc/my-server.cnf

# Used when multiple configuration files makes sense.
!includedir /etc/mysql