Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-6771

Query Cache | min_query_duration

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 25.10.4
    • cache
    • None

    Description

      As a user, I want to optimize the memory usage of the maxscale query cache to the most useful long running query results and limit consistency risk of cheap/small queries by being able to define a minimum duration in ms a query needs to run for its result to be stored in the query cache.

      Today, with TTL caching, fast queries share in the consistency risk that the data might have changed with little to no performance benefit and it takes up space in the cache.

      With this feature, the user can define where this breakpoint makes sense for their workload. including whether the cache is local allowing them to use a lower min_query_duration vs if the cache is behind a network hop, requiring a higher min_query_duration.

      Attachments

        Activity

          People

            johan.wikman Johan Wikman
            allen.herrera Allen Herrera
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 1h
                1h

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.