Announcement

Announcement Module
Collapse
No announcement yet.

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

Page Title Module
Move Remove Collapse
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

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

    #1
    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


  • #2
    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

    Comment

    Working...
    X