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

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

[mysqld]
port		= 3306
socket		= /tmp/mysql.sock
datadir		= /var/lib/mysql/data
log-error	= /var/lib/mysql/error.log
pid-file	= /var/lib/mysql/mysql.pid
user		= mysql

# Logging
log-error
log


# Automatic Table Repair
myisam_recover = BACKUP
myisam_repair_threads = 4

# Locking
skip-locking
skip-external-locking

# Tunings
thread_concurrency = 4
thread_cache_size = 4
max_allowed_packet = 10M
net_buffer_length = 4K
thread_stack = 64K
table_cache = 40
max_connections = 30

# Memory Tuning
query_cache_size = 64M
key_buffer = 8M
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 8M

# Index Tuning
ft_min_word_len = 2
ft_max_word_len = 80
group_concat_max_len = 2048

# Table Sizes
max_heap_table_size = 16M
tmp_table_size = 16M

# Skipping Databases
#skip-innodb

# Replication Master Server (default)
# binary logging is required for replication
relay-log=/var/lib/mysql/relay-log

# 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	= 700

# INNODB
innodb_data_home_dir = /var/lib/mysql/innodb
innodb_log_group_home_dir = /var/lib/mysql/innodb

innodb_buffer_pool_size=1G
innodb_additional_mem_pool_size=20M

innodb_log_file_size=250M
innodb_log_buffer_size=8M
innodb_log_files_in_group = 2

innodb_flush_log_at_trx_commit=1

innodb_lock_wait_timeout=50
innodb_thread_concurrency=4

innodb_data_file_path=datafile.001:1024M;datafile.002:1024M;datafile.003:1024M;datafile.004:1024M;datafile.005:1024M;datafile.006:1024M;datafile.007:1024M;datafile.008:1024M;datafile.009:1024M;datafile.010:1024M;datafile.011:1024M;datafile.012:1024M;datafile.013:1024M;datafile.014:1024M;datafile.015:1024M;datafile.016:1024M;datafile.017:1024M;datafile.018:1024M;datafile.019:1024M;datafile.020:1024M

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

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

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout