realbasic-nug
[Top] [All Lists]

Re: timing out mySQL database connections (was: Re: q on mySQL plugin)

To: REALbasic Network Users Group <realbasic-nug at lists dot realsoftware dot com>
Subject: Re: timing out mySQL database connections (was: Re: q on mySQL plugin)
From: Richard Altenburg <realbasic at brainchild dot nl>
Date: Thu, 27 Mar 2003 18:58:43 +0100
On 27-03-2003 08:26, "Dave Slack" <nospam at forestdigital dot com> wrote:

> Thanks for the feedback, it's much appreciated. I'm thinking 14 hours
> might be a bit long :-)  but I might try lengthening the timeout I'm
> using to 15 or 30 minutes and see how things work out. Without more
> specific knowledge of how the RB MySQL plugin works in interaction with
> MySQL DBs or what RB's MySQLDatabase.connect actually does, I'll just

And maybe someone sets the MYSQL_OPT_CONNECT_TIMEOUT to a value of 5
minutes, and then that is your timeout. I do not know if the plug-in sets
this value for the connection it opens, but I do know that if it does, RS
should publish this value. And, I guess you can set this value using SQL,
because it is recognized by MySQL. Or can this only be set at the Internet
provider's side? Anyhow, someone could set it, so you cannot rely on your
own tests with a specific provider I think.


---
A searchable archive of this list is available at:
<http://support.realsoftware.com/listarchives/search.php>

Unsubscribe:
<mailto:realbasic-nug-off at lists dot realsoftware dot com>

Subscribe to the digest: 
<mailto:realbasic-nug-digest at lists dot realsoftware dot com>
.


<Prev in Thread] Current Thread [Next in Thread>