Назад | Перейти на главную страницу

Служба mysql внезапно останавливается в VPSMysql

нужна ваша помощь, чтобы определить, что происходит на моем VPS.

Я предоставил этот mysqld.log, чтобы помочь нам изучить проблемы.

180420 22:42:06 [Warning] IP address '{HIDDEN IP}' could not be resolved: Temporary failure in name resolution
180421 13:16:56 [Warning] IP address '{HIDDEN IP}' could not be resolved: Name or service not known
180421 13:56:50 [Warning] IP address '{HIDDEN IP}' could not be resolved: Temporary failure in name resolution
180421 16:51:59 [Warning] IP address '{HIDDEN IP}' could not be resolved: Name or service not known
180422  0:23:27 [Note] Plugin 'FEDERATED' is disabled.
180422  0:23:27 InnoDB: The InnoDB memory heap is disabled
180422  0:23:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180422  0:23:27 InnoDB: Compressed tables use zlib 1.2.3
180422  0:23:27 InnoDB: Using Linux native AIO
180422  0:23:27 InnoDB: Initializing buffer pool, size = 128.0M
180422  0:23:27 InnoDB: Completed initialization of buffer pool
180422  0:23:27 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 497273580
180422  0:23:27  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 497274894
180422  0:23:28  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
180422  0:23:30  InnoDB: Waiting for the background threads to start
180422  0:23:31 InnoDB: 5.5.55 started; log sequence number 497274894
180422  0:23:31 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
180422  0:23:31 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
180422  0:23:31 [Note] Server socket created on IP: '0.0.0.0'.
180422  0:23:33 [Note] Event Scheduler: Loaded 0 events
180422  0:23:33 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.55'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
180422  0:23:37 [Note] Plugin 'FEDERATED' is disabled.
180422  0:23:37 InnoDB: The InnoDB memory heap is disabled
180422  0:23:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180422  0:23:37 InnoDB: Compressed tables use zlib 1.2.3
180422  0:23:37 InnoDB: Using Linux native AIO
180422  0:23:37 InnoDB: Initializing buffer pool, size = 128.0M
180422  0:23:37 InnoDB: Completed initialization of buffer pool
180422  0:23:37 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 497274894
180422  0:23:37  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 497279312
180422  0:23:38  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
180422  0:23:38  InnoDB: Waiting for the background threads to start
180422  0:23:39 InnoDB: 5.5.55 started; log sequence number 497279312
180422  0:23:39 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
180422  0:23:39 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
180422  0:23:39 [Note] Server socket created on IP: '0.0.0.0'.
180422  0:23:39 [Note] Event Scheduler: Loaded 0 events
180422  0:23:39 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.55'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
180422  0:23:41 [Note] Plugin 'FEDERATED' is disabled.
180422  0:23:41 InnoDB: The InnoDB memory heap is disabled
180422  0:23:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180422  0:23:41 InnoDB: Compressed tables use zlib 1.2.3
180422  0:23:41 InnoDB: Using Linux native AIO
180422  0:23:41 InnoDB: Initializing buffer pool, size = 128.0M
180422  0:23:41 InnoDB: Completed initialization of buffer pool
180423 21:58:08 [Note] Plugin 'FEDERATED' is disabled.
180423 21:58:08 InnoDB: The InnoDB memory heap is disabled
180423 21:58:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180423 21:58:08 InnoDB: Compressed tables use zlib 1.2.3
180423 21:58:08 InnoDB: Using Linux native AIO
180423 21:58:08 InnoDB: Initializing buffer pool, size = 128.0M
180423 21:58:08 InnoDB: Completed initialization of buffer pool
180423 21:58:08 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 497279312
180423 21:58:08  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 497280150
180423 21:58:08  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
180423 21:58:09  InnoDB: Waiting for the background threads to start
180423 21:58:10 InnoDB: 5.5.55 started; log sequence number 497280150
180423 21:58:10 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
180423 21:58:10 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
180423 21:58:10 [Note] Server socket created on IP: '0.0.0.0'.
180423 21:58:10 [Note] Event Scheduler: Loaded 0 events
180423 21:58:10 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.55'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi

Это моя спецификация:

Mysql version 5.5.55
CPU Cores count 2
Total CPU(s) speed 2400Mhz
Memory 1 GB
Centos 6 32 bit
using Vesta CP

Из журналов выше, что не так с моим VPS, mysql всегда внезапно останавливается, как автоматически запускать службу mysql после этого?

Любая помощь будет оценена, спасибо.