[mysql/perl] Connection Timeout?

incidenta5 · 05-14-2008, 11:05 AM

If I keep a single MySQL connection open indefinitely, will it ever time out?

I.e.

Code:

...
$dbh = DBI->connect($dsn, $user, $pass);
while(1)
{
## Several hours with queries every few minutes.
}

$dbh->disconnect;

chrism01 · 05-14-2008, 05:56 PM

If you login to MySQL and do

show variables;

you should see a line like this:

| wait_timeout | 28800

default num of seconds after which a cxn will timeout IF there has been no usage/query on that cxn in that time. Timeout is reset after each usage/query.

incidenta5 · 05-15-2008, 05:08 AM

Thanks, I tweaked my code so that I have a subroutine to open/close the connection around groups of update/insert queries and that's worked out perfectly