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

Add SQL_NO_CACHE to Spine Queries #293

Closed
TheWitness opened this issue Dec 16, 2022 · 0 comments
Closed

Add SQL_NO_CACHE to Spine Queries #293

TheWitness opened this issue Dec 16, 2022 · 0 comments
Labels
enhancement resolved
Milestone
v1.2.23

Comments

@TheWitness
Copy link
Member

Is your feature request related to a problem? Please describe.

Cacti data collection on large systems can be adversely affected if the MySQL/MariaDB Query Cache is used. Disable it's use in Spine

Describe the solution you'd like

Add SQL_NO_CACHE SQL directive to all Queries in Spine

Additional Context

Enabling the Query Cache can be beneficial for the Cacti UI, but is detrimental to Cacti Data Collection
@TheWitness TheWitness added this to the v1.2.23 milestone Dec 16, 2022
TheWitness added a commit that referenced this issue Dec 16, 2022
@TheWitness
Fixing #292 and #293 - SQL_NO_CACHE & Logging
961dab2 
* Improve Script Server Timeout Logging
* Add SQL_NO_CACHE to Spine Queries
TheWitness added a commit that referenced this issue Dec 16, 2022
@TheWitness
QA on #292 & #293 - Missed minor change
3c18382
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement resolved
Projects
None yet
Milestone
v1.2.23
Development

No branches or pull requests
1 participant
@TheWitness