Доброе утро! Я просмотрел предыдущий пост об изменении схемы производительности на «Выкл.» В настройках конфигурации. Похоже, что наша конфигурация уже настроена на это. Так что не уверен, что может вызвать проблемы с сбоями.
[root@#### etc]# vim my.cnf
[mysqld]
general_log = 1
general_log_file=/var/log/mariadb/query.log
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
innodb_file_per_table = 1
#thread_stack = 131072
# mgk change 11/23/15
thread_stack = 256k
net_buffer_length = 2K
read_rnd_buffer_size = 256K
read_buffer_size = 256K
sort_buffer_size = 64K
table_open_cache = 4
max_allowed_packet = 1M
key_buffer_size = 16K
performance_schema = off
Вот сводка журнала
InnoDB: mmap(137756672 bytes) failed; errno 12
160329 11:44:50 InnoDB: Completed initialization of buffer pool
160329 11:44:50 InnoDB: Fatal error: cannot allocate memory for the buffer pool
160329 11:44:50 [ERROR] Plugin 'InnoDB' init function returned error.
160329 11:44:50 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160329 11:44:50 [ERROR] mysqld: Out of memory (Needed 128917504 bytes)
160329 11:44:50 [ERROR] mysqld: Out of memory (Needed 96681984 bytes)
160329 11:44:50 [Note] Plugin 'FEEDBACK' is disabled.
160329 11:44:50 [ERROR] Unknown/unsupported storage engine: InnoDB
160329 11:44:50 [ERROR] Aborting
160329 11:44:50 [Note] /usr/libexec/mysqld: Shutdown complete
160329 11:44:50 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
160329 12:46:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160329 12:46:48 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB-log) starting as process 7488 ...
160329 12:46:48 InnoDB: The InnoDB memory heap is disabled
160329 12:46:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160329 12:46:48 InnoDB: Compressed tables use zlib 1.2.7
160329 12:46:48 InnoDB: Using Linux native AIO
160329 12:46:48 InnoDB: Initializing buffer pool, size = 128.0M
160329 12:46:48 InnoDB: Completed initialization of buffer pool
160329 12:46:48 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 2502249177
160329 12:46:48 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
160329 11:44:50 [ОШИБКА] mysqld: недостаточно памяти (необходимо 96681984 байта)
Per @ michael-sqlbot выглядит так Сервер Ubuntu 12.04 - MySQL продолжает вылетать - Возможные проблемы InnoDB - Ошибка сервера охватывает вашу проблему.