Thanks for the response, but I think you've misunderstood the first bit. > Rails logs are not rotated by default. The rails world would use a > capistrano task: > > http://blog.daeltar.org/logrotate-with-capistrano-generated-configura > > This is creating a logrotate file - which can be done with puppet too. > It's not a log file that is causing the problem, it's the sheer size of the database reports table. I have already put logrotate files in place for the rails log files, and they're fine.
> > Might there be any indexes missing from my database? I think I > > installed > > the dashboard at version 1.0, but ran the database upgrade script > > between 1.0.1 and 1.0.3. > > Rack::Bug is a tool you can use to get an idea about missing indexes: > > http://github.com/brynary/rack-bug That's an interesting technique, but I'd rather not get into modifying the application itself to put diagnostics in-line, especially as it's in production. For reference, the indexes that I have on the reports table are these: mysql> show indexes in reports; +---------+------------+--------------------------+-------------- +-------------+-----------+-------------+----------+--------+------ +------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +---------+------------+--------------------------+-------------- +-------------+-----------+-------------+----------+--------+------ +------------+---------+ | reports | 0 | PRIMARY | 1 | id | A | 380511 | NULL | NULL | | BTREE | | | reports | 1 | index_reports_on_node_id | 1 | node_id | A | 229 | NULL | NULL | YES | BTREE | | | reports | 1 | index_reports_on_time | 1 | time | A | 380511 | NULL | NULL | YES | BTREE | | +---------+------------+--------------------------+-------------- +-------------+-----------+-------------+----------+--------+------ +------------+---------+ 3 rows in set (0.06 sec) I've got mysql logging queries that can't use an index, so I'll analyse that to see if anything jumps out at me. This table currently has 800MB of data and uses 14MB for the indexes. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-us...@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.
