Re: InnoDB restarts by itself every two hours!
I'm experiencing something similar, except it seems that mysqld is restarting more frequently than 2 hours and when it starts up, InnoDB reports the database was not shutdown properly.
Version: '4.0.22-Max-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Official MySQL RPM
041206 4:15:04 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 3690648150
InnoDB: Doing recovery: scanned up to log sequence number 0 3690650401
041206 4:15:05 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92
93 94 95 96 97 98 99
InnoDB: Apply batch completed
041206 4:15:05 InnoDB: Flushing modified pages from the buffer pool...
041206 4:15:05 InnoDB: Started
/usr/sbin/mysqld-max: ready for connections.
Version: '4.0.22-Max-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Official MySQL RPM
041206 4:41:25 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 3690685922
InnoDB: Doing recovery: scanned up to log sequence number 0 3690686126
041206 4:41:26 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
041206 4:41:26 InnoDB: Flushing modified pages from the buffer pool...
041206 4:41:26 InnoDB: Started
Does this make sense at all? Is this a problem? And if so is there any way I can gather more information about it to debug it? I turned on the general log but didn't come across anything that looked suspicous.
Subject
Written By
Posted
December 01, 2004 12:47PM
December 01, 2004 12:50PM
December 01, 2004 02:26PM
Re: InnoDB restarts by itself every two hours!
December 06, 2004 09:42AM
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.