Hi Mark, At 02:04 3-6-2002, Mark shared with all of us:
> > Yes and no. I do want that, but afterwards I want to connect. > > >It still does not look to me like you really want to ping the server. What >you seem to want is to check whether the server is alive; and if not, >reconnect; right? Connect - I want to switch servers then. If a server dies during page execution, that's just tough luck or I have hit a bug in mysqld. >sub connect_mysql { > $dbh = DBI -> connect ( ... ); >} Yes - problem there is: when the machine mysqld is running on, is disconnected from the network - like when it's died or somebody messed with a cable, that will timeout - with max_execution_time set to 900secs, you don't want that. The same applies to the `mysqladmin ping' utility by the way - it runs forever, so that's why I can't modify the mysql-php extension to make use of this timeout feature in the mysql C API. So - I use a low-level socket function, which has a hard timeout and set that to 10 secs. The drawback is that I have to set max_connect_errors to a very high value and pray we never get there or run a flush hosts via a crontab every now and then. So - indeed - I'm probably barking up the wrong tree, by looking at mysql_ping(), but I basically want to mimmick the behavior, so the there's no connection error for the webserver involved. See it as Net::SMTP, using a simple HELO - RSET - QUIT. Best regards, Melvyn Sopacua WebMaster IDG.nl _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ If it applies, where it applies - this email is a personal contribution and does not reflect the views of my employer IDG.nl. \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php