Ask Your Question
1

How can I remove old reports in Puppet Dashboard?

asked 2013-06-10 11:32:05 -0600

toddcarr01 gravatar image

updated 2013-06-10 11:59:45 -0600

llowder gravatar image

For some reason the rake tasks for pruning old reports from the MySQL database for Puppet Dashboard doesn't seem to be working correctly for me. I'm using the latest git pulled version of Puppet Dashboard from Github with Ruby 1.8.7-p370 on CentOS 5 with about seven nodes. I'm currently using the "rake RAILS_ENV=production reports:prune upto=1 unit=wk" every morning to try and only keep a week's worth of reports yet over time the database grows infinitely to consume all space in /var.

When I run the task it claims it removes ... (more)

edit retag flag offensive close merge delete

Comments

1
ramindk gravatar imageramindk ( 2013-06-10 11:59:06 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
1

answered 2013-06-10 11:58:42 -0600

llowder gravatar image

It is cleaning the reports, but you are not seeing a shrinking of the database due to how InnoDB works.

You can find a guide on how to maintain the Dashboard here and it includes information on how to get the database size down.

To quote the page:

InnoDB is Taking Up Too Much Disk Space

Over time, the innodb database can get quite hefty, especially in larger deployments with many nodes. In some cases it can get large enough to consume all the space in var, which makes bad things happen. When this happens, you can follow the steps ... (more)

edit flag offensive delete link more

Comments

1

No. NEVER delete innodb files manually unless you plan to delete all of /var/lib/mysql . Also this may not clean up data if innodb_file_per_table is(n't) set. Refer ...(more)

ramindk gravatar imageramindk ( 2013-06-10 12:14:19 -0600 )edit

I'll take another look but I actually converted the tables to MyISAM specifically to avoid the InnoDB growth issue, didn't help.

toddcarr01 gravatar imagetoddcarr01 ( 2013-06-10 12:37:12 -0600 )edit

@ramindk: That's a direct quote from the Puppet Labs docs. Perhaps we should notify them? :)

jgoldschrafe gravatar imagejgoldschrafe ( 2013-06-10 13:14:39 -0600 )edit

Which I did link to, both the over all page and the specific section I quoted.

llowder gravatar imagellowder ( 2013-06-10 13:32:50 -0600 )edit

Mea Culpa I'm converting to an upvote after doing some testing. In Mysql 5.0 or worse, deleting the ib* files would require at best a manual fix. Testing ...(more)

ramindk gravatar imageramindk ( 2013-06-10 14:55:38 -0600 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

Stats

Asked: 2013-06-10 11:32:05 -0600

Seen: 2,918 times

Last updated: Jun 10 '13