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

Allow for Purging of Data Source Statistics from the GUI #2236

Closed
eschoeller opened this issue Dec 28, 2018 · 4 comments
Closed

Allow for Purging of Data Source Statistics from the GUI #2236

eschoeller opened this issue Dec 28, 2018 · 4 comments
Labels
enhancement General tag for an enhancement performance Performance related affects big sites resolved A fixed issue
Milestone

Comments

@eschoeller
Copy link

The MySQL tables for the data source statistics have grown to 1.3GB on my system. I'm not sure if this is by design, if it's normal, or what. It could likely be due to the errors I'm still getting with dsstats (which I'm going to disable for now).
But, I think it would be a good idea to have a function in place to clear these statistics out of the db so you can start over.

du -hsc data_source_stats_*ibd
401M    data_source_stats_daily.ibd
14M     data_source_stats_hourly.ibd
341M    data_source_stats_hourly_cache.ibd
14M     data_source_stats_hourly_last.ibd
173M    data_source_stats_monthly.ibd
177M    data_source_stats_weekly.ibd
161M    data_source_stats_yearly.ibd
1.3G    total
@eschoeller
Copy link
Author

My settings:
image

@eschoeller
Copy link
Author

Just a bit of poking around ... I found that a data source had 138 rows associated with it when the template itself only has 2 data items associated with it. So there's tons of garbage that's been accumulated into these tables.

@cigamit
Copy link
Member

cigamit commented Dec 28, 2018

Good idea. Marking as a feature request. Data Source Statistics will rebuild things when re-enabled.

@cigamit cigamit added the enhancement General tag for an enhancement label Dec 28, 2018
@cigamit cigamit added this to the Cacti 1.3 milestone Dec 29, 2018
@TheWitness TheWitness added the performance Performance related affects big sites label Mar 17, 2020
@TheWitness TheWitness changed the title Feature Request: Clear Data Source Statistics Allow for Purging of Data Source Statistics from the GUI Mar 22, 2020
TheWitness added a commit that referenced this issue Mar 22, 2020
Allow for Purging of Data Source Statistics from the GUI
@TheWitness TheWitness added the resolved A fixed issue label Mar 22, 2020
@TheWitness
Copy link
Member

This is fixed now.

@TheWitness TheWitness modified the milestones: v1.3.0, 1.2.11 Mar 22, 2020
@github-actions github-actions bot locked and limited conversation to collaborators Jun 30, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
enhancement General tag for an enhancement performance Performance related affects big sites resolved A fixed issue
Projects
None yet
Development

No branches or pull requests

3 participants