Re^2: DBD::mysql connections

fantastic, only create a connection if it's failed, good call.

But you highlighted something: If you can assume that these database methods run queries often enough

is there then, basically, a time limit to how long an idle connection stays open? and can that time limit be modified?

Cheers
Sam

Comment on Re^2: DBD::mysql connections

Replies are listed 'Best First'.
Re^3: DBD::mysql connections by shemp (Deacon) on Jun 17, 2004 at 16:30 UTC
If you're using MySQL, check out the variables wait_timeout and interactive_timeout query: 'show variables' to see the current values. (they are in seconds). I think my default wait_timeout is 15 minutes.	[reply]
Re^4: DBD::mysql connections by seaver (Pilgrim) on Jun 17, 2004 at 18:11 UTC
well it seems both 'wait_timeout' and 'interactive_timeout' are '28800' seconds, which is 8hours! I think that's enough time :-D S	[reply]