Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section Database Server
  • Search

Database disconnected

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
3 posts • Page 1 of 1
warcos
Posts: 10
Joined: Tue Jul 19, 2016 12:18 pm

Database disconnected
  • Quote

Post by 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
Top

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

Re: Database disconnected
  • Quote

Post by 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
Top

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

Re: Database disconnected
  • Quote

Post by 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/0B9rNDa ... sp=sharing

Any suggestions.... Thanks for advance
Top


Post Reply
  • Print view

3 posts • Page 1 of 1

Return to “Database Server”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password