MilesWeb
MilesWeb Hosting Forum

Please login or register.

Login with username, password and session length

 

News:

SMF - Just Installed!


Author Topic: MySQL:- Starting MySQL: [FAILED]  (Read 3900 times)

0 Members and 1 Guest are viewing this topic.

Offline Dipak Bhoi

  • MilesWeb Team Member
  • Full Member
  • ***
  • Posts: 208
  • Karma: +5/-0
    • View Profile
    • MilesWeb Internet Services
MySQL:- Starting MySQL: [FAILED]
« on: June 08, 2014, 11:36:21 AM »
Hello guys,

Are you getting following error at the time of starting mysql service on server:

Quote
# service mysql start
Starting MySQL: [FAILED]

Now you need to check the error logs on server. Login to your server via SSH as a root user and follow the below steps to resolve the issue.

Quote
#less /var/lib/mysql/hostname.err

Above command will show the mysql error logs.  You need to find the error in this logs. We have identified the below error.

Quote
140531  8:15:04 [Note] Plugin 'FEDERATED' is disabled.
140531  8:15:04 InnoDB: The InnoDB memory heap is disabled
140531  8:15:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140531  8:15:04 InnoDB: Compressed tables use zlib 1.2.3
140531  8:15:04 InnoDB: Using Linux native AIO
140531  8:15:04 InnoDB: Initializing buffer pool, size = 128.0M
140531  8:15:04 InnoDB: Completed initialization of buffer pool
140531  8:15:04 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140531  8:15:04  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
140531  8:15:04  InnoDB: Waiting for the background threads to start
140531  8:15:05 InnoDB: 5.5.36 started; log sequence number 4480722
140531  8:15:05 [ERROR] /usr/sbin/mysqld: unknown variable 'record_buffer=1M'
140531  8:15:05 [ERROR] Aborting

140531  8:15:05  InnoDB: Starting shutdown...
140531  8:15:06  InnoDB: Shutdown completed; log sequence number 4480722
140531  8:15:06 [Note] /usr/sbin/mysqld: Shutdown complete

140531 08:15:06 mysqld_safe mysqld from pid file /var/lib/mysql/hostnmae.pid ended

In above error you can see [ERROR] /usr/sbin/mysqld: unknown variable 'record_buffer=1M' .

To resolve this error you need to Remove record_buffer=1M from your my.cnf file and try again.

Quote
#vi /etc/my.cnf

Now remove the record_buffer=1M and save the file.

Now try to restart the MySQL service, It should be working now.

Enjoy !!!
« Last Edit: June 08, 2014, 03:16:57 PM by Turkey »
MilesWeb.com
cPanel Hosting in India - cPanel Hosting in India.

Grab an SSL for your website and SAVE 20% now. Coupon Code SSLSAVE20.

MilesWeb Hosting Forum

MySQL:- Starting MySQL: [FAILED]
« on: June 08, 2014, 11:36:21 AM »