[mysqld]
datadir=/database/mysql
tmpdir=/dev/shm
max_connections=256
myisam-recover=backup,force
group_concat_max_len=4096
thread_cache_size=128
max_allowed_packet=32M
open_files_limit=10240

### LOGS ###
slow_query_log=1

### INNODB ###
#####################################################
innodb_log_file_size=256M
innodb_buffer_pool_size=1024M
innodb_additional_mem_pool_size=10M
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=2
innodb_io_capacity=500
innodb_read_io_threads=8
innodb_write_io_threads=8
innodb_file_per_table=1
#####################################################

### TIMEOUTS ###
#####################################################
interactive_timeout = 180
connect_timeout = 30
wait_timeout = 180
max_connect_errors=100
#####################################################


### CACHE & BUFFERS ###
#####################################################
tmp_table_size = 512M
max_heap_table_size = 512M
join_buffer_size=4M
read_buffer_size=4M
sort_buffer_size=4M
read_rnd_buffer_size=4M
key_buffer_size=256M
myisam_sort_buffer_size=256M
query_cache_limit=6M
query_cache_size=128M
query_cache_type=1
table_open_cache=1K
table_definition_cache=1K
#####################################################

[mysqldump]
quick
max_allowed_packet=32M

[mysql]
no-auto-rehash

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

[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout