We’ve got a situation where we have two applications running off a shared database, both of which make use of persistent connections. One of these uses a large number of processes/connections, and recommends a very short wait_timeout value. The other uses only one or two persistent connections, but expects for it to ALWAYS be there. If that connection times out (or the network connection is temporarily lost) the process continues to run, but in a “broken” fashion.
Obviously this is an issue with the second application that should be fixed, but in the in the meantime is there any way any of you can think of to deal with this situation? Ideally I’d like to just set the timeout for the second application’s connection to a much higher value, but short of digging into the source to modify the parameters used to make the connection, I’m not sure how that could be accomplished. As far as I know it’s not possible to set a session system variable for a connection other than the current one, is it?
Any other ideas?