MySQL timeout

[Terry Judd]

On 16/7/08 7:59 AM, "Terry Judd" <tsj at unimelb.edu.au> wrote:

> On 16/7/08 7:50 AM, "Ken Ray" <kray at sonsothunder.com> wrote:
> 
>> On 7/15/08 4:13 PM, "Terry Judd" <tsj at unimelb.edu.au> wrote:
>> 
>>> I have a 'startup' routine that checks to see whether my mySQL database is
>>> online. The problem if that when it isn't it hangs for 75 seconds. Is there
>>> a way to specify a (much) shorter timeout interval?
>> 
>> How are you checking? Are you using the mysqladmin "ping" command? Oh and
>> what platform(s) are you doing this on?
> 
> Hi Ken - Nothing as fancy as that. I'm just using revOpenDatabase to get a
> connection ID. If either I or the database are offline I get the spinning
> pizza (Mac OSX) for a full 75 seconds before it returns a 'Can't connect to
> Mysql' error. 

Hmm, seems like sockettimeoutinterval doesn't work with revDB functions.
There is a web server on the same box as the mySQL server so I guess I can
set the sockettimoutinterval to something small and try to get a url from
that. If it's offline then mySQL will probably be as well.

Terry...
> 
> Terry...
>> 
>> 
>> Ken Ray
>> Sons of Thunder Software, Inc.
>> Email: kray at sonsothunder.com
>> Web Site: http://www.sonsothunder.com/
>> 
>> 
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution

-- 
Dr Terry Judd
Lecturer in Educational Technology (Design)
Biomedical Multimedia Unit
Faculty of Medicine, Dentistry & Health Sciences
The University of Melbourne
Parkville VIC 3052
AUSTRALIA

61-3 8344 0187