Re: MYSQL timeout

2010-10-01 Thread stephen barncard
google mail seems to keep the threads straignt. Better than any other mailer I've used. On 1 October 2010 17:19, Terry Judd wrote: > That's what I did, so it makes sense. > > Terry... > > On 02/10/2010, at 4:56 AM, "Bob Sneidar" wrote: > > > Aye. Methinks that when someone replies to an email f

Re: MYSQL timeout

2010-10-01 Thread Terry Judd
That's what I did, so it makes sense. Terry... On 02/10/2010, at 4:56 AM, "Bob Sneidar" wrote: > Aye. Methinks that when someone replies to an email from the list, there is > some kind of identifier in the email that tells a mailer it belongs to a > particular thread. So if someone replies to

Re: MYSQL timeout

2010-10-01 Thread Bob Sneidar
Aye. Methinks that when someone replies to an email from the list, there is some kind of identifier in the email that tells a mailer it belongs to a particular thread. So if someone replies to one thread, but substitutes the subject with an entirely new subject, some mailers might just think the

Re: MYSQL timeout

2010-10-01 Thread stephen barncard
perhaps only in your mailer. On 1 October 2010 11:28, Bob Sneidar wrote: > No offense, but how in the HECK did this get stuck in the middle of the > "IPad's competitor from RIM" thread? > > Bob > > > On Sep 28, 2010, at 6:20 PM, Terry Judd wrote: > > > The problem of lengthy timeouts when trying

Re: MYSQL timeout

2010-10-01 Thread Bob Sneidar
No offense, but how in the HECK did this get stuck in the middle of the "IPad's competitor from RIM" thread? Bob On Sep 28, 2010, at 6:20 PM, Terry Judd wrote: > The problem of lengthy timeouts when trying to connect to a MSQL server that > is down/offline is bugging me again. It seems like th

Re: MYSQL timeout

2010-09-29 Thread Terry Judd
Thanks Malte - that seems like a good solution. My issues have mainly been with the server itself rather than with MySQL. Terry... On 30/09/2010, at 7:12 AM, "Malte Pfaff-Brill" wrote: > Hi Terry, > > had the same problem. I settled to ping the IP first before trying to connect > to the DB:

Re: MYSQL timeout

2010-09-29 Thread Malte Pfaff-Brill
Hi Terry, had the same problem. I settled to ping the IP first before trying to connect to the DB: switch case "mac" is in the platform get shell("ping -q -o -c3 -t3"&&tIP) if the result is not empty then put the result into tError en

Re: MYSQL timeout

2010-09-29 Thread Terry Judd
Yep - tried on LiveCode - no joy there so far. Cheers, Terry... On 30/09/2010, at 3:54 AM, "Devin Asay" wrote: > > On Sep 28, 2010, at 7:20 PM, Terry Judd wrote: > >> The problem of lengthy timeouts when trying to connect to a MSQL server that >> is down/offline is bugging me again. It seems

Re: MYSQL timeout

2010-09-29 Thread Devin Asay
On Sep 28, 2010, at 7:20 PM, Terry Judd wrote: > The problem of lengthy timeouts when trying to connect to a MSQL server that > is down/offline is bugging me again. It seems like the default timeout is 60 > seconds which is way too long to wait for a response but there's no obvious > way to overr

MYSQL timeout

2010-09-28 Thread Terry Judd
The problem of lengthy timeouts when trying to connect to a MSQL server that is down/offline is bugging me again. It seems like the default timeout is 60 seconds which is way too long to wait for a response but there's no obvious way to override it. The socketTimeoutInterval has no effect and while

Re: MySQL timeout

2008-07-16 Thread Terry Judd
On 16/7/08 11:56 PM, "Malte Brill" <[EMAIL PROTECTED]> wrote: > Hi Terry, > > I experienced the same. The problem was only the case, if the machine > running the mySQL server is not found on the Network though. If the > machine is there, but the server is down it times out immediately, so > I wen

Re: MySQL timeout

2008-07-16 Thread Malte Brill
Hi Terry, I experienced the same. The problem was only the case, if the machine running the mySQL server is not found on the Network though. If the machine is there, but the server is down it times out immediately, so I went for pinging the server first using shell and if that was success

Re: MySQL timeout

2008-07-15 Thread Terry Judd
On 16/7/08 9:51 AM, "Ken Ray" <[EMAIL PROTECTED]> wrote: > >> 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 >> M

Re: MySQL timeout

2008-07-15 Thread Ken Ray
> 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. There's an environment variable called "$MYSQL_CL

Re: MySQL timeout

2008-07-15 Thread Terry Judd
On 16/7/08 7:59 AM, "Terry Judd" <[EMAIL PROTECTED]> wrote: > On 16/7/08 7:50 AM, "Ken Ray" <[EMAIL PROTECTED]> wrote: > >> On 7/15/08 4:13 PM, "Terry Judd" <[EMAIL PROTECTED]> wrote: >> >>> I have a 'startup' routine that checks to see whether my mySQL database is >>> online. The problem if tha

Re: MySQL timeout

2008-07-15 Thread Terry Judd
On 16/7/08 7:50 AM, "Ken Ray" <[EMAIL PROTECTED]> wrote: > On 7/15/08 4:13 PM, "Terry Judd" <[EMAIL PROTECTED]> 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

Re: MySQL timeout

2008-07-15 Thread Ken Ray
On 7/15/08 4:13 PM, "Terry Judd" <[EMAIL PROTECTED]> 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

MySQL timeout

2008-07-15 Thread Terry Judd
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? Terry... ___ use-revolution mailing list use-revol

MySQL Timeout

2007-08-15 Thread Bridger Maxwell
Hey, Is there a way to set a maximum time for a MySQL query to execute before it times out? As it is right now, if the MySQL server is having problems or something then my application will hang indefinitely waiting for a response. Is there a way to set a timeout? Thank You, Bridger Maxwe