Maintenance

API Documentation

\GSPPanel\Maintenance

This class is responsible for performing database maintenance

Methods

ArchiveDays() : void

Compacts 1 hour intervals into daily intervals.

Ran on everything over 25 hours(Allows daily graphs to work) and set to archive level 1.
Archive level 2

ArchiveHours() : void

Compacts the 5 minute scan intervals into hourly intervals.

Ran on everything with archive level 0 and older then 2 hours(Allows hourly graph to work).
Archive level 1

ArchiveMonths() : void

Compacts weekly intervals into monthly intervals Ran on everything older then 1 year(Allows yearly graphs to work) and set to archive level 3
Archive level 4

ArchiveWeeks() : void

Compacts daily intervals into weekly intervals Ran on everything over 30 days old(Allows monthly graphs to work) and set to archive level 2
Archive level 3

Optimize() : void

Runs table optimization

Prune() : void

Removed stale data from the database