Answer the question
In order to leave comments, you need to log in
Where and how to fix the config so that mysql does not fall?
Periodically falls north, the last week very often.
Here are the last lines from the log
170128 19:38:09 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
170128 19:38:09 InnoDB: Completed initialization of buffer pool
170128 19:38:09 InnoDB: Fatal error: cannot allocate memory for the buffer pool
170128 19:38:09 [ERROR] Plugin 'InnoDB' init function returned error.
170128 19:38:09 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170128 19:38:09 [ERROR] Unknown/unsupported storage engine: InnoDB
170128 19:38:09 [ERROR] Aborting
170128 19:38:09 [Note] /usr/sbin/mysqld: Shutdown complete
Answer the question
In order to leave comments, you need to log in
https://www.digitalocean.com/community/questions/m...
Shortly: add (or replace existing line) to the /etc/mysql/my.cnf :
This will decrease mysql requirements.
And here is the original answer (with explanations):
stackoverflow.com/a/12683951/1115187
Another approaches to solve the problem:
askubuntu.com/a/457932/400409
0 google link
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question