# Innodb crash recovery - how to tell when it has completed?

**URL:** <https://forums.percona.com/t/innodb-crash-recovery-how-to-tell-when-it-has-completed/664>\
**Category:** Other MySQL® Questions\
**Created:** [March 7, 2008, 3:25pm UTC](https://forums.percona.com/t/innodb-crash-recovery-how-to-tell-when-it-has-completed/664 "2008-03-07T15:25:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dachan](https://avatars.discourse-cdn.com/v4/letter/d/3ab097/32.png) [@dachan](https://forums.percona.com/u/dachan)\
**Post date:** [March 7, 2008, 3:25pm UTC](https://forums.percona.com/t/innodb-crash-recovery-how-to-tell-when-it-has-completed/664/1 "2008-03-07T15:25:23Z")

</div>

Typically after MySQL is started, the applications are then  
started. The one situation I’ve run into is when recovery  
is being done, which may take some time - the applications will fail to connect and eventually give up & fail to start.

Is there an option to make mysqld (or mysqld\_safe script) block, that is not return, until recovery is complete?

OR

Is there a way to tell via the mysql client or utilities  
that recovery is in progress?

I’d hate to grep thru the .err file and look for a certain string… There must be a better way!

Thanks

---

<div class="post-metadata">

**Author:** ![carpii](https://avatars.discourse-cdn.com/v4/letter/c/b5ac83/32.png) [@carpii](https://forums.percona.com/u/carpii)\
**Post date:** [March 10, 2008, 7:17pm UTC](https://forums.percona.com/t/innodb-crash-recovery-how-to-tell-when-it-has-completed/664/2 "2008-03-10T19:17:17Z")

</div>

the mysql utility has a --connect\_timeout= option

You could try setting this to a large amount, although typically Id prefer to allow it timeout, and handle the failure by retrying later