LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   Starting mysqld:[FAILED] (https://www.linuxquestions.org/questions/linux-server-73/starting-mysqld-%5Bfailed%5D-4175555586/)

ilovecentos 10-07-2015 10:38 PM

Starting mysqld:[FAILED]
 
Hello guys,
I have an issued regarding my mysql. As I already edit my.cnf,after i performing service mysqld restart. It failed to start. And here is the log error:-

151008 3:18:35 InnoDB: Completed initialization of buffer pool
151008 3:18:35 InnoDB: Fatal error: cannot allocate memory for the buffer pool
151008 3:18:35 [ERROR] Plugin 'InnoDB' init function returned error.
151008 3:18:35 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151008 3:18:35 [ERROR] Unknown/unsupported storage engine: InnoDB
151008 3:18:35 [ERROR] Aborting

151008 3:18:35 [Note] /usr/libexec/mysqld: Shutdown complete

151008 03:18:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended


what am i supposed to do to run mysql normally.

berndbausch 10-08-2015 12:06 AM

Quote:

Originally Posted by ilovecentos (Post 5431539)
Hello guys,
I have an issued regarding my mysql. As I already edit my.cnf,after i performing service mysqld restart. It failed to start. And here is the log error:-

151008 3:18:35 InnoDB: Completed initialization of buffer pool
151008 3:18:35 InnoDB: Fatal error: cannot allocate memory for the buffer pool
151008 3:18:35 [ERROR] Plugin 'InnoDB' init function returned error.
151008 3:18:35 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151008 3:18:35 [ERROR] Unknown/unsupported storage engine: InnoDB
151008 3:18:35 [ERROR] Aborting

151008 3:18:35 [Note] /usr/libexec/mysqld: Shutdown complete

151008 03:18:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended


what am i supposed to do to run mysql normally.

This message:
Code:

Fatal error: cannot allocate memory for the buffer pool
indicates that you are out of memory. Perhaps you need to play with the innodb_buffer_pool_size parameter.

Also a tip: Somebody more knowledgeable about MySQL could comment if you published your my.cnf.

ilovecentos 10-08-2015 08:28 PM

Quote:

Originally Posted by berndbausch (Post 5431559)
This message:
Code:

Fatal error: cannot allocate memory for the buffer pool
indicates that you are out of memory. Perhaps you need to play with the innodb_buffer_pool_size parameter.

Also a tip: Somebody more knowledgeable about MySQL could comment if you published your my.cnf.


Thank you, after changing my parameter. Its works. :)


All times are GMT -5. The time now is 04:25 AM.