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

Polling can appear delayed due to early statistics gathering #5232

Closed
TheWitness opened this issue Feb 8, 2023 · 1 comment
Closed

Polling can appear delayed due to early statistics gathering #5232

TheWitness opened this issue Feb 8, 2023 · 1 comment
Labels
bug Undesired behaviour confirmed Bug is confirm by dev team resolved A fixed issue

Comments

@TheWitness
Copy link
Member

Describe the bug

The Query below on my system is running about 22 seconds. Take out the join, and it runs for 1.

image

Taking 1 second is fine, taking 22 is another thing altogether.

Expected behavior

Better performing Cacti
@TheWitness TheWitness added bug Undesired behaviour confirmed Bug is confirm by dev team labels Feb 8, 2023
@TheWitness TheWitness added resolved A fixed issue porting required Requires porting to develop labels Feb 17, 2023
@netniV netniV changed the title On large systems statistics gathering at the beginning of a poller run lead to excessive polling times Polling can appear delayed due to early statistics gathering Feb 20, 2023
netniV pushed a commit that referenced this issue Feb 20, 2023
@TheWitness
Fixing #5238 - SQL Issues due to non-visible chars (#5240)
f9816fe 
Fixing #5238 - SQL Issues due to non-visible chars
Fixing #5232 Poller Stacking
Fixing #5236 - Edit Graph Template
Fixing #5243 - Export columns missing
@TheWitness TheWitness removed the porting required Requires porting to develop label Feb 20, 2023
@TheWitness
Copy link
Member Author

All ported to 1.3.x now.

@TheWitness TheWitness mentioned this issue Feb 20, 2023
Merged
netniV pushed a commit that referenced this issue Feb 24, 2023
@TheWitness
QA: Add additional security to the unserialize function (#5245)
8c6cd77 
Fixing #5238 - SQL Issues due to non-visible chars
Fixing #5232 Poller Stacking
Fixing #5236 - Edit Graph Template
Fixing #5243 - Export columns missing
Fixing Issue #5239 - Automation SNMP Bulk Size
Fixing #5241 - Polling distribution not working
Fixing #5247 and QA on #5241 - Polling Issues
@github-actions github-actions bot locked and limited conversation to collaborators May 22, 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 resolved A fixed issue
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@TheWitness