Thanks I have make the rake RAILS_ENV=production db:raw:optimize and in the my.cnf query_cache_size = 20000000
Its really better Vincent On 11 avr, 14:26, Mohamed Lrhazi <lrh...@gmail.com> wrote: > There's some rake tasks, and other things, suggested > here:https://github.com/puppetlabs/puppet-dashboard > > > > > > > > On Mon, Apr 11, 2011 at 5:29 AM, Vincent <vlouvi...@gmail.com> wrote: > > Hello, > > > since the last upgrade to V1.1.0 > > The dashboard is very slow > > > I notice this slow queries in the log : > > > Node Load (14178.9ms) SELECT `nodes`.* FROM `nodes` INNER JOIN > > `reports` ON reports.node_id = nodes.id WHERE ((reports.kind = 'apply' > > AND reports.status != 'failed') AND (`nodes`.`hidden` = 0)) GROUP BY > > nodes.id > > Node Load (13149.9ms) SELECT `nodes`.* FROM `nodes` INNER JOIN > > `reports` ON reports.node_id = nodes.id WHERE ((reports.kind = 'apply' > > AND reports.status = 'failed') AND (`nodes`.`hidden` = 0)) GROUP BY > > nodes.id > > > How can i optimize the DB ? > > > Vincent > > > -- > > 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 > > athttp://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+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
