###
####    This file managed by puppet.
###

#
# * IMPORTANT
#   If you make changes to these settings and your system uses apparmor, you may
#   also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#


[mysqld]
basedir                        = /usr
datadir                        = /mnt
tmpdir                         = /tmp
socket                         = /var/run/mysqld/mysqld.sock
pid-file                       = /var/run/mysqld/mysqld.pid
user                           = mysql


##############
# Networking #
##############

bind_address                   = 127.0.0.1
port                           = 3306
skip_name_resolve
max_allowed_packet             = 16M
max_connections                = 151
wait_timeout                   = 28800
connect_timeout                = 10


###########
# Logging #
###########
log_error                      = /var/log/mysql/mysql.err


# Character Set
character_set_server           = utf8
collation_server               = utf8_general_ci

# Allow fulltext searches to find words smaller than 4 characters
ft_min_word_len                = 3


####################################
# Buffers, Threads, Caches, Limits #
####################################
tmp_table_size                 = 16M
max_heap_table_size            = 16M
max_tmp_tables                 = 32

join_buffer_size               = 3M
read_buffer_size               = 4M
sort_buffer_size               = 4M

table_cache                    = 64
table_definition_cache         = 256
open_files_limit               = 1024

thread_stack                   = 192K
thread_cache_size              = 8
thread_concurrency             = 10

query_cache_size               = 16M
query_cache_limit              = 1M
tmp_table_size                 = 16M
read_rnd_buffer_size           = 256K

###################
# MyISAM Settings #
###################
key_buffer_size                = 16M
myisam_sort_buffer_size        = 8M
myisam_max_sort_file_size      = 512M


###################
# InnoDB Settings #
###################
innodb_file_per_table          = 1
innodb_status_file             = 0
innodb_support_xa              = 0
innodb_flush_log_at_trx_commit = 0
innodb_buffer_pool_size        = 8M
innodb_log_file_size           = 5M
innodb_log_group_home_dir      = /mnt
innodb_flush_method            = O_DIRECT
innodb_thread_concurrency      = 8
innodb_concurrency_tickets     = 500
innodb_doublewrite             = 1

# always enable federated storage engine
federated                      = 1


read_only                      = 0


# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port                           = 3306
socket                         = /var/run/mysqld/mysqld.sock

[mysqldump]
quick
quote-names
max_allowed_packet             = 16M

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

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/