Log a MySQL process crash and fail to restart troubleshooting

Recently the program is running for a few days, suddenly can't access, check the application process is still there. Only the database process is down. Then find the log file to see the following error

 .- -- -  on: -: - 19934[Note] Innodb:initializing buffer pool, size =512.0MInnodb:mmap (137363456bytes) failed; Errno A .- -- -  on: -: - 19934[ERROR] Innodb:cannot Allocate Memory forThe buffer pool .- -- -  on: -: - 19934[ERROR] Plugin'InnoDB'Initfunctionreturned error. .- -- -  on: -: - 19934[ERROR] Plugin'InnoDB'registration as a STORAGE ENGINE failed. .- -- -  on: -: - 19934[ERROR] unknown/Unsupported Storage Engine:innodb .- -- -  on: -: - 19934[ERROR] Aborting

This means that there is not enough memory to create a buffer pool for InnoDB. It turns out that's the reason, and then it's solved. In the/ETC/MY.CNF, set the buffer memory to a smaller point.

Innodb_buffer_pool_size = 128M

Of course, the rich master, can directly ignore this way, plus memory on it.

PS: The default log file is in the MySQL data directory, the file name is the computer name. Err, you can also view show variables like ' log_% ' by this command;

This article is reproduced from the Java Chinese community: https://www.javafm.com/issue/134

Log a MySQL process crash and fail to restart troubleshooting