MySQL restarting each 10 minutes.

kariha

Verified User
Joined
Sep 12, 2011
Messages
33
MySQL works very nicely. Sometimes the database connection is broken. It comes back in 3-4 seconds.

DirectAdmin Task Queue Log - /var/log/directadmin/errortaskq.log - contains the following contents:
Code:
2019:11:20-11:22:01: service mysqld wasn't running, starting mysqld
2019:11:20-11:32:01: service mysqld wasn't running, starting mysqld
2019:11:20-11:42:01: service mysqld wasn't running, starting mysqld
2019:11:20-11:52:01: service mysqld wasn't running, starting mysqld
2019:11:20-12:02:01: service mysqld wasn't running, starting mysqld
2019:11:20-12:12:01: service mysqld wasn't running, starting mysqld
2019:11:20-12:22:01: service mysqld wasn't running, starting mysqld
2019:11:20-12:32:01: service mysqld wasn't running, starting mysqld
2019:11:20-12:42:01: service mysqld wasn't running, starting mysqld
2019:11:20-12:52:01: service mysqld wasn't running, starting mysqld
2019:11:20-13:02:02: service mysqld wasn't running, starting mysqld
2019:11:20-13:12:01: service mysqld wasn't running, starting mysqld
2019:11:20-13:22:01: service mysqld wasn't running, starting mysqld
2019:11:20-13:32:01: service mysqld wasn't running, starting mysqld
2019:11:20-13:42:01: service mysqld wasn't running, starting mysqld
2019:11:20-13:52:01: service mysqld wasn't running, starting mysqld
2019:11:20-14:02:01: service mysqld wasn't running, starting mysqld
2019:11:20-14:12:01: service mysqld wasn't running, starting mysqld
2019:11:20-14:22:01: service mysqld wasn't running, starting mysqld
2019:11:20-14:32:01: service mysqld wasn't running, starting mysqld
2019:11:20-14:42:01: service mysqld wasn't running, starting mysqld
2019:11:20-14:52:01: service mysqld wasn't running, starting mysqld
2019:11:20-15:02:01: service mysqld wasn't running, starting mysqld
2019:11:20-15:12:01: service mysqld wasn't running, starting mysqld
How can i fix? Thanks.
 

kariha

Verified User
Joined
Sep 12, 2011
Messages
33
5.5.63-MariaDB - MariaDB Server
libmysql - mysqlnd 5.0.12-dev - 20150407
CentOS Linux 7 (Core)
Linux 3.10.0-957.27.2.el7.x86_64
var/lib/mysql log: http://prntscr.com/pzl1ij

Code:
191120 15:52:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
191120 15:52:01 [Note] /usr/sbin/mysqld (mysqld 5.5.63-MariaDB) starting as process 32229 ...
191120 15:52:01 InnoDB: The InnoDB memory heap is disabled
191120 15:52:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
191120 15:52:01 InnoDB: Compressed tables use zlib 1.2.7
191120 15:52:01 InnoDB: Using Linux native AIO
191120 15:52:01 InnoDB: Initializing buffer pool, size = 128.0M
191120 15:52:01 InnoDB: Completed initialization of buffer pool
191120 15:52:01 InnoDB: highest supported file format is Barracuda.
191120 15:52:01  InnoDB: Waiting for the background threads to start
191120 15:52:02 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 29079824
191120 15:52:02 [Note] Plugin 'FEEDBACK' is disabled.
191120 15:52:02 [Note] Server socket created on IP: '0.0.0.0'.
191120 15:52:02 [Note] Event Scheduler: Loaded 0 events
191120 15:52:02 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.63-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
191120 16:01:45 [Note] /usr/sbin/mysqld: Normal shutdown
191120 16:01:45 [Note] Event Scheduler: Purging the queue. 0 events
191120 16:01:45  InnoDB: Starting shutdown...
191120 16:01:47  InnoDB: Shutdown completed; log sequence number 29093942
191120 16:01:47 [Note] /usr/sbin/mysqld: Shutdown complete
 
Top