Serviço Mysql para de vez em quando

0

De vez em quando, o servidor mysql simplesmente se desliga. Não tenho certeza do que posso fazer sobre isso, reiniciar o serviço funciona, mas às vezes os sites ficam inativos por dias antes de eu notar.

Aqui está o log de erros do mysql mas eu não achei nada suspeito:

180415 16:30:59 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
180415 16:30:59 [Note] Plugin 'FEDERATED' is disabled.
180415 16:30:59 InnoDB: The InnoDB memory heap is disabled
180415 16:30:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180415 16:30:59 InnoDB: Compressed tables use zlib 1.2.8
180415 16:30:59 InnoDB: Using Linux native AIO
180415 16:30:59 InnoDB: Initializing buffer pool, size = 64.0M
180415 16:30:59 InnoDB: Completed initialization of buffer pool
180415 16:30:59 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
180415 16:30:59  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...
180415 16:31:00  InnoDB: Waiting for the background threads to start
180415 16:31:01 InnoDB: 5.5.59 started; log sequence number 12320593139
180415 16:31:01 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
180415 16:31:01 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
180415 16:31:01 [Note] Server socket created on IP: '127.0.0.1'.
180415 16:31:01 [Note] Event Scheduler: Loaded 0 events
180415 16:31:01 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.59-0ubuntu0.14.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)

O que posso fazer sobre isso? Talvez definir um cron para reiniciar o serviço de vez em quando?

    
por LubWn 15.04.2018 / 16:39

0 respostas