Connection life

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.

Re: Connection life

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@sbcdeglobalspam.net
To reply to me directly, delete "despam".

Re: Connection life

On May 10, 3:40 pm, lark 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...@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.

Re: Connection life

"strawberry" wrote in message
news:1178834978.736498.111840@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. :(

Re: Connection life

On May 11, 12:07 pm, "R. Vince"
wrote:
> "strawberry" wrote in message
>
> news:1178834978.736498.111840@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.

Re: Connection life

strawberry wrote:
> On May 11, 12:07 pm, "R. Vince"
> wrote:
>> "strawberry" wrote in message
>>
>> news:1178834978.736498.111840@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@sbcdeglobalspam.net
To reply to me directly, delete "despam".