If I establish a connection, how long will that connection live without
being used? Is there a parameter somewhere in MySQL that determines this?
Thanks.

R. Vince wrote:
> If I establish a connection, how long will that connection live without
> being used? Is there a parameter somewhere in MySQL that determines this?
> Thanks.
>
>
i don't ever recall seeing or reading anything about a connection live
parameter? i think this might be more dependent upon the client!

--
lark -- hamzee [at] sbcdeglobalspam.net
To reply to me directly, delete "despam".

On May 10, 3:40 pm, lark <ham... [at] sbcdeglobalspam.net> wrote:
> R. Vince wrote:
> > If I establish a connection, how long will that connection live without
> > being used? Is there a parameter somewhere in MySQL that determines this?
> > Thanks.
>
> i don't ever recall seeing or reading anything about a connection live
> parameter? i think this might be more dependent upon the client!
>
> --
> lark -- ham... [at] sbcdeglobalspam.net
> To reply to me directly, delete "despam".

If you type mysqladmin at an appropriate command prompt you'll see
lots of info including your connection timeout together with some
slightly cryptic instructions on how to adjust those settings. My
connection timeout's set at 12 hours (43200 seconds) by default.

"strawberry" <zac.carey [at] gmail.com> wrote in message
news:1178834978.736498.111840 [at] e65g2000hsc.googlegroups.com.. .
> If you type mysqladmin at an appropriate command prompt you'll see
> lots of info including your connection timeout together with some
> slightly cryptic instructions on how to adjust those settings. My
> connection timeout's set at 12 hours (43200 seconds) by default.
>

Yes. But I see it appears 43200 is the max value it can be set to. :(

On May 11, 12:07 pm, "R. Vince" <rvince99 a t hotmail d o t com>
wrote:
> "strawberry" <zac.ca... [at] gmail.com> wrote in message
>
> news:1178834978.736498.111840 [at] e65g2000hsc.googlegroups.com.. .
>
> > If you type mysqladmin at an appropriate command prompt you'll see
> > lots of info including your connection timeout together with some
> > slightly cryptic instructions on how to adjust those settings. My
> > connection timeout's set at 12 hours (43200 seconds) by default.
>
> Yes. But I see it appears 43200 is the max value it can be set to. :(

Yes. Seems like the default is also the max.

strawberry wrote:
> On May 11, 12:07 pm, "R. Vince" <rvince99 a t hotmail d o t com>
> wrote:
>> "strawberry" <zac.ca... [at] gmail.com> wrote in message
>>
>> news:1178834978.736498.111840 [at] e65g2000hsc.googlegroups.com.. .
>>
>>> If you type mysqladmin at an appropriate command prompt you'll see
>>> lots of info including your connection timeout together with some
>>> slightly cryptic instructions on how to adjust those settings. My
>>> connection timeout's set at 12 hours (43200 seconds) by default.
>> Yes. But I see it appears 43200 is the max value it can be set to. :(
>
> Yes. Seems like the default is also the max.
>

yes, yes, i see it now. i'd never had to set that but i guess it can be
set at conf file level (at the server level) or per thread.

--
lark -- hamzee [at] sbcdeglobalspam.net
To reply to me directly, delete "despam".