While trying to use the web search field (tree view) on one of our smaller cacti installations, we get consistent timeouts.
This is an installation with ~6k devices and ~52k graphs.
So far, we've traced the issue back to the SQL query beginning on line 54 in graph_view.php. Executing this query manually through mysql demonstrates that it would take ages to complete (didn't wait for completion).
audit_database.php doesn't show any complaints.
To Reproduce
Steps to reproduce the behavior:
- Go to tree view on a sizeable installation
- Hit 'Search' with a trivial string
Additional context
- Cacti: 1.2.21
- OS: RHEL7
- DB: MariaDB 5.5
While trying to use the web search field (tree view) on one of our smaller cacti installations, we get consistent timeouts.
This is an installation with ~6k devices and ~52k graphs.
So far, we've traced the issue back to the SQL query beginning on line 54 in graph_view.php. Executing this query manually through mysql demonstrates that it would take ages to complete (didn't wait for completion).
audit_database.phpdoesn't show any complaints.To Reproduce
Steps to reproduce the behavior:
Additional context