Hi all, I have a cron that follows http://docs.puppetlabs.com/dashboard/manual/1.2/maintaining.html and cleans our puppet dashboard:
[...] rake RAILS_ENV=production reports:prune upto=1 unit=wk rake RAILS_ENV=production db:raw:optimize [...] but I've found a table which is 22GB and I'm not able to clean its space: 22G -rw-rw---- 1 mysql mysql 22G Aug 11 17:15 resource_statuses.ibd Our DB started to work on March, so I've removed all table entries before July, but the table is still 22GB . mysql> delete from resource_statuses where time < "2011-07-12%"; Query OK, 76040474 rows affected (1 hour 50 min 2.07 sec) So, how may I get some free space from dashboard DB? TIA, Arnau -- 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+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
