Hi Les, all !
Les Schaffer schrieb:
[[...]]
perhaps i wasn't clear earlier. we checked the logs, and we see that
Innodb is started and accepting connections sometimes 1-6 seconds AFTER
we see the Windows ServiceManager report that the MySQL service is in
state SERVICE_RUNNING.
we had thought that SERVICE_RUNNING meant we could now connect, and 99%
of the time we have no problem making a connection.
I am no Windows expert, so please add a suitable disclaimer:
I assume Windows reports the status as "running" when the process(es)
got started, but that doesn't necessary imply they have passed their own
initialization / startup phase.
I doubt there is any external event (say, a file creation or some such)
that Windows would monitor and check before reporting it as "running".
Especially for InnoDB I think it may need some time to check whether it
was shut down cleanly when running last, or has to do some recovery.
(If recovery should be necessary, this would add to the time until the
system is operational for applications.)
looks like we just have to poll for a connection while the service goes
from RUNNING to accepting connections.
If there is something visible externally, I don't know it - hope our
Windows experts might have a hint.
Regards,
Jörg
--
Joerg Bruehe, MySQL Build Team, [EMAIL PROTECTED]
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
