Thursday, October 29, 2015

Посоветуйте по my.cnf

Имею VDS с оперативкой 1Gb
Почти вся база переведена в InnoDb

файл my.cnf

[mysqld]
default_storage_engine=innodb
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 2M
max_allowed_packet = 2M
table_open_cache = 500
table_definition_cache = 100
join_buffer_size = 16M
sort_buffer_size = 256K
read_buffer_size = 256K
net_buffer_length = 4K
read_rnd_buffer_size = 256K
myisam_sort_buffer_size = 256K
thread_cache_size = 8
query_cache_size = 64M...

Посоветуйте по my.cnf Посоветуйте по my.cnf

No comments:

Post a Comment