Discussion:
Connection life
(too old to reply)
R. Vince
2007-05-10 12:12:33 UTC
Permalink
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.
lark
2007-05-10 14:40:59 UTC
Permalink
Post by R. Vince
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 -- ***@sbcdeglobalspam.net
To reply to me directly, delete "despam".
strawberry
2007-05-10 22:09:38 UTC
Permalink
Post by lark
Post by R. Vince
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!
--
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.
R. Vince
2007-05-11 11:07:24 UTC
Permalink
Post by strawberry
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. :(
strawberry
2007-05-11 13:07:11 UTC
Permalink
On May 11, 12:07 pm, "R. Vince" <rvince99 a t hotmail d o t com>
Post by R. Vince
Post by strawberry
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.
lark
2007-05-11 18:58:00 UTC
Permalink
Post by strawberry
On May 11, 12:07 pm, "R. Vince" <rvince99 a t hotmail d o t com>
Post by R. Vince
Post by strawberry
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 -- ***@sbcdeglobalspam.net
To reply to me directly, delete "despam".
Loading...