Home > database >  Mysql restart automatically, automatic restart about half a day
Mysql restart automatically, automatic restart about half a day

Time:10-05

Below is the log file:

170831 11:25:59 mysqld_safe Starting mysqld daemon with databases from/var/lib/mysql
170831 11:25:59 [Note]/usr/libexec/mysqld (mysqld 5.5.52 - MariaDB) starting as the process of 20615...
170831 11:25:59 InnoDB: The InnoDB heap memory is disabled
170831 11:25:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170831 11:25:59 InnoDB: Compressed tables use zlib 1.2.7
170831 11:25:59 InnoDB: Using Linux native AIO
170831 11:25:59 InnoDB: Initializing buffer pool, size=128.0 M
170831 11:25:59 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file./ibdata1 did not exist:
InnoDB: a new database to be created!
170831 11:25:59 InnoDB: Setting the file./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
170831 11:25:59 InnoDB: the Log file./ib_logfile0 did not exist: new to be created
InnoDB: Setting the log file./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
170831 11:25:59 InnoDB: the Log file./ib_logfile1 did not exist: new to be created
InnoDB: Setting the log file./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment (s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
170831 11:25:59 InnoDB: Waiting for the background threads to start
170831 11:26:00 Percona XtraDB 5.5.49 - MariaDB 38.0 started; The log sequence number 0
170831 11:26:00 [Note] the Plugin 'FEEDBACK is disabled.
170831 11:26:00 [Note] Server socket created on IP: '0.0.0.0.
170831 11:26:00 [Note] Event Scheduler: the Loaded 0 events
170831 11:26:00 [Note]/usr/libexec/mysqld: ready for connections.
Version: '5.5.52 - MariaDB' socket: '/var/lib/mysql/mysql. The sock' port: 3306 MariaDB Server
170831 15:33:57 [Warning] IP address '140.205.225.204' could not be resolved: the Name or service not known
170831 15:38:39 [Warning] IP address '60.191.38.78' could not be resolved: the Name or service not known
170831 17:02:38 [Warning] IP address '140.205.201.41' could not be resolved: the Name or service not known
170831 17:05:13 [Warning] IP address '123.59.56.127' could not be resolved: the Name or service not known
170831 21:02:37 mysqld_safe Number of the processes running now: 0
Pack up 170831 21:02:37 mysqld_safe mysqld restarted
Often is to shut down the mysql need open to start the mysql server

CodePudding user response:

Monitoring mysql memory usage should be OOM
  • Related