mysql does not start

stlucas

New member
Joined
Jan 3, 2015
Messages
3
Mysql does not start. (version 5.6)

it says:
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/nl.mypricehost.eu.pid).


the log file read out after start
171125 18:53:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins
171125 18:53:02 InnoDB: Compressed tables use zlib 1.2.3
171125 18:53:02 InnoDB: Using Linux native AIO
171125 18:53:02 InnoDB: Initializing buffer pool, size = 128.0M
171125 18:53:02 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
171125 18:53:02 [ERROR] Plugin 'InnoDB' init function returned error.
171125 18:53:02 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
171125 18:53:02 [ERROR] Unknown/unsupported storage engine: InnoDB
171125 18:53:02 [ERROR] Aborting

171125 18:53:02 [Note] /usr/sbin/mysqld: Shutdown complete

171125 18:53:08 [Note] Plugin 'FEDERATED' is disabled.
171125 18:53:08 InnoDB: The InnoDB memory heap is disabled
171125 18:53:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
171125 18:53:08 InnoDB: Compressed tables use zlib 1.2.3
171125 18:53:08 InnoDB: Using Linux native AIO
171125 18:53:08 InnoDB: Initializing buffer pool, size = 128.0M
171125 18:53:08 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
171125 18:53:08 [ERROR] Plugin 'InnoDB' init function returned error.
171125 18:53:08 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
171125 18:53:08 [ERROR] Unknown/unsupported storage engine: InnoDB
171125 18:53:08 [ERROR] Aborting

171125 18:53:08 [Note] /usr/sbin/mysqld: Shutdown complete

Any Thoughts
 
Hello,

Check this error:

Code:
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!

You might need to remove /var/lib/mysql/ib_logfile* and let mysql to re-create it.

Make sure to have a backup or copy first.
 
Back
Top