# Example mysql config file for large systems.
#
# This is for large system with memory = 512M where the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/mf.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# One can in this file use all long options that the program supports.
# If you want to know which options a program support, run the program
# with --help option.

# The following options will be passed to all MySQL clients
[client]
#password	= your_password
port		= 3306
socket		= /var/run/mysqld/mysqld.sock

# Here follows entries for some specific programs
[manager]
run-as-service
monitoring-interval     = 4
password-file           = /etc/mysql/mysqlmanager.passwd
log                     = /var/log/mysql/mysqlmanager.log
pid-file                = /var/run/mysqld/mysqlmanager.pid
socket                  = /var/run/mysqld/mysqlmanager.sock
angel-pid-file          = /var/run/mysqld/mysqlmanager.angel.pid
bind-address            = 127.0.0.1
wait-timeout            = 120

# The MySQL server
[mysqld]
port		= 3306
user		= mysql
socket		= /var/run/mysqld/mysqld.sock
pid-file	= /var/run/mysqld/mysqld.pid
log-error	= /var/log/mysql/mysql.err
datadir		= /var/lib/mysql
set-variable	= key_buffer=256M
set-variable	= max_allowed_packet=16M
set-variable	= table_cache=512
set-variable	= sort_buffer=16M
set-variable	= record_buffer=2M
set-variable	= myisam_sort_buffer_size=64M
set-variable	= thread_cache=8
set-variable    = tmp_table_size=128M

max_heap_table_size = 512M

large-pages
skip-name-resolve
skip-external-locking

# Try number of CPU's*2 for thread_concurrency
set-variable	= thread_concurrency=8
# REPLICATION parameters:
log-bin=/var/log/mysql/binlog
expire_logs_days=2
log-slave-updates

server-id=31

relay-log			= /var/log/mysql/nuclear-relay-bin
relay-log-index			= /var/log/mysql/nuclear-relay-bin.index
relay-log-info-file		= /var/log/mysql/nuclear-relay-bin.info

#report-host                     = bodb.srv.ehouse.ru
#master-host                     = mbdb.srv.ehouse.ru
#master-port                     = 3306
#master-user                     = user
#master-password                 = password

replicate-do-db                 = mb
replicate-do-db                 = marex_bo

default-character-set=cp1251
# END OF REPLICATION parameters

query_cache_size = 256M
query_cache_type = 1

max_connections=210
# Slow queries hunt
log-slow-queries=/var/log/mysql/nuclear-slow.log
long_query_time=2

# FULLTEXT INDEXES
ft_min_word_len=2

## misc
# Workaround against massive long select locks
# In case when all select's are locked due to
# insert followed by huge select
# May lead to DML queries starvation.
low_priority_updates	= 1

# Uncomment the following if you are using BDB tables
#set-variable	= bdb_cache_size=64M
#set-variable	= bdb_max_lock=100000

# Uncomment the following if you are using Innobase tables
innodb_data_home_dir = /var/lib/mysql-innodb/
innodb_log_group_home_dir = /var/log/innodb/
innodb_log_arch_dir = /var/log/innodb/
innodb_data_file_path = 1/ibdata1:43100M;2/ibdata2:100M:autoextend:max:45000M
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=128M
set-variable = innodb_log_buffer_size=128M
innodb_flush_log_at_trx_commit=1
innodb_flush_method=O_DIRECT
set-variable = innodb_buffer_pool_size=4608M
set-variable = innodb_additional_mem_pool_size=24M
set-variable = innodb_file_io_threads=8
set-variable = innodb_thread_concurrency=12
set-variable = innodb_lock_wait_timeout=320

# Point the following paths to different dedicated disks
tmpdir		= /tmp/		
#log-update 	= /path-to-dedicated-directory/hostname
#!!!!!!!!!!!!!!! LOG !!!!!!!!
#log

[mysqldump]
quick
set-variable	= max_allowed_packet=16M

[mysql]
skip-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable	= key_buffer=128M
set-variable	= sort_buffer=128M
set-variable	= read_buffer=2M
set-variable	= write_buffer=2M

[myisamchk]
set-variable	= key_buffer=128M
set-variable	= sort_buffer=128M
set-variable	= read_buffer=2M
set-variable	= write_buffer=2M

[mysqlhotcopy]
interactive-timeout