BiTel

[client]
character-sets-dir = cp1251
port      = 3306
socket      = /var/run/mysqld/mysqld.sock

[mysqld]
port      = 3306
socket      = /var/run/mysqld/mysqld.sock
skip-name-resolve
default-storage-engine = innodb
character-set-server = cp1251
collation-server = cp1251_general_ci
sql-mode=
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 50M # 1M
max_connections = 1000
memlock
table_cache = 4096
thread_cache_size = 300
thread_concurrency = 2
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

tmpdir = /tmp

log-bin=mysql-bin
expire_logs_days=7
binlog_format=mixed

server-id   = 1

innodb_file_per_table
innodb_data_home_dir = /var/lib/mysql
innodb_log_group_home_dir = /var/lib/mysql
innodb_buffer_pool_size = 4G # 16M
innodb_additional_mem_pool_size = 16M # 2M
innodb_log_files_in_group = 2
innodb_log_file_size = 1G # 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 120

innodb_thread_concurrency = 2
innodb_flush_method = O_DIRECT

[mysqld_safe]
open-files-limit=32000

[mysqldump]
quick
character-set-server = cp1251
max_allowed_packet = 50M # 16M

[mysql]
no-auto-rehash

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

[mysqlhotcopy]
interactive-timeout