use vars 'QUERY_COUNT'; ... my $res = $dbh->selectrow_hashref("show status"); $QUERY_COUNT += ($res->{'Questions'} - $QUERY_COUNT);