MySQL Performance: MySQL => Innodb crash recovery - how to tell when it has completed?

Members

Help

Home

Home » Performance » MySQL » Innodb crash recovery - how to tell when it has completed?

Show: Today's Messages :: Show Polls :: Message Navigator

Innodb crash recovery - how to tell when it has completed? [message #2706]

Fri, 07 March 2008 15:55

dachan
Messages: 1
Registered: March 2008

Junior Member

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

Report message to a moderator

Re: Innodb crash recovery - how to tell when it has completed? [message #2714 is a reply to message #2706 ]

Mon, 10 March 2008 20:47

carpii
Messages: 48
Registered: November 2006

Member

the mysql utility has a --connect_timeout=<seconds> 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

Report message to a moderator

Previous Topic:	Query Routinely Crashing Server
Next Topic:	Maximum number of insertions

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 6 19:57:40 EDT 2009

Total time taken to generate the page: 0.02527 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.