MySQL timeout

Terry Judd tsj at unimelb.edu.au
Tue Jul 15 17:59:33 EDT 2008


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. 

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




More information about the use-livecode mailing list