From 496f69b68c05fd79f83178deac6b3fc34f13684f Mon Sep 17 00:00:00 2001 From: root Date: Wed, 4 Apr 2007 23:27:57 +0200 Subject: [PATCH] Reduce the MBD staleness timeout to ten minutes. --- web/mbd-status.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/web/mbd-status.pl b/web/mbd-status.pl index cf97ea1..d8ac74e 100755 --- a/web/mbd-status.pl +++ b/web/mbd-status.pl @@ -25,7 +25,7 @@ print <<"EOF"; EOF -my $q = $dbh->prepare('select description,sum(active_servers) as active_servers from (select distinct on (game,port) * from mbd_log where ts >= now() - interval \'30 minutes\' order by game,port,ts desc ) t1 group by game,description order by sum(active_servers) desc, description;'); +my $q = $dbh->prepare('select description,sum(active_servers) as active_servers from (select distinct on (game,port) * from mbd_log where ts >= now() - interval \'10 minutes\' order by game,port,ts desc ) t1 group by game,description order by sum(active_servers) desc, description;'); $q->execute(); while (my $ref = $q->fetchrow_hashref()) { print <<"EOF"; -- 2.39.2