Почему периодически зависает mysql сервис?

Question

[FRANZEE]

Здравствуйте, Периодически зависает mysql сервис. На сайте пропадает весь контент.
Помогает команда sudo service mysql restart.

Логи:

151023 14:10:15 [Warning] Using unique option prefix myisam-recover instead of $
151023 14:10:15 [Note] Plugin 'FEDERATED' is disabled.
151023 14:10:15 InnoDB: The InnoDB memory heap is disabled
151023 14:10:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151023 14:10:15 InnoDB: Compressed tables use zlib 1.2.8
151023 14:10:15 InnoDB: Using Linux native AIO
151023 14:10:15 InnoDB: Initializing buffer pool, size = 128.0M
151023 14:10:15 InnoDB: Completed initialization of buffer pool
151023 14:10:15 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!
151023 14:10:15  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...
151023 14:10:15  InnoDB: Waiting for the background threads to start
151023 14:10:16 InnoDB: 5.5.44 started; log sequence number 1595695
151023 14:10:16 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151023 14:10:16 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
151023 14:10:16 [Note] Server socket created on IP: '127.0.0.1'.
151023 14:10:17 [Note] Event Scheduler: Loaded 0 events
151023 14:10:17 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.44-0ubuntu0.14.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port$
151023 14:10:18 [ERROR] /usr/sbin/mysqld: Table './argrkmodx/modx_manager_log' $
151023 14:10:18 [Warning] Checking table:   './argrkmodx/modx_manager_log'
151023 14:10:18 [ERROR] /usr/sbin/mysqld: Table './argrkmodx/modx_quip_threads'$
151023 14:10:18 [Warning] Checking table:   './argrkmodx/modx_quip_threads'
151023 14:10:18 [ERROR] /usr/sbin/mysqld: Table './argrkmodx/modx_register_mess$
151023 14:10:18 [Warning] Checking table:   './argrkmodx/modx_register_messages'
151023 14:10:18 [ERROR] /usr/sbin/mysqld: Table './argrkmodx/modx_site_content'$
151023 14:10:18 [Warning] Checking table:   './argrkmodx/modx_site_content'
151023 14:10:18 [ERROR] /usr/sbin/mysqld: Table './argrkmodx/modx_site_tmplvar_$
151023 14:10:18 [Warning] Checking table:   './argrkmodx/modx_site_tmplvar_cont$
151023 14:10:18 [ERROR] /usr/sbin/mysqld: Table './argrkmodx/modx_user_attribut$
151023 14:10:18 [Warning] Checking table:   './argrkmodx/modx_user_attributes'

Подскажите как вылечить?

Comments

[Макс]

а что говорит cat /var/log/mysql.err ?

[FRANZEE]

Макс: Ничего в ответ

[Макс]

FRANZEE: а в cat /var/log/mysql/error.log, я так понимаю, как раз вот то, что Вы привели здесь.. А какая последняя информация перед рестартом?

[FRANZEE]

Макс:
вывод cat /var/log/mysql/error.log
151023 14:10:15 [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.
151023 14:10:15 [Note] Plugin 'FEDERATED' is disabled.
151023 14:10:15 InnoDB: The InnoDB memory heap is disabled
151023 14:10:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151023 14:10:15 InnoDB: Compressed tables use zlib 1.2.8
151023 14:10:15 InnoDB: Using Linux native AIO
151023 14:10:15 InnoDB: Initializing buffer pool, size = 128.0M
151023 14:10:15 InnoDB: Completed initialization of buffer pool
151023 14:10:15 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!
151023 14:10:15 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...
151023 14:10:15 InnoDB: Waiting for the background threads to start
151023 14:10:16 InnoDB: 5.5.44 started; log sequence number 1595695
151023 14:10:16 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151023 14:10:16 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151023 14:10:16 [Note] Server socket created on IP: '127.0.0.1'.
151023 14:10:17 [Note] Event Scheduler: Loaded 0 events
151023 14:10:17 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.44-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151023 14:10:18 [ERROR] /usr/sbin/mysqld: Table './argrkmodx/modx_manager_log' is marked as crashed and should be repaired
151023 14:10:18 [Warning] Checking table: './argrkmodx/modx_manager_log'
151023 14:10:18 [ERROR] /usr/sbin/mysqld: Table './argrkmodx/modx_quip_threads' is marked as crashed and should be repaired
151023 14:10:18 [Warning] Checking table: './argrkmodx/modx_quip_threads'
151023 14:10:18 [ERROR] /usr/sbin/mysqld: Table './argrkmodx/modx_register_messages' is marked as crashed and should be repaired
151023 14:10:18 [Warning] Checking table: './argrkmodx/modx_register_messages'
151023 14:10:18 [ERROR] /usr/sbin/mysqld: Table './argrkmodx/modx_site_content' is marked as crashed and should be repaired
151023 14:10:18 [Warning] Checking table: './argrkmodx/modx_site_content'
151023 14:10:18 [ERROR] /usr/sbin/mysqld: Table './argrkmodx/modx_site_tmplvar_contentvalues' is marked as crashed and should be repaired
151023 14:10:18 [Warning] Checking table: './argrkmodx/modx_site_tmplvar_contentvalues'
151023 14:10:18 [ERROR] /usr/sbin/mysqld: Table './argrkmodx/modx_user_attributes' is marked as crashed and should be repaired
151023 14:10:18 [Warning] Checking table: './argrkmodx/modx_user_attributes'
151023 15:29:34 [Note] /usr/sbin/mysqld: Normal shutdown

151023 15:29:34 [Note] Event Scheduler: Purging the queue. 0 events
151023 15:29:34 InnoDB: Starting shutdown...
151023 15:29:35 InnoDB: Shutdown completed; log sequence number 1595695
151023 15:29:35 [Note] /usr/sbin/mysqld: Shutdown complete

151023 15:29:46 [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.
151023 15:29:46 [Note] Plugin 'FEDERATED' is disabled.
151023 15:29:46 InnoDB: The InnoDB memory heap is disabled
151023 15:29:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151023 15:29:46 InnoDB: Compressed tables use zlib 1.2.8
151023 15:29:46 InnoDB: Using Linux native AIO
151023 15:29:46 InnoDB: Initializing buffer pool, size = 128.0M
151023 15:29:46 InnoDB: Completed initialization of buffer pool
151023 15:29:46 InnoDB: highest supported file format is Barracuda.
151023 15:29:46 InnoDB: Waiting for the background threads to start
151023 15:29:47 InnoDB: 5.5.44 started; log sequence number 1595695
151023 15:29:47 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151023 15:29:47 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151023 15:29:47 [Note] Server socket created on IP: '127.0.0.1'.
151023 15:29:47 [Note] Event Scheduler: Loaded 0 events
151023 15:29:47 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.44-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)

[Макс]

FRANZEE: так он не помирает, его restart нормально гасит. Вот почему дуба дает.... консоль при этом подключается? может какой запрос блокирует таблицу?

[FRANZEE]

По ssh нормально подключаюсь. Может быть криво работает MODX, сайт в студии ужасно сделали (

вывод top:
Tasks: 86 total, 2 running, 84 sleeping, 0 stopped, 0 zombie
%Cpu(s): 5.0 us, 0.0 sy, 0.0 ni, 95.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st
KiB Mem: 501776 total, 392652 used, 109124 free, 17900 buffers
KiB Swap: 0 total, 0 used, 0 free. 253960 cached Mem

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2740 root 20 0 104416 3972 2904 S 4.7 0.8 0:00.15 sshd
45 root 20 0 0 0 0 S 0.3 0.0 0:00.59 kworker/u2:1
1 root 20 0 33484 2792 1468 S 0.0 0.6 0:01.08 init
2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd
3 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
5 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/0:0H
7 root 20 0 0 0 0 S 0.0 0.0 0:00.32 rcu_sched
8 root 20 0 0 0 0 R 0.0 0.0 0:00.27 rcuos/0
9 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcu_bh
10 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcuob/0
11 root rt 0 0 0 0 S 0.0 0.0 0:00.00 migration/0
12 root rt 0 0 0 0 S 0.0 0.0 0:00.02 watchdog/0
13 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 khelper
14 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kdevtmpfs
15 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 netns
16 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 writeback
17 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kintegrityd

Answer 1

[Aleksey Ratnikov]

Вам нужно посмотреть error_log, там написано, что вызвало фатальную ошибку. А также binary_log, чтобы посмотреть, какие инструкции выполнялись перед падением. Они по умолчанию складываются в /var/log/mysql.

Answer 2

[Пума Тайланд]

либо кончается место, либо свободная память и его убивает системный oomkiller