Uploaded image for project: 'SimplyE 2.0'
  1. SimplyE 2.0
  2. SIMPLY-3350

Add reaper for out-of-date measurements

XMLWordPrintable

    • Icon: Story Story
    • Resolution: Done
    • Icon: Medium Medium
    • 3.1.1 cm
    • Server - Core
    • None
    • SIMPLY S25 Nov 24 - Dec 8, SIMPLY Sprint 26 Dec 8 - 22, SIMPLY S0 Dec 22 - Jan 5, SIMPLY S1 January 5 - 19

      From Jonathan Green in https://github.com/NYPL-Simplified/server_core/pull/1222:

      On some of the LYRASIS servers the measurements table is taking up 100s of GB of space. After running this reaper and letting the database vacuum complete, these tables are taking up only 100mb.

      The large measurements table is slowing down our instances and putting unnecessary stress on our database server. It seems likely there is other issues that is the root, causing so many measurements to be recorded. These will be addressed separately, but this will clean up old unused measurements.

            JonathanGreen Jonathan Green
            leonardrichardson Leonard Richardson [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: