my $dsn = "DBI:mysql:host=%s;database=%s;mysql_auto_reconnect=1;mysql_enable_utf8=1"; my $attr = { RaiseError => 1, AutoCommit => 1, mysql_enable_utf8 => 1, mysql_auto_reconnect => 1 } DBI->connect_cached( $dsn, $user, $pass, $attr)