Alex, at the maximum it has to scan the whole size of its log files. In the 'applying log records to the database' phase it may take a long time because of disk i/o. Thus, it is really not possible to know the remaining time precisely since the amount of disk i/o may vary in different phases of the log scan. But by following the log sequence numbers (they are really bytes) you get some estimate of how long it might take. Is there a lot of disk i/o? I guess it is always advisable to shut down the database first and only after that to reboot the OS. We do not know what quirks may happen at the OS shutdown. If you are in hurry, then simply killing the database server process may be more reliable than leaving it to the operating system. Regards, Heikki http://www.innodb.com >Bonjour, > > I've rebooted my server with "sync;sync;reboot". It seems that > Mysql/InnoDB did not have enough time for shutting down properly > because when the server restarted I had these messages in the error > log of Mysql : > >InnoDB: Doing recovery: scanned up to log sequence number 52 663991808 >InnoDB: Doing recovery: scanned up to log sequence number 52 664057344 >InnoDB: Doing recovery: scanned up to log sequence number 52 664122880 >InnoDB: Doing recovery: scanned up to log sequence number 52 664188416 >InnoDB: Doing recovery: scanned up to log sequence number 52 664253952 >InnoDB: Doing recovery: scanned up to log sequence number 52 664319488 >InnoDB: Doing recovery: scanned up to log sequence number 52 664385024 >InnoDB: Doing recovery: scanned up to log sequence number 52 664450560 >InnoDB: Doing recovery: scanned up to log sequence number 52 664516096 >InnoDB: Doing recovery: scanned up to log sequence number 52 664581632 >InnoDB: Doing recovery: scanned up to log sequence number 52 664647168 >InnoDB: Doing recovery: scanned up to log sequence number 52 664712704 >InnoDB: Doing recovery: scanned up to log sequence number 52 664778240 > > This is very long, and it would be great to know at what % of the > recovery job we are. Is it possible ? > > Regards, > Alex. > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
