# Managed by chef

[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock


[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0

[mysqld]
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql/data
tmpdir		= /tmp
language	= /usr/share/mysql/english
skip-external-locking
character_set_server=latin1

server-id               = 477

read_only
skip_name_resolve
#skip-slave-start

relay_log=/var/lib/mysql/data/r4-8-a20-relay-bin
relay_log_index=/var/lib/mysql/data/relay-bin.index

#
# * Fine Tuning
#
#Percona's specific
innodb_dict_size_limit=3221225472
#Percona's specific end

key_buffer		= 16M
max_allowed_packet	= 16M
join_buffer_size=2M
key_buffer_size=100M

thread_stack		= 128K
thread_cache_size	= 8

log_error=/var/lib/mysql/error
log_slow_queries=/var/lib/mysql/slow.log
long_query_time = 5
#log-queries-not-using-indexes


set-variable =  long_query_time=5

max_allowed_packet      = 16M
max_connect_errors=1000
max_connections=1000
max_heap_table_size=32M
myisam_sort_buffer_size=64M

query_cache_type=0
query_cache_size=0

sort_buffer_size=2M
table_cache=20000
thread_cache_size=90
tmp_table_size=192M


# *InnoDB settings*
innodb_additional_mem_pool_size=512M
innodb_buffer_pool_size=3000M
innodb_flush_log_at_trx_commit=0
innodb_flush_method=O_DIRECT
innodb_lock_wait_timeout=240
innodb_log_buffer_size=16M
innodb_open_files = 5000
default-storage-engine = InnoDB


#myisam-recover		= BACKUP
#thread_concurrency     = 10


# 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 :)
#

#log_slave_updates
#log_bin			= /var/lib/mysql/binlog/r8-4-12_bin
expire_logs_days	= 10
#max_binlog_size         = 500M

#binlog_do_db		= include_database_name
#binlog_ignore_db	= include_database_name
#

skip-bdb

[mysqldump]
quick
quote-names
max_allowed_packet	= 16M

[mysql]

[isamchk]
key_buffer		= 16M

!includedir /etc/mysql/conf.d/