Why mysql service hangs periodically?

Question

MySQL

Hello, mysql service hangs intermittently. All content on the site disappears.
The sudo service mysql restart command helps.
Logs:

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'

Tell me how to cure?

Answer 1

You need to look at the error_log, it says what caused the fatal error. And also binary_log to see what instructions were executed before the crash. They are stored in /var/log/mysql by default.

Answer 2

either running out of space or free memory and the system oomkiller kills it