LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 10-07-2015, 10:38 PM   #1
ilovecentos
LQ Newbie
 
Registered: Sep 2015
Posts: 15

Rep: Reputation: Disabled
Question 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.
 
Old 10-08-2015, 12:06 AM   #2
berndbausch
LQ Addict
 
Registered: Nov 2013
Location: Tokyo
Distribution: Mostly Ubuntu and Centos
Posts: 6,316

Rep: Reputation: 2002Reputation: 2002Reputation: 2002Reputation: 2002Reputation: 2002Reputation: 2002Reputation: 2002Reputation: 2002Reputation: 2002Reputation: 2002Reputation: 2002
Quote:
Originally Posted by ilovecentos View Post
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.
 
Old 10-08-2015, 08:28 PM   #3
ilovecentos
LQ Newbie
 
Registered: Sep 2015
Posts: 15

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by berndbausch View Post
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Trouble starting mysqld bluegospel Linux - Server 5 08-14-2013 11:17 AM
Trouble starting mysqld koodoo Linux - Newbie 4 08-16-2005 10:09 AM
starting mysqld + OpenBSD Gsee *BSD 0 02-01-2005 05:36 AM
starting mysqld zobra Linux - Software 6 12-06-2004 11:27 PM
HELP! mysqld starting problem pravi Linux - Software 1 10-27-2004 11:20 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 03:33 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration