[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: about mysql_ping() function
From:       Warren Young <warren () etr-usa ! com>
Date:       2008-12-30 3:15:03
Message-ID: 49599237.3040405 () etr-usa ! com
[Download RAW message or body]

raid fifa wrote:
> 
> Is this a bug of mysql_ping() ? or any other advice?

Probably not.  I think you'll find that it *does* time out, just after a 
longer period than you'd prefer.  Timeouts of 30, 60 and 120 seconds are 
common in network code, because it's not possible to reliably determine 
that a link is down until then.

Your OS might have a setting that makes it close all sockets using an 
interface that just lost its physical link to the network.  This is 
often more trouble than it's worth, because the link might come back up 
before any of those sockets need to send data again.  If you need 
immediate notification that the link to the DB is down, though, it might 
be what you want.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]