MySQL server frequently shutting down

by Alex Rsk   Last Updated November 15, 2017 07:00 AM

I have VPS with Ubuntu 14.04, LAMP stack and about 30 small web applications on it. Installed MySQL 5.5.8. It generally works, but sometimes stops by unknown reason. /var/log/mysql/error.log doesn't have nothing except startup information.

My.cnf :

user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
wait_timeout = 28800
interactive_timeout = 28800
key_buffer              = 16M
max_allowed_packet      = 1024M
net_read_timeout        = 720
net_write_timeout       = 720
thread_stack            = 192K
myisam-recover         = BACKUP
max_connections        = 30
innodb_buffer_pool_size = 1G
innodb_force_recovery = 1
query_cache_limit       = 16M
query_cache_size        = 0

Memory free -h:

            total         used       free     shared    buffers     cached
Mem:          6.6G       6.4G       233M        67M       280M       5.0G
-/+ buffers/cache:       1.1G       5.5G
Swap:         2.9G        22M       2.9G

I checked all logs for OOM messages, but got nothing. I removed AppArmor, it didn't work out. I tried just all. What can be reason?

Tags : linux mysql


Related Questions



Slave replication stops with Last_SQL_Errno: 1032

Updated July 15, 2017 23:00 PM

Mysql master slave replication fail PID error

Updated October 21, 2015 10:00 AM


Mysql replication delay

Updated November 13, 2017 08:00 AM