#
# The MySQL database server configuration file.
#

[client]
port				= 3306
socket				= /var/lib/mysql/mysql.sock
default-character-set=utf8

[mysqld_safe]
socket				= /var/lib/mysql/mysql.sock
nice				= 0

[mysqld]
user				= mysql
pid-file			= /var/run/mysqld/mysqld.pid
socket				= /var/lib/mysql/mysql.sock
port				= 3306
basedir				= /usr
datadir				= /var/lib/mysql
tmpdir				= /tmp
skip-external-locking
query_cache_size		= 256M
query_cache_limit		= 2M
table_cache			= 6000
thread_cache_size		= 32
max_heap_table_size		= 3072M
tmp_table_size			= 3072M
innodb_buffer_pool_size		= 512M
innodb_log_file_size		= 512M
innodb_flush_log_at_trx_commit	= 2
innodb_flush_method		= O_DIRECT
transaction-isolation		= READ-COMMITTED
default-storage-engine		= innodb
bind-address			= 127.0.0.1
max_allowed_packet		= 32M
thread_stack			= 128K
myisam-recover			= BACKUP
expire_logs_days		= 5
max_binlog_size         	= 100M
default-character-set		= cp1251
character-set-server		= cp1251
collation-server		= cp1251_general_ci
init-connect			= "SET NAMES cp1251"
skip-character-set-client-handshake

key_buffer			= 32M
join_buffer_size		= 16M
sort_buffer_size		= 16M
read_rnd_buffer_size		= 1M

[mysqldump]
quick
quote-names
max_allowed_packet		= 16M
default-character-set		= cp1251

[mysql]

[isamchk]
key_buffer			= 32M

# !includedir /etc/mysql/conf.d/