List:General Discussion« Previous MessageNext Message » Date:July 12 2012 9:35am
Subject:crash recovery
View as plain text  

Lately I got this messgae in my errorLog file, need more datails why the DB
was restarted!

120711 19:42:06  mysqld restarted
120711 19:42:06 [Warning] Asked for 196608 thread stack, but got 126976
120711 19:42:07  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...
120711 19:42:07  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 4 4031987031.
InnoDB: Doing recovery: scanned up to log sequence number 4 4031987031
InnoDB: Last MySQL binlog file position 0 78062804, file name
120711 19:42:07  InnoDB: Flushing modified pages from the buffer pool...
120711 19:42:07  InnoDB: Started; log sequence number 4 4031987031
/usr/sbin/mysqld: ready for connections.
Version: '4.1.14-standard-log'  socket: '/var/lib/mysql/mysql.sock'  port:
3306  MySQL Community Edition - Standard (GPL)


crash recoverymadunix@gmail.com12 Jul