Uploaded image for project: 'PuppetDB'
  1. PuppetDB
  2. PDB-2428

Allow Setting The Interval for Each of The Garbage Collection Queries Individually

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Normal
    • Resolution: Won't Do
    • PDB 3.2.2
    • None
    • PuppetDB
    • PuppetDB
    • Normal
    • 3 - 25-50% of Customers
    • 3 - Serious
    • 4 - $$$$$
    • Hide
      This would be very nice to help large customers improve performance. Right now this is worked around with the npwalker/puppetdb_gc which disables the gc interval and then runs each gc out of chron.

      It's unclear the difference this does, but when we are helping large scale customers a little bit can make a difference.
      Show
      This would be very nice to help large customers improve performance. Right now this is worked around with the npwalker/puppetdb_gc which disables the gc interval and then runs each gc out of chron. It's unclear the difference this does, but when we are helping large scale customers a little bit can make a difference.

    Description

      Currently we have gc-interval which can be tuned up and down, however, it runs a few different queries some of which I want to run more often and some I'd like to run very infrequently.

      I want to run the query to remove reports frequently say every 10 minutes but I don't want all of the other queries to run because in my environment the other queries don't actually delete anything but do take a long time to complete and use up resources.

      I'd like to be able to specify a frequency to run each of the different GC queries so that I can tune the performance of my puppetdb database based on the specifics of my environment.

      If I'm using node-purge-ttl and I add and remove nodes a lot I may wish to have that query run more frequently.

      For other queries that rarely remove any data, I'd like to run them very infrequently maybe once a week or month.

      Attachments

        Issue Links

          is supported by

          Bug - A problem which impairs or prevents the functions of the product. PDB-3695 Package GC spends a lot of time when there's probably very little to clean up

          • Normal - Regular issue, some loss of functionality under specific circumstances.
          • Closed
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. PDB-3173 Add batch limit to admin endpoint node-purge command

          • Normal - Regular issue, some loss of functionality under specific circumstances.
          • Closed

          Activity

            People

              Unassigned Unassigned
              nick.walker Nick Walker
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Zendesk Support