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 <[email protected]> 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 <[email protected]> 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 <[email protected]>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 [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]<puppet-users%[email protected]> >>> . >>> 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 [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<puppet-users%[email protected]> >> . >> 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]<puppet-users%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/puppet-users?hl=en. > -- John Warburton Ph: 0417 299 600 Email: [email protected] -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
