Hi I was wondering how people were managing their Foreman database? After three months, the sqlite database is over 500 Mb. I have 130 servers checking in every hour at about 300 Kb an hour. Most of that is in the reports table. Do people purge out "old" reports that report things are "OK"? Thanks John -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
The foreman docs suggest that you run a nightly cron job that purges reports over 7 days old. On Mon, Mar 1, 2010 at 4:01 AM, John Warburton <jwarburton@gmail.com> wrote:> Hi > > I was wondering how people were managing their Foreman database? > > After three months, the sqlite database is over 500 Mb. I have 130 servers > checking in every hour at about 300 Kb an hour. > > Most of that is in the reports table. Do people purge out "old" reports > that report things are "OK"? > > Thanks > > John > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To post to this group, send email to puppet-users@googlegroups.com. > To unsubscribe from this group, send email to > puppet-users+unsubscribe@googlegroups.com<puppet-users%2Bunsubscribe@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/puppet-users?hl=en. >-- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
there is also an option to purge reports which are not interesting (e.g. puppet didnt do anything) see more at http://theforeman.org/wiki/foreman/Puppet_Reports Ohad On Mon, Mar 1, 2010 at 8:25 AM, Brian Gallew <geek@gallew.org> wrote:> The foreman docs suggest that you run a nightly cron job that purges > reports over 7 days old. > > > On Mon, Mar 1, 2010 at 4:01 AM, John Warburton <jwarburton@gmail.com>wrote: > >> Hi >> >> I was wondering how people were managing their Foreman database? >> >> After three months, the sqlite database is over 500 Mb. I have 130 servers >> checking in every hour at about 300 Kb an hour. >> >> Most of that is in the reports table. Do people purge out "old" reports >> that report things are "OK"? >> >> Thanks >> >> John >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Puppet Users" group. >> To post to this group, send email to puppet-users@googlegroups.com. >> To unsubscribe from this group, send email to >> puppet-users+unsubscribe@googlegroups.com<puppet-users%2Bunsubscribe@googlegroups.com> >> . >> For more options, visit this group at >> http://groups.google.com/group/puppet-users?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To post to this group, send email to puppet-users@googlegroups.com. > To unsubscribe from this group, send email to > puppet-users+unsubscribe@googlegroups.com<puppet-users%2Bunsubscribe@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/puppet-users?hl=en. >-- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
Thanks Brian & Ohad I was looking for database words when looking through the documentation - not "reports". Must be more thorough next time Database down by 75% Cheers John On 2 March 2010 00:09, Ohad Levy <ohadlevy@gmail.com> wrote:> there is also an option to purge reports which are not interesting (e.g. > puppet didnt do anything) > > see more at http://theforeman.org/wiki/foreman/Puppet_Reports > > Ohad > > > > On Mon, Mar 1, 2010 at 8:25 AM, Brian Gallew <geek@gallew.org> wrote: > >> The foreman docs suggest that you run a nightly cron job that purges >> reports over 7 days old. >> >> >> On Mon, Mar 1, 2010 at 4:01 AM, John Warburton <jwarburton@gmail.com>wrote: >> >>> Hi >>> >>> I was wondering how people were managing their Foreman database? >>> >>> After three months, the sqlite database is over 500 Mb. I have 130 >>> servers checking in every hour at about 300 Kb an hour. >>> >>> Most of that is in the reports table. Do people purge out "old" reports >>> that report things are "OK"? >>> >>> Thanks >>> >>> John >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "Puppet Users" group. >>> To post to this group, send email to puppet-users@googlegroups.com. >>> To unsubscribe from this group, send email to >>> puppet-users+unsubscribe@googlegroups.com<puppet-users%2Bunsubscribe@googlegroups.com> >>> . >>> For more options, visit this group at >>> http://groups.google.com/group/puppet-users?hl=en. >>> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Puppet Users" group. >> To post to this group, send email to puppet-users@googlegroups.com. >> To unsubscribe from this group, send email to >> puppet-users+unsubscribe@googlegroups.com<puppet-users%2Bunsubscribe@googlegroups.com> >> . >> For more options, visit this group at >> http://groups.google.com/group/puppet-users?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To post to this group, send email to puppet-users@googlegroups.com. > To unsubscribe from this group, send email to > puppet-users+unsubscribe@googlegroups.com<puppet-users%2Bunsubscribe@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/puppet-users?hl=en. >-- John Warburton Ph: 0417 299 600 Email: jwarburton@gmail.com -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.