What indexes do you have on the respective tables? On Tue, Apr 12, 2011 at 5:25 AM, Vincent <vlouvi...@gmail.com> wrote:
> 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. > > -- 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.
