Hmm, MySQL DB complains about the syntax of those queries: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ANALYZE SELECT DISTINCT `hosts`.`id` FROM `hosts` LEFT OUTER JOIN `host_status` ' at line 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ANALYZE SELECT COUNT(DISTINCT `hosts`.`id`) FROM `hosts` LEFT OUTER JOIN `host_s' at line 1 BTW, is there something like "foreman-rake db:index" or similar that would rebuild the indexes? This particular DB had issues that Dominic helped me to resolve (see https://groups.google.com/d/msg/foreman-users/qkmfeP2R-ss/vUE3FJHsBQAJ for more details), but I wonder if I need to rebuild the indexes after that fix. Thanks! Konstantin Orekhov -- You received this message because you are subscribed to the Google Groups "Foreman users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/foreman-users. For more options, visit https://groups.google.com/d/optout.
