Shulou(Shulou.com)06/01 Report--

1. Failed to start MySQL all the time. Check error log / var/log/mysql/error.log

two。 The main error messages are as follows:

[ERROR] InnoDB: mmap (136151040 bytes) failed; errno 12 [ERROR] InnoDB: Cannot allocate memory for the buffer pool [ERROR] InnoDB: Plugin initialization aborted with error Generic error [ERROR] Plugin 'InnoDB' init function returned error. [ERROR] Plugin' InnoDB' registration as a STORAGE ENGINE failed. [ERROR] Failed to initialize plugins. [ERROR] Aborting

3. After query, it is due to insufficient memory. Check the memory.

Increase swap swap space to solve the problem:

Dd if=/dev/zero of=/swapfile bs=1M count=1024mkswap / swapfileswapon / swapfile

4. Add automatic mount:

Add / swapfile swap swap defaults 0 0 to the file / etc/fstab

Service mysql start started successfully

5. Remarks:

Generate an empty file

Dd if=/dev/zero of=1.txt bs=1M count=2 generates an empty file of specified size if= filename: input filename of= filename: output filename bs= byte size count= number

Summary

The above is the perfect solution to the startup failure of the common lack of memory in MySQL introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.