Database disconnected Topic is solved

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
warcos
Posts: 9
Joined: Tue Jul 19, 2016 12:18 pm

Database disconnected

Postby warcos » Thu Jan 05, 2017 11:46 pm

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

warcos
Posts: 9
Joined: Tue Jul 19, 2016 12:18 pm

Re: Database disconnected  Topic is solved

Postby warcos » Tue Jan 10, 2017 11:05 pm

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

warcos
Posts: 9
Joined: Tue Jul 19, 2016 12:18 pm

Re: Database disconnected

Postby warcos » Wed Jan 11, 2017 4:52 am

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/0B9rNDafGhH1UUjM0NmJ2UFROYVE/view?usp=sharing

Any suggestions.... Thanks for advance


Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 5 guests