connection pool does not support auto-timeout connections/recycle interval

looks like mysql closes out inactive connections after 8 hours. i always appreciate mysql's talent for surprises and arbitrary-ness. anyway, the Pool doenst recycle connections at all, and a user has no way of keeping an SA app going without getting some error messages if no activity for 8 hours. i have some changes to Pool that will make it more robust against various close()/del() combinations but to get a "when was this connection opened" tag calls for a more major overhaul of Pool since its getting a little squirrelly in there.

we also have some synchronicity with ~~#121~~ here...although a recycle_interval setting should make ~~#121~~ a lower priority fix.

Comments (4)