Issue #7068 has been updated by Vincent Louviaux.
When I remove ((reports.kind = ‘apply’ AND reports.status = ‘failed’) part from the query, the query is very quick. The query become slow when add reports.kind or reports.status in the where clause ---------------------------------------- Bug #7068: performance issue https://projects.puppetlabs.com/issues/7068 Author: Vincent Louviaux Status: Unreviewed Priority: Normal Assignee: Category: Target version: 1.1.0 Keywords: performance Branch: Affected URL: Affected Dashboard version: 1.1.0 one query take always many seconds select on tables nodes or reports are very quick, I have notice this trouble only with this join. is an index missing or? Node Load (8157.7ms) 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 -- You have received this notification because you have either subscribed to it, or are involved in it. To change your notification preferences, please click here: http://projects.puppetlabs.com/my/account -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/puppet-bugs?hl=en.
