I have increase the mysql like this but the queries takes still more than 9sec for the first page. any other suggestions for the mysql tuning ?
key_buffer=64M sort_buffer=4M query_cache_size = 20M read_buffer_size=1M Node Load (9090.5ms) 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 (9082.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 On Apr 11, 4:19 pm, Vincent <vlouvi...@gmail.com> wrote: > 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.
