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

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
skip-name-resolve

datadir         = /var/lib/mysql
port		= 3306
socket		= /tmp/mysql.sock
#skip-locking
key_buffer = 2G
max_allowed_packet = 16M
table_cache = 8192
sort_buffer_size = 16M
read_buffer_size = 4M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 128M
thread_cache_size = 16
query_cache_size = 1G
## Try number of CPU's*2 for thread_concurrency
#thread_concurrency = 32
max_connections = 2048

#Logging
#log_slow_queries=/var/lib/mysql/slow-queries.log
slow_query_log=1
slow_query_log_file=/var/lib/mysql/slow-queries.log
long_query_time=5

# Replication Master Server (default)
# binary logging is required for replication

log-bin=thalesmaster-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id	= 2

skip-slave-start

log-warnings

max-binlog-size=1G
max-relay-log-size=1G

# Uncomment the following if you are using InnoDB tables
innodb_file_per_table

innodb_data_home_dir = /var/lib/mysql
innodb_data_file_path = ibdata1:100000M;ibdata2:100M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
# innodb_buffer_pool_size = 16384M
innodb_buffer_pool_size = 72G
innodb_additional_mem_pool_size = 16M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 1G
innodb_log_buffer_size = 14M
innodb_flush_log_at_trx_commit = 0
innodb_lock_wait_timeout = 300
innodb_open_files = 2000
innodb_max_dirty_pages_pct = 75
#innodb_extra_dirty_writes = 1
innodb_support_xa = 0
innodb_read_io_threads = 12
innodb_write_io_threads = 12

# 5.4 configuration
innodb_io_capacity = 4000

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]

[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
#key_buffer = 4G
#sort_buffer_size = 16G
#read_buffer = 1G
#write_buffer = 1G
key_buffer = 512MB
sort_buffer_size = 512MB
read_buffer = 256MB
write_buffer = 256MB

[mysqlhotcopy]
interactive-timeout