Сегодня сайт стал показывать ошибку при подключении к БД. После перезагрузки все пришло в норму, но мне хотелось бы узнать, по какой причине могла крашнуться БД.
Вот лог:
170127 17:00:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170127 17:00:34 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170127 17:00:34 [Note] /usr/sbin/mysqld (mysqld 5.5.53-0+deb8u1) starting as process 21777 ...
170127 17:00:34 [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.
170127 17:00:34 [Note] Plugin 'FEDERATED' is disabled.
170127 17:00:34 InnoDB: The InnoDB memory heap is disabled
170127 17:00:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170127 17:00:34 InnoDB: Compressed tables use zlib 1.2.8
170127 17:00:34 InnoDB: Using Linux native AIO
170127 17:00:34 InnoDB: Initializing buffer pool, size = 128.0M
170127 17:00:34 InnoDB: Completed initialization of buffer pool
170127 17:00:34 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!
170127 17:00:34 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...
170127 17:00:35 InnoDB: Waiting for the background threads to start
170127 17:00:36 InnoDB: 5.5.53 started; log sequence number 289720931
170127 17:00:36 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
170127 17:00:36 [Note] - '127.0.0.1' resolves to '127.0.0.1';
170127 17:00:36 [Note] Server socket created on IP: '127.0.0.1'.
170127 17:00:36 [Note] Event Scheduler: Loaded 0 events
170127 17:00:36 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.53-0+deb8u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
Из-за чего это может произойти? Как можно решить эту проблему, чтобы избежать крашей?
Средний
