1.2.18 Tree View search hangs

[pkranz]

I recently upgraded our production instance from 1.2.16 to 1.2.18. Since that upgrade, searches from the tree view cause mysql CPU utilization to spike, and the database to hang.
It looks to be hanging on this query:

Code: Select all

+-------+---------+-----------+---------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| Id    | User    | Host      | db      | Command | Time | State        | Info                                                                                                 |
+-------+---------+-----------+---------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| 5     | cacti   | localhost | cacti   | Sleep   | 249  |              |                                                                                                      |
| 10    | cacti   | localhost | cacti   | Sleep   | 255  |              |                                                                                                      |
| 39    | cacti   | localhost | cacti   | Query   | 261  | Sending data | SELECT gti.parent, gti.graph_tree_id FROM graph_tree_items AS gti LEFT JOIN host AS h ON h.id=gti.ho |