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.

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

On large systens, Graph creation can become unresponsive due to large number of data sources #4130

Closed
TheWitness opened this issue Feb 17, 2021 · 0 comments
Labels
bug Undesired behaviour performance Performance related affects big sites resolved A fixed issue
Milestone

Comments

@TheWitness
Copy link
Member

Describe the bug

When creating graphs, there is one SQL that is sub-optimal and slows the rate of Graph creation in the current code base.

To Reproduce

Have a large system with many devices and many many data sources and graphs, and attempt to create new ones. The process take much longer then with a newly installed system.

Expected behavior

Cacti should behave well even when there are large numbers of Graphs and Data Sources.

@TheWitness TheWitness added the bug Undesired behaviour label Feb 17, 2021
@TheWitness TheWitness added this to the v1.2.17 milestone Feb 17, 2021
@TheWitness TheWitness added the performance Performance related affects big sites label Feb 17, 2021
TheWitness added a commit that referenced this issue Feb 17, 2021
Sub-optimal queries slow Graph creation
@TheWitness TheWitness added the resolved A fixed issue label Feb 17, 2021
@TheWitness TheWitness changed the title Sub-obtimal queries slow Graph creation Sub-optimal queries slow Graph creation Feb 17, 2021
@netniV netniV changed the title Sub-optimal queries slow Graph creation On large systens, Graph creation can become unresponsive due to large number of data sources Apr 30, 2021
@github-actions github-actions bot locked and limited conversation to collaborators Jul 30, 2021
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Undesired behaviour performance Performance related affects big sites resolved A fixed issue
Projects
None yet
Development

No branches or pull requests

1 participant