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

Mysql gets killed and shutdown all my website

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
2 posts • Page 1 of 1
tomtom
Posts: 3
Joined: Mon Jun 25, 2018 6:14 am

Os: CentOS 6x
Web: apache + nginx
Mysql gets killed and shutdown all my website
  • Quote

Post by tomtom » Fri Jul 06, 2018 7:05 am

Hello, i have 2gb vps with centos 6 and vestacp and i'm hosting few websites. Sometimes there are random crashes of the database and almost all of my websites gets shutdown and it is really frustrating.. Maybe you can help me find a reason why. innodb buffer size is 1GB.

with command top:
Image

with free -m
Image

grep -i 'killed process'
Image

I know from this that my database get killed but why? and how to prevent it.. If you need any more logs please ask. Any help is appreciated because i'm fighting this for a long time..

Also there is var/log/messages in pastebin:
https://pastebin.com/Xfh0Th6V
Top

xorro
Posts: 87
Joined: Sun Nov 13, 2016 3:11 pm
Contact:
Contact xorro
Website Skype

Os: CentOS 6x
Web: apache + nginx
Re: Mysql gets killed and shutdown all my website
  • Quote

Post by xorro » Mon Sep 10, 2018 4:17 pm

have you tried increasing memory limit in MySQL / MariaDb configurations?
Top


Post Reply
  • Print view

2 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