# Maintained through Puppet

[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
syslog

[mysql]

# CLIENT #
port                           = 3306
socket		= /var/run/mysqld/mysqld.sock

[mysqld]
server-id = 100000123
skip-name-resolve
binlog_format = MIXED


innodb_buffer_pool_load_at_startup = ON
innodb_buffer_pool_dump_at_shutdown = ON

# GENERAL #
user                           = mysql

# TokuDB #
tokudb_row_format = tokudb_lzma
plugin-load-add=ha_tokudb.so
tokudb_cache_size =141G

default_storage_engine         = InnoDB

socket		= /var/run/mysqld/mysqld.sock
pid-file	= /tmp/mysql.pid

# MyISAM #
key_buffer_size                = 80M
myisam_recover_options         = BACKUP,FORCE
myisam_sort_buffer_size = 64M

# SAFETY #
max_allowed_packet             = 32M
max_connect_errors             = 500
sysdate_is_now                 = 1
innodb                         = FORCE

# DATA STORAGE #
datadir                        = /data/mysql/data
tmpdir                         = /data/mysql/tmp

# BINARY LOGGING #
log-bin = /data/mysql/binlogs/node438-bin
log-bin-index = /data/mysql/binlogs/node438-bin.index
expire_logs_days               = 3
sync_binlog                    = 1

# REPLICATION #
read_only                      = 1
skip_slave_start               = 1
log_slave_updates              = 1
relay-log = /data/mysql/binlogs/node438-relay-bin
relay-log-index = /data/mysql/binlogs/node438-relay-bin.index

# CACHES AND LIMITS #
tmp_table_size                 = 32M
max_heap_table_size            = 32M
query_cache_type               = 0
query_cache_size               = 0
max_connections                = 2000
query_cache_min_res_unit = 2K
connect_timeout		= 10
thread_cache_size              = 100
open_files_limit               = 65535
table_definition_cache         = 4096
table_open_cache               = 3072
sort_buffer_size	= 2M
read_buffer_size	= 1M
max_allowed_packet	= 32M
thread_stack		= 256K



# INNODB #
innodb_data_home_dir		= /data/mysql/data
innodb_data_file_path		= ibdata1:10M:autoextend
innodb_flush_method            = O_DIRECT
innodb_log_files_in_group      = 2
innodb_log_file_size           = 512M
innodb_log_group_home_dir 	= /data/mysql/data
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table          = 1
innodb_buffer_pool_size        = 141G
innodb_log_buffer_size		= 25M
innodb_read_io_threads = 8
innodb_write_io_threads = 8


innodb_file_format = Barracuda

innodb_stats_on_metadata = 0

# LOGGING #
log_queries_not_using_indexes  = 1
slow_query_log                 = 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
long_query_time = 1


[mysqldump]
quick
quote-names
max_allowed_packet	= 32M

[isamchk]
key_buffer_size		= 16M