Time Interval Aggregation is used to manage the size of the bitB Database. bitB will aggregate time intervals by deleting all intervals for a day, week or month depending on the Time Aggregation settings. There are three levels of aggregation keeping one interval for each time.
The following guide provides step-by-step instructions for setting up the purging of BitB Data.
Automated Time Interval Aggregation
bitB runs a nightly task at 12:00 AM to aggregate time intervals.
Aggregate data to one time interval per day for intervals older than X months
All time intervals older than X months are deleted from the database, except for one interval per day. bitB reviews all intervals within each day and, beginning with the first interval, searches for the earliest successful interval with the highest number of successfully polled devices. This interval is then retained in bitB.
Aggregate data to one time interval per week for intervals older than X months
All time intervals older than X months are deleted from the database, except for one interval per week. bitB reviews all intervals within the week and, beginning with the first interval, searches for the earliest successful interval with the highest number of successfully polled devices. This interval is then retained in bitB.
Aggregate data to one time interval per month for intervals older than X months
All time intervals older than X months are deleted from the database, except for one interval per month. bitB reviews all intervals within the month and, beginning with the first interval, searches for the earliest successful interval with the highest number of successfully polled devices. This interval is then retained in bitB.
The aggregation process will run shrink database after deleting the intervals. The shrink process will free up space on the disk with the database.
\uD83D\uDCD8 Instructions to Enable Automated Time Interval Aggregation
Run bitB with the ManageDatabase command line parameter
Copy the path of the bitB.exe and add ManageDatabase
Select Manage Database under Admin
Select Purge Intervals
Select Select Purge Intervals to Delete
202405181939 - updated DLL and bitBService to 5.2405.1801.2
Release mode does not show the purge settings
Manage Database in release mode doesn’t show the manual select intervals in the purge option
testing manual remove - no purge intervals - selected one interval
no event logs for delete or shrink
scroll issue - message should change on open to show day - week - month - should not need to scroll
message column should autosize to values in column
should not require select intervals to delete to see the month-week-day
with 5 6 7 and today is 5/18/24
5 months - day 12/17 - 11/18
6 months - week 11/17 - 10/18
7 months - month 10/17 - 9/18
Note columns are not sorted by default by Begin Time - that should be the default
not a date sort - sorting by single numbers
testing manual delete from purge interval settings
events are here but not in event log
show all has the events but not event log with tech logs enabled
shrink worked - not sure why the DB says 2g free - why wasn’t that returned and the disk space g to 3gb
202405182128
changed settings and will watch overnight to see if autopurge works
202405190005 Looks like shrink DB ran at 00:00 but no delete intervals
with 4 5 6 and today is 5/18/24
4 months - day 1/17 - 12/18
5 months - week 12/17 - 11/18
6 months - month 11/17 - 10/18
actually it looks like it worked - I don’t see any check marks when I select - select intervals to delete
202405190016 changed settings to 3 - 4 - 5
202405190018 changed settings to 2 - 3 - 4
If Enable Automated Time Interval Aggregation
is Disabled, you can run the manual aggregation process using Manage Database - Purge Intervals.
Add Comment