Jira (PDB-2428) Allow Setting The Interval for Each of The Garbage Collection Queries Individually

2017-10-03 Thread Owen Rodabaugh (JIRA)
Title: Message Title
 
 
 
 
 
 
 
 
 
 
  
 
 Owen Rodabaugh updated an issue 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 PuppetDB /  PDB-2428 
 
 
 
  Allow Setting The Interval for Each of The Garbage Collection Queries Individually  
 
 
 
 
 
 
 
 
 

Change By:
 
 Owen Rodabaugh 
 
 
 

CS Priority:
 
 Normal 
 
 
 

CS Impact:
 
 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. 
 
 
 

CS Severity:
 
 3 - Serious 
 
 
 

CS Business Value:
 
 4 - $ 
 
 
 

CS Frequency:
 
 3 - 25-50% of Customers 
 
 
 
 
 
 
 
 
 
 
 
 

 
 Add Comment 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 

 This message was sent by Atlassian JIRA (v6.4.14#64029-sha1:ae256fe) 
 
 
 
 
  
 

Jira (PDB-2428) Allow Setting The Interval for Each of The Garbage Collection Queries Individually

2017-03-02 Thread Nick Walker (JIRA)
Title: Message Title
 
 
 
 
 
 
 
 
 
 
  
 
 Nick Walker commented on  PDB-2428 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
  Re: Allow Setting The Interval for Each of The Garbage Collection Queries Individually  
 
 
 
 
 
 
 
 
 
 
I've implemented this myself with my puppetdb_gc module.  
https://github.com/npwalker/puppetdb_gc 
 
 
 
 
 
 
 
 
 
 
 
 

 
 Add Comment 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 

 This message was sent by Atlassian JIRA (v6.4.14#64029-sha1:ae256fe) 
 
 
 
 
  
 
 
 
 
 
 
 
 
   





-- 
You received this message because you are subscribed to the Google Groups "Puppet Bugs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com.
To post to this group, send email to puppet-bugs@googlegroups.com.
Visit this group at https://groups.google.com/group/puppet-bugs.
For more options, visit https://groups.google.com/d/optout.


Jira (PDB-2428) Allow Setting The Interval for Each of The Garbage Collection Queries Individually

2016-02-15 Thread Nick Walker (JIRA)
Title: Message Title
 
 
 
 
 
 
 
 
 
 
  
 
 Nick Walker updated an issue 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 PuppetDB /  PDB-2428 
 
 
 
  Allow Setting The Interval for Each of The Garbage Collection Queries Individually  
 
 
 
 
 
 
 
 
 

Change By:
 
 Nick Walker 
 
 
 

Affects Version/s:
 
 PDB 3.2.2 
 
 
 
 
 
 
 
 
 
 
 
 

 
 Add Comment 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 

 This message was sent by Atlassian JIRA (v6.4.12#64027-sha1:e3691cc) 
 
 
 
 
  
 
 
 
 
 
 
 
 
   





-- 
You received this message because you are subscribed to the Google Groups "Puppet Bugs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com.
To post to this group, send email to puppet-bugs@googlegroups.com.
Visit this group at https://groups.google.com/group/puppet-bugs.
For more options, visit https://groups.google.com/d/optout.


Jira (PDB-2428) Allow Setting The Interval for Each of The Garbage Collection Queries Individually

2016-02-11 Thread Nick Walker (JIRA)
Title: Message Title
 
 
 
 
 
 
 
 
 
 
  
 
 Nick Walker updated an issue 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 PuppetDB /  PDB-2428 
 
 
 
  Allow Setting The Interval for Each of The Garbage Collection Queries Individually  
 
 
 
 
 
 
 
 
 

Change By:
 
 Nick Walker 
 
 
 
 
 
 
 
 
 
 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  the  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.   
 
 
 
 
 
 
 
 
 
 
 
 

 
 Add Comment 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 

 This message was sent by Atlassian JIRA (v6.4.12#64027-sha1:e3691cc) 
 
 
 
 
  
 
 
 
 
 
 
 
 
   





-- 
You received this message because you are subscribed to the Google Groups "Puppet Bugs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com.
To post to this group, send email to puppet-bugs@googlegroups.com.
Visit this group at https://groups.google.com/group/puppet-bugs.
For more options, visit https://groups.google.com/d/optout.


Jira (PDB-2428) Allow Setting The Interval for Each of The Garbage Collection Queries Individually

2016-02-11 Thread Nick Walker (JIRA)
Title: Message Title
 
 
 
 
 
 
 
 
 
 
  
 
 Nick Walker created an issue 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 PuppetDB /  PDB-2428 
 
 
 
  Allow Setting The Interval for Each of The Garbage Collection Queries Individually  
 
 
 
 
 
 
 
 
 

Issue Type:
 
  Improvement 
 
 
 

Assignee:
 

 Unassigned 
 
 
 

Created:
 

 2016/02/11 3:34 PM 
 
 
 

Labels:
 

 tcse 
 
 
 

Priority:
 
  Normal 
 
 
 

Reporter:
 
 Nick Walker 
 
 
 
 
 
 
 
 
 
 
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 the 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.