MySQL Forums
Forum List  »  General

MySQL issues ...or not?
Posted by: Greg Perrine
Date: April 01, 2015 07:53AM

My server hung two times in the last week and was rebooted. I see the following entries in the MySQL log. Much is from the reboot .... I believe some action is needed on my part to clear up some of these issues but I'm not sure what to do, or how to do it.

Please look over the log snippit below and advise what action is needed. Note: I am running VB forums on this server and the VB software is the prime user of MySQL

Thu Mar 26 00:01:02 EDT 2015
150326 18:12:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150326 18:12:17 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150326 18:12:17 InnoDB: Initializing buffer pool, size = 8.0M
150326 18:12:17 InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
150326 18:12:17 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...
150326 18:12:18 InnoDB: Started; log sequence number 0 5624774
150326 18:12:18 [Note] Event Scheduler: Loaded 0 events
150326 18:12:18 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.56' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
Fri Mar 27 00:01:01 EDT 2015
Sat Mar 28 00:01:01 EDT 2015
Sun Mar 29 00:01:01 EDT 2015
150329 17:53:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150329 17:53:13 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150329 17:53:13 InnoDB: Initializing buffer pool, size = 8.0M
150329 17:53:13 InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
150329 17:53:13 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...
150329 17:53:15 InnoDB: Started; log sequence number 0 5624784
150329 17:53:16 [Note] Event Scheduler: Loaded 0 events
150329 17:53:16 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.56' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
150329 19:18:59 [Note] /usr/libexec/mysqld: Normal shutdown

150329 19:18:59 [Note] Event Scheduler: Purging the queue. 0 events
150329 19:18:59 InnoDB: Starting shutdown...
150329 19:19:02 InnoDB: Shutdown completed; log sequence number 0 5624784
150329 19:19:02 [Note] /usr/libexec/mysqld: Shutdown complete

150329 19:19:02 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150329 19:19:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150329 19:19:40 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150329 19:19:40 InnoDB: Initializing buffer pool, size = 8.0M
150329 19:19:40 InnoDB: Completed initialization of buffer pool
150329 19:19:40 InnoDB: Started; log sequence number 0 5624784
150329 19:19:40 [Note] Event Scheduler: Loaded 0 events
150329 19:19:40 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.56' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
Mon Mar 30 00:01:02 EDT 2015
Tue Mar 31 00:01:01 EDT 2015
Wed Apr 1 00:01:01 EDT 2015

Options: ReplyQuote


Subject
Written By
Posted
MySQL issues ...or not?
April 01, 2015 07:53AM
April 03, 2015 05:26AM
April 09, 2015 02:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.