- Plesk for Linux
- Plesk is not accessible:
CONFIG_TEXT: Error 2002. ERROR: PleskDBException: Unable to connect to database: mysql_connect(): Connection refused /var/run/mysqld/mysqld.sock (Error code: 2002)
- MySQL crashes intermittently. There is an error in
CONFIG_TEXT: InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
InnoDB: Completed initialization of buffer pool
InnoDB: Fatal error: cannot allocate memory for the buffer pool
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[ERROR] Unknown/unsupported storage engine: InnoDB
MySQL buffer size is bigger than free RAM available on the server.
Contact system administrator to allocate more RAM to the server.
As a temporary workaround:
- Connect to the server using SSH.
- Check how much free RAM there is on the server:
# free -hm
total used free shared buffers cached
Mem: 1.0G 122M 901M 92K 0B 61M
-/+ buffers/cache: 61M 962M
Swap: 1.0G 0B 1.0G
- Set MySQL buffer pool size in
/etc/my.cnfless than amount of free RAM:
- Restart MySQL service:
# service mysqld restart || service mysql restart || service mariadb restart