Gauravk

Well-Known Member
Jan 23, 2012
69
0
56
cPanel Access Level
Root Administrator
Please find the error log below:

Code:
130608 21:46:35 [Note] Event Scheduler: Purging the queue. 0 events
130608 21:46:37  InnoDB: Starting shutdown...
130608 21:46:51  InnoDB: Shutdown completed; log sequence number 19541041044
130608 21:46:51 [Note] /usr/sbin/mysqld: Shutdown complete

130608 21:46:51 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 21:47:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 21:47:41 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use InnoDB's own implementation
InnoDB: Compressed tables use zlib 1.2.3
130608 21:47:41  InnoDB: Initializing buffer pool, size = 750.0M
InnoDB: Compressed tables use zlib 1.2.3
130608 21:47:41  InnoDB: Initializing buffer pool, size = 750.0M
130608 21:47:41  InnoDB: Completed initialization of buffer pool
130608 21:47:41  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 50 MB
InnoDB: Database physically writes the file full: wait...
130608 21:47:42  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 50 MB
InnoDB: Database physically writes the file full: wait...
130608 21:47:44  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!
130608 21:47:44  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...
130608 21:47:45 InnoDB Plugin 5.1.68 started; log sequence number 19541041164
130608 21:47:45 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_purge_threads=1'
130608 21:47:45 [ERROR] Aborting

130608 21:47:45  InnoDB: Starting shutdown...
130608 21:47:50  InnoDB: Shutdown completed; log sequence number 19541041164
130608 21:47:50 [Note] /usr/sbin/mysqld: Shutdown complete

130608 21:47:50 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 21:49:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 21:49:36 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use InnoDB's own implementation
InnoDB: Compressed tables use zlib 1.2.3
130608 21:49:36  InnoDB: Initializing buffer pool, size = 750.0M
130608 21:49:36  InnoDB: Completed initialization of buffer pool
130608 21:49:36  InnoDB: highest supported file format is Barracuda.
130608 21:49:36 InnoDB Plugin 5.1.68 started; log sequence number 19541041164
130608 21:49:36 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_purge_threads=1'
130608 21:49:36 [ERROR] Aborting

130608 21:49:36  InnoDB: Starting shutdown...
130608 21:49:42  InnoDB: Shutdown completed; log sequence number 19541041164
130608 21:49:42 [Note] /usr/sbin/mysqld: Shutdown complete

130608 21:49:42 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 21:52:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 21:52:02 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use InnoDB's own implementation
InnoDB: Compressed tables use zlib 1.2.3
130608 21:52:02  InnoDB: Initializing buffer pool, size = 300.0M
130608 21:52:02  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 21:52:02 [ERROR] Plugin 'InnoDB' init function returned error.
130608 21:52:02 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130608 21:52:02 [ERROR] Unknown/unsupported table type: InnoDB
130608 21:52:02 [ERROR] Aborting

130608 21:52:02 [Note] /usr/sbin/mysqld: Shutdown complete
130608 21:52:02 [Note] /usr/sbin/mysqld: Shutdown complete

130608 21:52:02 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 21:53:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 21:53:55 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use InnoDB's own implementation
InnoDB: Compressed tables use zlib 1.2.3
130608 21:53:55  InnoDB: Initializing buffer pool, size = 300.0M
130608 21:53:55  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 21:53:55 [ERROR] Plugin 'InnoDB' init function returned error.
130608 21:53:55 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130608 21:53:55 [ERROR] Unknown/unsupported table type: InnoDB
130608 21:53:55 [ERROR] Aborting

130608 21:53:55 [Note] /usr/sbin/mysqld: Shutdown complete

130608 21:53:55 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 21:55:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 21:55:24 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use InnoDB's own implementation
InnoDB: Compressed tables use zlib 1.2.3
130608 21:55:24  InnoDB: Initializing buffer pool, size = 300.0M
130608 21:55:24  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 21:55:24 [ERROR] Plugin 'InnoDB' init function returned error.
130608 21:55:24 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130608 21:55:24 [ERROR] Unknown/unsupported table type: InnoDB
130608 21:55:24 [ERROR] Aborting

130608 21:55:24 [Note] /usr/sbin/mysqld: Shutdown complete

130608 21:55:24 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 21:56:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 21:56:18 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use InnoDB's own implementation
InnoDB: Compressed tables use zlib 1.2.3
130608 21:56:18  InnoDB: Initializing buffer pool, size = 300.0M
130608 21:56:18  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 21:56:18 [ERROR] Plugin 'InnoDB' init function returned error.
130608 21:56:18 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130608 21:56:18 [ERROR] Unknown/unsupported table type: InnoDB
130608 21:56:18 [ERROR] Aborting

130608 21:56:18 [Note] /usr/sbin/mysqld: Shutdown complete

130608 21:56:18 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 22:02:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 22:02:47 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
130608 22:02:47 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use InnoDB's own implementation
InnoDB: Compressed tables use zlib 1.2.3
130608 22:02:47  InnoDB: Initializing buffer pool, size = 300.0M
130608 22:02:47  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 22:02:47 [ERROR] Plugin 'InnoDB' init function returned error.
130608 22:02:47 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
^G/usr/sbin/mysqld: File '/var/lib/mysql/Server_name-slow.log' not found (Errcode: 13)
130608 22:02:47 [ERROR] Could not use /var/lib/mysql/Server_name-slow.log for logging (error 13). Turning logging off for the whole $
130608 22:02:47 [ERROR] Unknown/unsupported table type: InnoDB
130608 22:02:47 [ERROR] Aborting

130608 22:02:47 [Note] /usr/sbin/mysqld: Shutdown complete

130608 22:02:47 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 22:06:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 22:06:29 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use InnoDB's own implementation
InnoDB: Compressed tables use zlib 1.2.3
130608 22:06:29  InnoDB: Initializing buffer pool, size = 300.0M
130608 22:06:29  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 22:06:29 [ERROR] Plugin 'InnoDB' init function returned error.
130608 22:06:29 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
^G/usr/sbin/mysqld: File '/var/lib/mysql/Server_name-slow.log' not found (Errcode: 13)
130608 22:06:29 [ERROR] Could not use /var/lib/mysql/Server_name-slow.log for logging (error 13). Turning logging off for the whole $
130608 22:06:29 [ERROR] Unknown/unsupported table type: InnoDB
130608 22:06:29 [ERROR] Aborting

130608 22:06:29 [Note] /usr/sbin/mysqld: Shutdown complete

130608 22:06:29 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 22:22:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 22:22:10 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use InnoDB's own implementation
InnoDB: Compressed tables use zlib 1.2.3
130608 22:22:10  InnoDB: Initializing buffer pool, size = 300.0M
130608 22:22:10  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 22:22:10 [ERROR] Plugin 'InnoDB' init function returned error.
130608 22:22:10 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
^G/usr/sbin/mysqld: File '/var/lib/mysql/Server_name-slow.log' not found (Errcode: 13)
130608 22:22:10 [ERROR] Could not use /var/lib/mysql/Server_name-slow.log for logging (error 13). Turning logging off for the whole $
130608 22:22:10 [ERROR] Unknown/unsupported table type: InnoDB
130608 22:22:10 [ERROR] Aborting

130608 22:22:10 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 22:52:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 22:52:34 [Note] Plugin 'FEDERATED' is disabled.
130608 22:52:34  InnoDB: Initializing buffer pool, size = 300.0M
130608 22:52:34  InnoDB: Completed initialization of buffer pool


130608 22:52:34  InnoDB: Initializing buffer pool, size = 300.0M
130608 22:52:34  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 22:52:34 [ERROR] Plugin 'InnoDB' init function returned error.
130608 22:52:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
^G/usr/sbin/mysqld: File '/var/lib/mysql/Server_name-slow.log' not found (Errcode: 13)
130608 22:52:34 [ERROR] Could not use /var/lib/mysql/Server_name-slow.log for logging (error 13). Turning logging off for the whole $
130608 22:52:34 [ERROR] Unknown/unsupported table type: InnoDB
130608 22:52:34 [ERROR] Aborting

130608 22:52:34 [Note] /usr/sbin/mysqld: Shutdown complete

130608 22:52:34 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 22:55:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 22:55:33 [Note] Plugin 'FEDERATED' is disabled.
130608 22:55:33  InnoDB: Initializing buffer pool, size = 300.0M
130608 22:55:33  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 22:55:33 [ERROR] Plugin 'InnoDB' init function returned error.
130608 22:55:33 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
^G/usr/sbin/mysqld: File '/var/lib/mysql/Server_name-slow.log' not found (Errcode: 13)
130608 22:55:33 [ERROR] Could not use /var/lib/mysql/Server_name-slow.log for logging (error 13). Turning logging off for the whole $
130608 22:55:33 [ERROR] Unknown/unsupported table type: InnoDB
130608 22:55:33 [ERROR] Aborting

130608 22:55:33 [Note] /usr/sbin/mysqld: Shutdown complete

130608 22:55:33 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 22:56:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 22:56:52 [Note] Plugin 'FEDERATED' is disabled.
130608 22:56:52  InnoDB: Initializing buffer pool, size = 300.0M
130608 22:56:52  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 22:56:52 [ERROR] Plugin 'InnoDB' init function returned error.
130608 22:56:52 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
^G/usr/sbin/mysqld: File '/var/lib/mysql/Server_name-slow.log' not found (Errcode: 13)
130608 22:56:52 [ERROR] Could not use /var/lib/mysql/Server_name-slow.log for logging (error 13). Turning logging off for the whole $
130608 22:56:52 [ERROR] Unknown/unsupported table type: InnoDB
130608 22:56:52 [ERROR] Aborting

130608 22:56:52 [Note] /usr/sbin/mysqld: Shutdown complete

130608 22:56:52 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 22:57:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 22:57:34 [Note] Plugin 'FEDERATED' is disabled.
130608 22:57:34  InnoDB: Initializing buffer pool, size = 300.0M
130608 22:57:34  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 22:57:34 [ERROR] Plugin 'InnoDB' init function returned error.
130608 22:57:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
^G/usr/sbin/mysqld: File '/var/lib/mysql/Server_name-slow.log' not found (Errcode: 13)
130608 22:57:34 [ERROR] Could not use /var/lib/mysql/Server_name-slow.log for logging (error 13). Turning logging off for the whole $
130608 22:57:34 [ERROR] Unknown/unsupported table type: InnoDB
130608 22:57:34 [ERROR] Aborting

130608 22:57:34 [ERROR] Unknown/unsupported table type: InnoDB
130608 22:57:34 [ERROR] Aborting

130608 22:57:34 [Note] /usr/sbin/mysqld: Shutdown complete

130608 22:57:34 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:01:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:01:19 [Note] Plugin 'FEDERATED' is disabled.
130608 23:01:19  InnoDB: Initializing buffer pool, size = 300.0M
130608 23:01:19  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 23:01:19 [ERROR] Plugin 'InnoDB' init function returned error.
130608 23:01:19 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
^G/usr/sbin/mysqld: File '/var/lib/mysql/Server_name-slow.log' not found (Errcode: 13)
130608 23:01:19 [ERROR] Could not use /var/lib/mysql/Server_name-slow.log for logging (error 13). Turning logging off for the whole $
130608 23:01:19 [ERROR] Unknown/unsupported table type: InnoDB
130608 23:01:19 [ERROR] Aborting

130608 23:01:19 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:01:19 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:01:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:01:54 [Note] Plugin 'FEDERATED' is disabled.
130608 23:01:54  InnoDB: Initializing buffer pool, size = 300.0M
130608 23:01:54  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 23:01:54 [ERROR] Plugin 'InnoDB' init function returned error.
130608 23:01:54 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
^G/usr/sbin/mysqld: File '/var/lib/mysql/Server_name-slow.log' not found (Errcode: 13)
130608 23:01:54 [ERROR] Could not use /var/lib/mysql/Server_name-slow.log for logging (error 13). Turning logging off for the whole $
130608 23:01:54 [ERROR] Unknown/unsupported table type: InnoDB
130608 23:01:54 [ERROR] Aborting

130608 23:01:54 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:01:54 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:02:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:02:02 [Note] Plugin 'FEDERATED' is disabled.
130608 23:02:02  InnoDB: Initializing buffer pool, size = 300.0M
130608 23:02:02  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 23:02:02 [ERROR] Plugin 'InnoDB' init function returned error.
130608 23:02:02 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
^G/usr/sbin/mysqld: File '/var/lib/mysql/Server_name-slow.log' not found (Errcode: 13)
130608 23:02:02 [ERROR] Could not use /var/lib/mysql/Server_name-slow.log for logging (error 13). Turning logging off for the whole $
130608 23:02:02 [ERROR] Unknown/unsupported table type: InnoDB
130608 23:02:02 [ERROR] Aborting

130608 23:02:02 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:02:02 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:02:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:02:22 [Note] Plugin 'FEDERATED' is disabled.
130608 23:02:22  InnoDB: Initializing buffer pool, size = 300.0M
130608 23:02:22  InnoDB: Completed initialization of buffer pool

130608 23:02:22  InnoDB: Initializing buffer pool, size = 300.0M
130608 23:02:22  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 23:02:22 [ERROR] Plugin 'InnoDB' init function returned error.
130608 23:02:22 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
^G/usr/sbin/mysqld: File '/var/lib/mysql/Server_name-slow.log' not found (Errcode: 13)
130608 23:02:22 [ERROR] Could not use /var/lib/mysql/Server_name-slow.log for logging (error 13). Turning logging off for the whole $
130608 23:02:22 [ERROR] Unknown/unsupported table type: InnoDB
130608 23:02:22 [ERROR] Aborting

130608 23:02:22 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:02:22 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:06:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:06:22 [Note] Plugin 'FEDERATED' is disabled.
130608 23:06:22  InnoDB: Initializing buffer pool, size = 8.0M
130608 23:06:22  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 23:06:22 [ERROR] Plugin 'InnoDB' init function returned error.
130608 23:06:22 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130608 23:06:22 [Note] Event Scheduler: Loaded 0 events
130608 23:06:22 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.68-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130608 23:06:41 [Note] /usr/sbin/mysqld: Normal shutdown

130608 23:06:41 [Note] Event Scheduler: Purging the queue. 0 events
130608 23:06:41 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:06:42 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:06:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:06:43 [Note] Plugin 'FEDERATED' is disabled.
130608 23:06:43  InnoDB: Initializing buffer pool, size = 8.0M
130608 23:06:43  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 23:06:43 [ERROR] Plugin 'InnoDB' init function returned error.
130608 23:06:43 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130608 23:06:43 [Note] Event Scheduler: Loaded 0 events
130608 23:06:43 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.68-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130608 23:07:14 [Note] /usr/sbin/mysqld: Normal shutdown

130608 23:07:14 [Note] Event Scheduler: Purging the queue. 0 events
130608 23:07:14 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:07:14 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:07:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:07:15 [Note] Plugin 'FEDERATED' is disabled.
130608 23:07:15  InnoDB: Initializing buffer pool, size = 8.0M
130608 23:07:15  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 23:07:15 [ERROR] Plugin 'InnoDB' init function returned error.
130608 23:07:15 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130608 23:07:15 [Note] Event Scheduler: Loaded 0 events
130608 23:07:15 [Note] /usr/sbin/mysqld: ready for connections.


130608 23:07:15 [Note] Event Scheduler: Loaded 0 events
130608 23:07:15 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.68-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130608 23:07:44 [Note] /usr/sbin/mysqld: Normal shutdown

130608 23:07:44 [Note] Event Scheduler: Purging the queue. 0 events
130608 23:07:44 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:07:44 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:07:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:07:46 [ERROR] /usr/sbin/mysqld: ambiguous option '--plugin-' (plugin_dir, plugin-load)
130608 23:07:46 [ERROR] Aborting

130608 23:07:46 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:08:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:08:59 [Note] Plugin 'FEDERATED' is disabled.
130608 23:08:59  InnoDB: Initializing buffer pool, size = 200.0M
130608 23:08:59  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 23:08:59 [ERROR] Plugin 'InnoDB' init function returned error.
130608 23:08:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130608 23:08:59 [ERROR] /usr/sbin/mysqld: unknown option '--odb_plugin.so;innodb_$'
130608 23:08:59 [ERROR] Aborting

130608 23:08:59 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:08:59 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:09:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:09:22 [Note] Plugin 'FEDERATED' is disabled.
130608 23:09:22  InnoDB: Initializing buffer pool, size = 200.0M
130608 23:09:22  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 23:09:22 [ERROR] Plugin 'InnoDB' init function returned error.
130608 23:09:22 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130608 23:09:22 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_strict_mode=1'
130608 23:09:22 [ERROR] Aborting

130608 23:09:22 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:09:22 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:09:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:09:44 [Note] Plugin 'FEDERATED' is disabled.
130608 23:09:44  InnoDB: Initializing buffer pool, size = 200.0M
130608 23:09:44  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 23:09:44 [ERROR] Plugin 'InnoDB' init function returned error.
130608 23:09:44 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130608 23:09:44 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_strict_mode=1'
130608 23:09:44 [ERROR] Aborting

130608 23:09:44 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:09:44 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:10:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:10:12 [Note] Plugin 'FEDERATED' is disabled.


130608 23:10:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:10:12 [Note] Plugin 'FEDERATED' is disabled.
130608 23:10:12  InnoDB: Initializing buffer pool, size = 200.0M
130608 23:10:12  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 23:10:12 [ERROR] Plugin 'InnoDB' init function returned error.
130608 23:10:12 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
^G/usr/sbin/mysqld: File '/var/lib/mysql/Server_name-slow.log' not found (Errcode: 13)
130608 23:10:12 [ERROR] Could not use /var/lib/mysql/Server_name-slow.log for logging (error 13). Turning logging off for the whole $
130608 23:10:12 [ERROR] Unknown/unsupported table type: InnoDB
130608 23:10:12 [ERROR] Aborting

130608 23:10:12 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:10:12 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:10:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:10:48 [Note] Plugin 'FEDERATED' is disabled.
130608 23:10:48  InnoDB: Initializing buffer pool, size = 8.0M
130608 23:10:48  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 23:10:48 [ERROR] Plugin 'InnoDB' init function returned error.
130608 23:10:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
^G/usr/sbin/mysqld: File '/var/lib/mysql/Server_name-slow.log' not found (Errcode: 13)
130608 23:10:48 [ERROR] Could not use /var/lib/mysql/Server_name-slow.log for logging (error 13). Turning logging off for the whole $
130608 23:10:48 [Note] Event Scheduler: Loaded 0 events
130608 23:10:48 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.68-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130608 23:10:51 [Note] /usr/sbin/mysqld: Normal shutdown

130608 23:10:51 [Note] Event Scheduler: Purging the queue. 0 events
130608 23:10:51 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:10:51 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:10:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:10:52 [Note] Plugin 'FEDERATED' is disabled.
130608 23:10:52  InnoDB: Initializing buffer pool, size = 8.0M
130608 23:10:52  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 23:10:52 [ERROR] Plugin 'InnoDB' init function returned error.
130608 23:10:52 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
^G/usr/sbin/mysqld: File '/var/lib/mysql/Server_name-slow.log' not found (Errcode: 13)
130608 23:10:52 [ERROR] Could not use /var/lib/mysql/Server_name-slow.log for logging (error 13). Turning logging off for the whole $
130608 23:10:52 [Note] Event Scheduler: Loaded 0 events
130608 23:10:52 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.68-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130608 23:11:02 [Note] /usr/sbin/mysqld: Normal shutdown

130608 23:11:02 [Note] Event Scheduler: Purging the queue. 0 events
130608 23:11:02 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:11:02 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:11:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:11:03 [Note] Plugin 'FEDERATED' is disabled.
130608 23:11:03  InnoDB: Initializing buffer pool, size = 8.0M
130608 23:11:03  InnoDB: Completed initialization of buffer pool

130608 23:11:03  InnoDB: Initializing buffer pool, size = 8.0M
130608 23:11:03  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 23:11:03 [ERROR] Plugin 'InnoDB' init function returned error.
130608 23:11:03 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
^G/usr/sbin/mysqld: File '/var/lib/mysql/Server_name-slow.log' not found (Errcode: 13)
130608 23:11:03 [ERROR] Could not use /var/lib/mysql/Server_name-slow.log for logging (error 13). Turning logging off for the whole $
130608 23:11:03 [Note] Event Scheduler: Loaded 0 events
130608 23:11:03 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.68-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130608 23:13:09 [Note] /usr/sbin/mysqld: Normal shutdown

130608 23:13:09 [Note] Event Scheduler: Purging the queue. 0 events
130608 23:13:11 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:13:11 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:13:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:13:12 [Note] Plugin 'FEDERATED' is disabled.
130608 23:13:12 [ERROR] Can't open shared library '/usr/lib/mysql/plugin/innodb_lo$' (errno: 0 cannot open shared object file: No such fil$
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use InnoDB's own implementation
InnoDB: Compressed tables use zlib 1.2.3
130608 23:13:12  InnoDB: Initializing buffer pool, size = 750.0M
130608 23:13:12  InnoDB: Completed initialization of buffer pool
130608 23:13:12  InnoDB: highest supported file format is Barracuda.
130608 23:13:12 InnoDB Plugin 5.1.68 started; log sequence number 19541041164
130608 23:13:12 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_purge_threads=1'
130608 23:13:12 [ERROR] Aborting

130608 23:13:12  InnoDB: Starting shutdown...
130608 23:13:17  InnoDB: Shutdown completed; log sequence number 19541041164
130608 23:13:17 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:13:17 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:16:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:16:05 [Note] Plugin 'FEDERATED' is disabled.
130608 23:16:05 InnoDB: The InnoDB memory heap is disabled
130608 23:16:05 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
130608 23:16:05 InnoDB: Compressed tables use zlib 1.2.3
130608 23:16:05 InnoDB: Using Linux native AIO
130608 23:16:05 InnoDB: Initializing buffer pool, size = 128.0M
130608 23:16:05 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130608 23:16:05 [ERROR] Plugin 'InnoDB' init function returned error.
130608 23:16:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130608 23:16:05 [ERROR] Unknown/unsupported storage engine: InnoDB
130608 23:16:05 [ERROR] Aborting

130608 23:16:05 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:16:05 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:17:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:17:20 [Note] Plugin 'FEDERATED' is disabled.
130608 23:17:20 InnoDB: The InnoDB memory heap is disabled
130608 23:17:20 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
130608 23:17:20 InnoDB: Compressed tables use zlib 1.2.3

130608 23:17:20 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
130608 23:17:20 InnoDB: Compressed tables use zlib 1.2.3
130608 23:17:20 InnoDB: Using Linux native AIO
130608 23:17:20 InnoDB: Initializing buffer pool, size = 750.0M
130608 23:17:21 InnoDB: Completed initialization of buffer pool
130608 23:17:21 InnoDB: highest supported file format is Barracuda.
InnoDB: 127 rollback segment(s) active.
130608 23:17:21  InnoDB: Waiting for the background threads to start
130608 23:17:22 InnoDB: 5.5.30 started; log sequence number 19541041164
130608 23:17:22 [ERROR] /usr/sbin/mysqld: unknown variable 'default_table_type=InnoDB'
130608 23:17:22 [ERROR] Aborting

130608 23:17:22  InnoDB: Starting shutdown...
130608 23:17:23  InnoDB: Shutdown completed; log sequence number 19542746995
130608 23:17:23 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:17:23 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:17:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:17:25 [Warning] ignore-builtin-innodb is deprecated and will be removed in future releases.
130608 23:17:25 [Note] Plugin 'FEDERATED' is disabled.
130608 23:17:25 [ERROR] Can't open shared library '/usr/lib/mysql/plugin/ha_innodb_plugin.so' (errno: 0 /usr/lib/mysql/plugin/ha_innodb_pl$
130608 23:17:25 [ERROR] Couldn't load plugin named 'innodb' with soname 'ha_innodb_plugin.so'.
130608 23:17:25 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_concurrency_tickets=5000'
130608 23:17:25 [ERROR] Aborting

130608 23:17:25 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:17:25 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:25:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:25:54 [Warning] ignore-builtin-innodb is deprecated and will be removed in future releases.
130608 23:25:54 [Note] Plugin 'FEDERATED' is disabled.
130608 23:25:54 [ERROR] Can't open shared library '/usr/lib/mysql/plugin/ha_innodb_plugin.so' (errno: 0 /usr/lib/mysql/plugin/ha_innodb_pl$
130608 23:25:54 [ERROR] Couldn't load plugin named 'innodb' with soname 'ha_innodb_plugin.so'.
130608 23:25:54 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_concurrency_tickets=5000'
130608 23:25:54 [ERROR] Aborting

130608 23:25:54 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:25:54 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:31:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:31:41 [Warning] ignore-builtin-innodb is deprecated and will be removed in future releases.
130608 23:31:41 [Note] Plugin 'FEDERATED' is disabled.
130608 23:31:41 [ERROR] Can't open shared library '/usr/lib/mysql/plugin/ha_innodb_plugin.so' (errno: 0 /usr/lib/mysql/plugin/ha_innodb_pl$
130608 23:31:41 [ERROR] Couldn't load plugin named 'innodb' with soname 'ha_innodb_plugin.so'.
130608 23:31:41 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_concurrency_tickets=5000'
130608 23:31:41 [ERROR] Aborting

130608 23:31:41 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:31:41 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:31:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:31:50 [Warning] ignore-builtin-innodb is deprecated and will be removed in future releases.
130608 23:31:50 [Note] Plugin 'FEDERATED' is disabled.
130608 23:31:50 [ERROR] Can't open shared library '/usr/lib/mysql/plugin/ha_innodb_plugin.so' (errno: 0 /usr/lib/mysql/plugin/ha_innodb_pl$
130608 23:31:50 [ERROR] Couldn't load plugin named 'innodb' with soname 'ha_innodb_plugin.so'.
130608 23:31:50 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_concurrency_tickets=5000'
130608 23:31:50 [ERROR] Aborting


130608 23:31:50 [ERROR] Aborting

130608 23:31:50 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:31:50 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:45:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:45:42 [Warning] ignore-builtin-innodb is deprecated and will be removed in future releases.
130608 23:45:42 [Note] Plugin 'FEDERATED' is disabled.
130608 23:45:42 [ERROR] Can't open shared library '/usr/lib/mysql/plugin/ha_innodb_plugin.so' (errno: 0 /usr/lib/mysql/plugin/ha_innodb_pl$
130608 23:45:42 [ERROR] Couldn't load plugin named 'innodb' with soname 'ha_innodb_plugin.so'.
130608 23:45:42 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_concurrency_tickets=5000'
130608 23:45:42 [ERROR] Aborting

130608 23:45:42 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:45:42 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
130608 23:47:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 23:47:38 [Warning] ignore-builtin-innodb is deprecated and will be removed in future releases.
130608 23:47:38 [Note] Plugin 'FEDERATED' is disabled.
130608 23:47:38 [ERROR] Can't open shared library '/usr/lib/mysql/plugin/ha_innodb_plugin.so' (errno: 0 /usr/lib/mysql/plugin/ha_innodb_pl$
130608 23:47:38 [ERROR] Couldn't load plugin named 'innodb' with soname 'ha_innodb_plugin.so'.
130608 23:47:38 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_concurrency_tickets=5000'
130608 23:47:38 [ERROR] Aborting

130608 23:47:38 [Note] /usr/sbin/mysqld: Shutdown complete

130608 23:47:38 mysqld_safe mysqld from pid file /var/lib/mysql/Server_name.pid ended
 

thinkbot

Well-Known Member
Oct 30, 2012
326
1
16
cPanel Access Level
Root Administrator
you should be upgrading thru WHM
are you doing that thru WHM or rpm ?

remove those lines in my.cnf
#### InnoDB-Plugin SETTINGS NEED REMOVED BEFORE MySQL 5.5 UPGRADE!!!! ###

ignore_builtin_innodb
plugin-load=innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plug$

innodb_strict_mode = 1
#### END InnoDB-Plugin #####
 

thinkbot

Well-Known Member
Oct 30, 2012
326
1
16
cPanel Access Level
Root Administrator
"I have tried copying your earlier my.cnf and sql is not restarting."


Did you remove old log files as I wrote ? (since their size changed in my my.cnf)

- - - Updated - - -

130608 23:31:41 [ERROR] Can't open shared library '/usr/lib/mysql/plugin/ha_innodb_plugin.so' (errno: 0 /usr/lib/mysql/plugin/ha_innodb_pl$
130608 23:31:41 [ERROR] Couldn't load plugin named 'innodb' with soname 'ha_innodb_plugin.so'.
130608 23:31:41 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_concurrency_tickets=5000'


those were 3 errors:

1 and 2 are about your innodb plugin code, so remove it from my.cnf
3 is about value in my my.cnf that not exist in your mysql version, so remove that: innodb_concurrency_tickets
 

Gauravk

Well-Known Member
Jan 23, 2012
69
0
56
cPanel Access Level
Root Administrator
I was doing upgrade thru WHM, in ened it got stuck due to non availability of PID file.

Just now updating the my.cnf and restarted again, got same error below

ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/iservername.pid).
 

thinkbot

Well-Known Member
Oct 30, 2012
326
1
16
cPanel Access Level
Root Administrator
do what I wrote before,
remove:
innodb_concurrency_tickets value from my.cnf

and remove those:
plugin_dir=/usr/lib/mysql/plugin

#### InnoDB-Plugin SETTINGS NEED REMOVED BEFORE MySQL 5.5 UPGRADE!!!! ###

ignore_builtin_innodb
plugin-load=innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plug$

innodb_strict_mode = 1
#### END InnoDB-Plugin #####


try to restart and
show last 100 lines of error log
 

Gauravk

Well-Known Member
Jan 23, 2012
69
0
56
cPanel Access Level
Root Administrator
Hi Thinkbot, thanks for your help and patience. I did exactly what you said.

Please find latest error code. Thanks.



130609 0:33:59 [Note] /usr/sbin/mysqld: Shutdown complete

130609 00:33:59 mysqld_safe mysqld from pid file /var/lib/mysql/server-name.pid ended
130609 00:45:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130609 0:45:34 [Warning] ignore-builtin-innodb is deprecated and will be removed in future releases.
130609 0:45:34 [Note] Plugin 'FEDERATED' is disabled.
130609 0:45:34 [ERROR] Can't open shared library '/usr/lib/mysql/plugin/ha_innodb_plugin.so' (errno: 0 /usr/lib/mysql/plugin/ha_innodb_plugin.so: cannot open shared object $
130609 0:45:34 [ERROR] Couldn't load plugin named 'innodb' with soname 'ha_innodb_plugin.so'.
130609 0:45:34 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_purge_threads=1'
130609 0:45:34 [ERROR] Aborting

130609 0:45:34 [Note] /usr/sbin/mysqld: Shutdown complete

130609 00:45:34 mysqld_safe mysqld from pid file /var/lib/mysql/server-name.pid ended
130609 00:52:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130609 0:52:33 [Warning] ignore-builtin-innodb is deprecated and will be removed in future releases.
130609 0:52:33 [Note] Plugin 'FEDERATED' is disabled.
130609 0:52:33 [ERROR] Can't open shared library '/usr/lib/mysql/plugin/ha_innodb_plugin.so' (errno: 0 /usr/lib/mysql/plugin/ha_innodb_plugin.so: cannot open shared object $
130609 0:52:33 [ERROR] Couldn't load plugin named 'innodb' with soname 'ha_innodb_plugin.so'.
130609 0:52:33 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_purge_threads=1'
130609 0:52:33 [ERROR] Aborting

130609 0:52:33 [Note] /usr/sbin/mysqld: Shutdown complete

130609 00:52:33 mysqld_safe mysqld from pid file /var/lib/mysql/server-name.pid ended
 

Gauravk

Well-Known Member
Jan 23, 2012
69
0
56
cPanel Access Level
Root Administrator
Hi Thinkbot, Finally a good news......!

MySQL started working and everything came back online.

Learning from your experience that you asked me to read the error log and remove few lines from my.cnf. I did more on same line and found couple of entries in initial my.cnf that was making mysql unhappy. So i kept on commenting one by one and finally got the one that worked. Please find working my.cnf below and comment as per your expertise.

Code:
[mysqld]
plugin_dir="/usr/lib/mysql/plugin"
#innodb_purge_threads=1
query_cache_size=30M
#plugin-load="innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_lo$"
#innodb_open_files=2000
sort_buffer_size=256K
open_files_limit=6580
#innodb_flush_log_at_trx_commit=2
slow_query_log=1
tmp_table_size=256M
max_allowed_packet=32M
max_connections=75
query_cache_limit=1M
join_buffer_size=4M
innodb_strict_mode=1
innodb_flush_method=O_DIRECT
thread_cache_size=30
table_open_cache=3000
#ignore_builtin_innodb
innodb_buffer_pool_size=750M
log-queries-not-using-indexes
max_heap_table_size=256M
innodb_log_buffer_size=8M
innodb_log_file_size=50M
thread_stack=192K
innodb_old_blocks_time=1000
#default_table_type=InnoDB
slow_query_log_file=mysql-slow.log
long_query_time=0.1
table_definition_cache=2000
default-storage-engine=MyISAM
innodb_file_per_table=1
 

thinkbot

Well-Known Member
Oct 30, 2012
326
1
16
cPanel Access Level
Root Administrator
Here, all in order, with removed not needed values, and comments:

Code:
[mysqld]

default-storage-engine=MyISAM

max_connections=75

key_buffer_size = 100M
max_allowed_packet=32M

query_cache_size=30M
query_cache_limit=1M
tmp_table_size=50M
max_heap_table_size=50M
thread_cache_size=30

table_open_cache = 1000
table_definition_cache = 500

slow_query_log=1
slow_query_log_file=mysql-slow.log
long_query_time=0.1
log-queries-not-using-indexes

#### Per connection configuration ####
sort_buffer_size=256K
join_buffer_size=4M
read_rnd_buffer_size=4M

##### INNODB Specific Options ######
innodb_buffer_pool_size=750M
innodb_log_file_size = 50M
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=8M
innodb_flush_method=O_DIRECT
innodb_old_blocks_time=1000
innodb_open_files=2000

innodb_file_per_table=1
but I would suggest commenting out
this line innodb_file_per_table=1
#innodb_file_per_table=1

you can keep innodb ibd in 1 file, instead of creating new file for each table
 

Gauravk

Well-Known Member
Jan 23, 2012
69
0
56
cPanel Access Level
Root Administrator
Thanks Thinbkbot, i will implement this new one shortly. Could you please advise on how to create the log file? As i have tried yesterday by first getting percona thru wget and then follow your earlier instruction, but no log file created (slow.something).

Percona is installed and changed permission, MySQL 5.5 update is also done.
 

thinkbot

Well-Known Member
Oct 30, 2012
326
1
16
cPanel Access Level
Root Administrator
Percona MySQL is replacement of Cpanel MySQL server

I see you still got standard MySQL MySQL55-server-5.5.30-4.cp1136.i386, not Percona version
but it's good anyways

pt-query-digest is slow query log formatting tool from Percona company :)

slow query log file is set it my.cnf as mysql-slow.log in main mysql dir

so to generate slow query log review from pt-query-digest

go to pt-query-digest folder and run
./pt-query-digest /var/lib/mysql/mysql-slow.log > slow.txt
and in slow.txt will be the result that you can review and see slow queries
 

Gauravk

Well-Known Member
Jan 23, 2012
69
0
56
cPanel Access Level
Root Administrator
Hi Thinkbot,

I meant for same that i installed percona slow log tool, not MySQL. My MySQL is still standard cPanel one but upgraded to 5.5 now.

I have PM you slow log already. Please find my mysqltuner.pl results before i change the my.cnf. I know its not yet 24hrs, but I feel like sharing to get some additional heads up (if any).

I have changed the innodb to 300 from 700 megs, as i am running at 2 GB VPS and was bit scared to chew 75% of memory (overall). If its really needed i can increase the ram by additional gig or two. Please advise.


Code:
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.30-cll
[OK] Operating on 32-bit architecture with less than 2GB RAM

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 69M (Tables: 146)
[--] Data in InnoDB tables: 248M (Tables: 2709)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 0B (Tables: 2)
[!!] Total fragmented tables: 2731

-------- Security Recommendations  -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 18h 3m 5s (537K q [8.268 qps], 25K conn, TX: 840M, RX: 66M)
[--] Reads / Writes: 66% / 34%
[--] Total buffers: 610.0M global + 4.8M per thread (75 max threads)
[OK] Maximum possible memory usage: 970.9M (47% of installed RAM)
[!!] Slow queries: 7% (38K/537K)
[OK] Highest usage of available connections: 40% (30/75)
[OK] Key buffer size / total MyISAM indexes: 8.0M/16.5M
[OK] Key buffer hit rate: 99.4% (485K cached / 2K reads)
[OK] Query cache efficiency: 59.1% (207K cached / 350K selects)
[!!] Query cache prunes per day: 33129
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 10K sorts)
[!!] Joins performed without indexes: 4280
[OK] Temporary tables created on disk: 16% (7K on disk / 45K total)
[OK] Thread cache hit rate: 99% (30 created / 25K connections)
[!!] Table cache hit rate: 0% (3K open / 629K opened)
[OK] Open file limit used: 5% (348/6K)
[OK] Table locks acquired immediately: 99% (243K immediate / 243K locks)
[OK] InnoDB data size / buffer pool: 248.4M/300.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    MySQL started within last 24 hours - recommendations may be inaccurate
    Adjust your join queries to always utilize indexes
    Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
    query_cache_size (> 30M)
    join_buffer_size (> 4.0M, or always use indexes with joins)
    table_cache (> 3000)