Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

When creating Graphs, the process may become slower over time as more items exist #5451

Closed
TheWitness opened this issue Aug 12, 2023 · 2 comments
Closed

When creating Graphs, the process may become slower over time as more items exist #5451

TheWitness opened this issue Aug 12, 2023 · 2 comments
Labels
bug Undesired behaviour confirmed Bug is confirm by dev team performance Performance related affects big sites resolved A fixed issue
Milestone
v1.2.25

Comments

@TheWitness
Copy link
Member

Describe the bug

As reported by a user, he found that as more graphs got created, Cacti became progressively slower. I've reviewed the query and found it flawed and missing an important join attribute. Problem is reported here:

http://forums.cacti.net/viewtopic.php?p=291546#p291546

To Reproduce

Steps to reproduce the behavior:

  1. Create many thousands of graphs user add_graphs.php CLI script for Data Query graphs searching for a specific 'data_source_name'

  2. Watch as Cacti get's slower and slower as more are created.

Expected behavior

Cacti should handle these queries very quickly.
@TheWitness TheWitness added bug Undesired behaviour performance Performance related affects big sites confirmed Bug is confirm by dev team labels Aug 12, 2023
@TheWitness TheWitness added this to the v1.2.25 milestone Aug 12, 2023
TheWitness added a commit that referenced this issue Aug 12, 2023
@TheWitness
Fixing #5451 - Slow Graph Creation Over Time
c4ada17 
* Reported on the Forums, Graph creation slows over time
@TheWitness
Copy link
Member Author

Waiting on the user for confirmation.

@TheWitness
Copy link
Member Author

User confirms it's fixed.

@TheWitness TheWitness added the resolved A fixed issue label Aug 12, 2023
TheWitness added a commit that referenced this issue Aug 12, 2023
@TheWitness
Fixing #5451 - Slow Graph Creation Over Time
f5dabf9 
* Reported on the Forums, Graph creation slows over time
@netniV netniV changed the title Reported on the Forums, Graph creation slows over time When creating Graphs, the process may become slower over time as more items exist Sep 3, 2023
@github-actions github-actions bot locked and limited conversation to collaborators Dec 3, 2023
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
bug Undesired behaviour confirmed Bug is confirm by dev team performance Performance related affects big sites resolved A fixed issue
Projects
None yet
Milestone
v1.2.25
Development

No branches or pull requests
1 participant
@TheWitness