Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. The first step is to verify the oldest data samples within the Datastore.  Use the DataStore Profile script for a MySQL database found on the Support Portal's Tools & Utilities page.
  2. Once you know the oldest data sample, go to the Historical Data Purge Scripts page and download the MySQL trim script you want to run i.e. Ad-hoc, Procedure or Use Archive Settings.

    Warning
    WARNING: All deleted data will be lost.  Ensure that you complete a full data store backup before proceeding with a trim script.
  3.  

    Choose a date for which all data samples collected before this day will be deleted.  It is strongly recommended that deletions are completed in small chunks (e.g. 2 weeks or 1 month at a time) rather than attempting one large delete statement, so if the oldest data in the data store is from July 1, 2014, choose July 15, 2014 as the day to delete from.

  4. You should verify the historical performance data has been deleted by running a performance graph or report in the up.time UI or simply running the Datastore Profile script again.

...