Skip to content

[MySQL] Текущая конфигурация my.cnf

rsajob edited this page Nov 22, 2012 · 3 revisions
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# My
key_buffer_size         = 64M

innodb_buffer_pool_size = 1G
innodb_additional_mem_pool_size = 40M

innodb_log_file_size = 128M
innodb_log_buffer_size = 32M

innodb_flush_log_at_trx_commit = 2

table_cache = 1024
thread_cache_size = 64
query_cache_size = 512M
query_cache_limit = 32M 
max_allowed_packet = 16M

max_connections = 300

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Clone this wiki locally