Page 1 of 1

Database disconnected

Posted: Thu Jan 05, 2017 11:46 pm
by warcos
2gb of ram, this happend on different servers. Reintall with ngix, then apache. No fix. Recommended setting for MySQL? Thank for any help. ┬┐This happend after last update of vesta?

My current setting.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0

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

#innodb_use_native_aio = 0
innodb_file_per_table

max_connections=50
max_user_connections=25
wait_timeout=10
interactive_timeout=50
long_query_time=5

#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

Re: Database disconnected

Posted: Tue Jan 10, 2017 11:05 pm
by warcos
Well, this config resolve my "problem", mariadb stable with 2gb of ram (digital ocean).

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 16M
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

#innodb_use_native_aio = 0
innodb_file_per_table

max_connections=70
max_user_connections=30
wait_timeout=10
interactive_timeout=50
long_query_time=5

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

Re: Database disconnected

Posted: Wed Jan 11, 2017 4:52 am
by warcos
Like magic, 14,000,000 queries and bummmm mariadb shutdown....

Queries Image:http://imgur.com/a/9RTmb
Connections image: http://imgur.com/a/LeiFq
Memory image:http://imgur.com/a/OIzsA
log file: https://drive.google.com/file/d/0B9rNDa ... sp=sharing

Any suggestions.... Thanks for advance