Re: mysql & idle connections
It could be that the processes are sending keep alive messages or some other
chatter that is constantly resetting the timeout period. I would check it
out my sniffing the connection on one of them to see what traffic if any is
actually being exchanged.
At 07:05 PM 8/3/05 +0200, Marek Podmaka wrote:
>Hello,
>
> I have mysql4.0 server installed (sarge version) with wait_timeout
> and interactive_timeout both set to 28800 seconds and I can still
> see "older" connections in SHOW PROCESSLIST:
>
>4183489 svbsoftsk host:43790 svbsoftsk Sleep 295239 --- ---
>4187860 svbsoftsk host:49169 svbsoftsk Sleep 295118 --- ---
>5178779 svbsoftsk host:55306 svbsoftsk Sleep 190604 --- ---
>5178789 svbsoftsk host:55316 svbsoftsk Sleep 190604 --- ---
>5178847 svbsoftsk host:55368 svbsoftsk Sleep 190690 --- ---
>5178849 svbsoftsk host:55370 svbsoftsk Sleep 190604 --- ---
--
REMEMBER THE WORLD TRADE CENTER ---=< WTC 911 >=--
"...ne cede males"
00000100
Reply to: