Changeset 29292

Timestamp:

Oct 1, 2010, 9:08:32 AM (16 years ago)

Author:

rhenders

Message:

Added automatic cleanup (and optimize) at midnight every day

File:

• trunk/tools/czarpoll.pl (modified) (1 diff)

trunk/tools/czarpoll.pl

@@ -105 +105 @@
     my $newState = undef;
     my $nsStatus = undef;
+    my $lastDay = strftime('%Y-%m-%d', localtime);
+    my $today = undef;
 
     while (1) {
 
+        # check whether day has changed. if so, cleanup tables from previous day and optimize
+        $today = strftime('%Y-%m-%d', localtime);
+        if ($czarDb->isBefore($lastDay, $today)) {
+        
+                print "* New day - performing cleanup\n";
+                $czarDb->cleanupDateRange($lastDay, $lastDay, "30 MINUTE");
+                $czarDb->optimize();
+                $lastDay = $today;
+        }
+
         # sort out times
-        $begin =  strftime('%Y-%m-%d 06:35',localtime);
+        $begin = strftime('%Y-%m-%d 06:35',localtime);
         $end = $czarDb->getNowTimestamp();