Skip to content

GitLab Next

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
GitLab
GitLab
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
    • Locked Files
  • Issues 34,932
    • Issues 34,932
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
    • Iterations
  • Merge Requests 1,251
    • Merge Requests 1,251
  • Requirements
    • Requirements
    • List
  • CI / CD
    • CI / CD
    • Pipelines
    • Jobs
    • Schedules
    • Test Cases
  • Security & Compliance
    • Security & Compliance
    • Dependency List
    • License Compliance
  • Operations
    • Operations
    • Metrics
    • Incidents
    • Environments
  • Packages & Registries
    • Packages & Registries
    • Container Registry
  • Analytics
    • Analytics
    • CI / CD
    • Code Review
    • Insights
    • Issue
    • Repository
    • Value Stream
  • Snippets
    • Snippets
  • Members
    • Members
  • Collapse sidebar
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
  • GitLab.org
  • GitLabGitLab
  • Issues
  • #276188

Closed
Open
Opened Nov 03, 2020 by Nikola Milojevic@nmilojevic1Developer

Enable QueryCache for LoadBalancing

While working on epic: &3873 (closed), I encountered that all GET requests that hit LoadBalancer, are not cached. https://gitlab.slack.com/archives/CMMF8TKR9/p1604072634340600

  • With Load Balancer: Screenshot_at_Oct_26_16-37-18
  • Without Load Balancer: Screenshot_at_Oct_26_15-55-13

We use LB for GET requests unless write happens, otherwise, we use primary. So, we might dynamically switch from LB to direct access, and it looks that when we hit LB, those queries are not CACHED (Caching is disabled)

We can see that for the same end-point, we have: 2 times ~1,256 (1,184 CACHED) executed queries 8 times ~1,256 (0 CACHED) executed queries https://log.gprd.gitlab.net/goto/3202017cc2078fcfab6c0e349d280b7b Screenshot_at_Nov_03_12-37-57

Based on this, it seems that we never enable_query_cache for loadbalancing connections

Edited Nov 03, 2020 by Nikola Milojevic
Assignee
Assign to
13.7
Milestone
13.7 (Past due)
Assign milestone
Time tracking
None
Due date
None
Reference: gitlab-org/gitlab#276188