Uploaded image for project: 'Automation Analytics'
  1. Automation Analytics
  2. AA-1475

Copy 31 days of events and host_events_rollup to new tables

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Done
    • Icon: Critical Critical
    • None
    • None
    • data-pruning, migrations
    • None
    • False
    • Hide

      None

      Show
      None
    • False
    • Sprint ending Dec 28, 2022

      Standard data pruning doesn't release disk space. 

      For biggest tables - job_events_fk, host_event_explorer_rollups  we need to rename table, create duplicate with original name and copy 31 days from old to new.  

      Then drop old table. This should release disk space in db.

              mslemr Martin Šlemr (Inactive)
              mslemr Martin Šlemr (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: