Vesta Control Panel - Forum

Posted: **Sat Jan 09, 2016 3:48 pm**

Прошу посмотреть my.cnf

Cервер:
Процессор
1 ядро Intel Xeon
ОЗУ DDR4
1024 Mb
SSD-диск
20 000 Mb
Сделал swap 1Gb, но время от времени вылазит 500 ошибка или мускул падает с out of memory.

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
bind-address = 127.0.0.1
skip-networking

skip-external-locking
max_allowed_packet = 1M
table_open_cache = 4K
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 240K

key_buffer_size = 1M
query_cache_size = 8m
tmp_table_size = 16M
max_heap_table_size = 16M
thread_cache_size = 4
innodb_buffer_pool_size=128M
innodb_use_sys_malloc = 0

#innodb_use_native_aio = 0
innodb_file_per_table

wait_timeout=30
interactive_timeout=100

#slow_query_log=1
#slow_query_log_file=/var/log/mysql-slow-queries.log

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

Posted: **Mon Jan 11, 2016 10:22 am**

Привет, можно вот такой попробовать

SpoilerShow

Code: Select all

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
bind-address = 127.0.0.1
skip-networking
skip-external-locking

myisam_recover=FORCE
character_set_server=utf8
collation_server=utf8_general_ci
max_allowed_packet=16M
max_connect_errors=1000000
open_files_limit=65535
wait_timeout=300
max_connections=150
max_user_connections=30
innodb_file_per_table=1
innodb_buffer_pool_size=64M

thread_cache_size=8
table_definition_cache=2048
table_open_cache=2048
key_buffer_size=24M
sort_buffer_size=8M
myisam_sort_buffer_size=8M
join_buffer_size=4M
query_cache_size=4M
query_cache_limit=512K

#Fixes high memory usage in mysql5.6 - 390MB!!!
performance_schema=0

Posted: **Mon Jan 11, 2016 10:29 am**

Можно попробовать отсюда взять:
viewtopic.php?f=14&t=5049#p12743

Vesta Control Panel - Forum

подскажите с конфигом

подскажите с конфигом

Re: подскажите с конфигом

Re: подскажите с конфигом