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

Please bypass the Query Cache for the RTM Data Collector Script Server Scripts #10

Open
TheWitness opened this issue Nov 22, 2022 · 0 comments
Open

Please bypass the Query Cache for the RTM Data Collector Script Server Scripts #10

TheWitness opened this issue Nov 22, 2022 · 0 comments
Labels
enhancement New feature or request

Comments

@TheWitness
Copy link

TheWitness commented Nov 22, 2022 •
edited
Loading

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

MySQL/MariaDB has a Query Cache that can speed the user interface if enabled. However, enabling that Query Cache on large systems impose a heavy tax on data collection adding a 30% margin to the time required for the Cacti poller to complete.

Describe the solution you'd like

Add the SQL_NO_CACHE directive to all Script Server script calls. So, basically instead of:

SELECT value FROM blah WHERE blah = 'blahblah';

Do the following:

SELECT SQL_NO_CACHE FROM blah WHERE blah = 'blahblah';

Describe alternatives you've considered

Turning on the Query Cache, which is a non-starter until such time as this is fixed.
@TheWitness TheWitness added the enhancement New feature or request label Nov 22, 2022
sbuser-git added a commit to sbuser-git/ibm-spectrum-lsf-rtm-server that referenced this issue Dec 1, 2022
@sbuser-git
Update ss_grid_jobs.php
b419b4a 
patch that disables the query cache for the Cacti Data Collectors - IBM#10

Signed-off-by: Stephanie Buser <[email protected]>
sbuser-git added a commit to sbuser-git/ibm-spectrum-lsf-rtm-server that referenced this issue Dec 1, 2022
@sbuser-git
Update ss_grid_slot_ut.php
a1681bd 
patch that disables the query cache for the Cacti Data Collectors - IBM#10

Signed-off-by: Stephanie Buser <[email protected]>
sbuser-git added a commit to sbuser-git/ibm-spectrum-lsf-rtm-server that referenced this issue Dec 1, 2022
@sbuser-git
Update ss_grid_effectiveut.php
cd92ca6 
patch that disables the query cache for the Cacti Data Collectors - IBM#10

Signed-off-by: Stephanie Buser <[email protected]>
sbuser-git added a commit to sbuser-git/ibm-spectrum-lsf-rtm-server that referenced this issue Dec 1, 2022
@sbuser-git
Update ss_grid_lssched_bcs.php
5029eb3 
patch that disables the query cache for the Cacti Data Collectors - IBM#10

Signed-off-by: Stephanie Buser <[email protected]>
@sbuser-git sbuser-git mentioned this issue Dec 1, 2022
Merged
ddb4github pushed a commit that referenced this issue Jan 11, 2023
@sbuser-git
Fix for #4, #5, #6, #9 (#8), #10
828667d 
* Update grid_benchmark_jobs.php
  Resolved #4, #5.
* Update grid_functions.php
  Resolved #6.
* Update grid_benchmark_jobs.php
* Update grid_manage_hosts.php
  Issue #9
* Update ss_grid_jobs.php, ss_grid_slot_ut.php, ss_grid_effectiveut.php, ss_grid_lssched_bcs.php
* Update 
  patch that disables the query cache for the Cacti Data Collectors - #10

Signed-off-by: Stephanie Buser <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@TheWitness