Perfect solution to MySQL common insufficient memory startup failure

1. If MySQL is not started successfully, check the error log /var/log/mysql/error.log

2. 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 querying, it is because of insufficient memory. Check the memory

Increase the swap space to solve the problem:

dd if=/dev/zero of=/swapfile bs=1M count=1024
mkswap /swapfile
swapon /swapfile 

4. Add automatic mounting:

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

service mysql start Started successfully

5. Notes:

Generate an empty file

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

Summarize

The above is the perfect solution to the common MySQL startup failure due to insufficient memory that I introduced to you. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!