Ошибка CentOS 7 - Job for mariadb.service failed because the control process exited with error code. See

И так после установки mariadb​ на CentOS 7, пытаемся поднять службу, а она выдет ошибку:

[root@yourserver ~]# systemctl start mariadb
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.

 

Смотрим лог:

151218 07:15:13 mysqld_safe Number of processes running now: 0 151218 07:15:13 mysqld_safe mysqld restarted

151218 7:15:13 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB) starting as process 16908 ...

151218 7:15:13 InnoDB: The InnoDB memory heap is disabled

151218 7:15:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins

151218 7:15:13 InnoDB: Compressed tables use zlib 1.2.7

151218 7:15:13 InnoDB: Using Linux native AIO

151218 7:15:13 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137756672 bytes) failed; errno 12

151218 7:15:13 InnoDB: Completed initialization of buffer pool

151218 7:15:13 InnoDB: Fatal error: cannot allocate memory for the buffer pool

151218 7:15:13 [ERROR] Plugin 'InnoDB' init function returned error.

151218 7:15:13 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

151218 7:15:13 [ERROR] mysqld: Out of memory (Needed 128917504 bytes)

151218 7:15:13 [ERROR] mysqld: Out of memory (Needed 96681984 bytes)

151218 7:15:13 [ERROR] mysqld: Out of memory (Needed 72499200 bytes)

151218 7:15:13 [Note] Plugin 'FEEDBACK' is disabled.

151218 7:15:13 [ERROR] Unknown/unsupported storage engine: InnoDB

151218 7:15:13 [ERROR] Aborting

151218 7:15:13 [Note] /usr/libexec/mysqld: Shutdown complete

Что нужно сделать:

В файле конфигурации сервера баз данных:

/etc/my.cnf and added:

[mysqld]
...
innodb_buffer_pool_size=64000000
...

then restarted mariadb

systemctl restart mariadb.service