Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4582

QUERY CACHE - create a new query cache type, query_cache_type=PRUNED

    XMLWordPrintable

Details

    Description

      hi guys... i was testing query_cache_information plugin with production machines, and i'm surprised. there's many queries that expend < 10ms to be executed and return 1 row, that are cached

      could we develop some new query cache tunes/prunes?

      query_cache_prune_min_expend_time = 20ms
      query_cache_prune_min_result_rows = 100
      query_cache_prune_min_read_rows = 10000
      maybe others variables / functions...

      only queries that:
      1) expend more than 20ms (expend time = lock time + query time) OR
      2) return more than 100 rows OR
      3) read more than 100000 rows
      4) with SQL_CACHE
      are cached

      the point is add a new query_cache_type, today we have:
      OFF = turn off qc
      ON = any query without SQL_NO_CACHE
      DEMAND = only query with SQL_CACHE

      PRUNED = only query with SQL_CACHE and not pruned by query_cache_prune* variables

      maybe could be used query_cache_type=ON and by default:
      query_cache_prune_min_expend_time = 0
      query_cache_prune_min_result_rows = 0
      query_cache_prune_min_read_rows = 0

      i think that with this i can better tune app/db without rewriting them

      an black list could be used too... it's nice for high intensive query cache server with apps that can't be changed by users this issue was add to another MDEV-4671

      Attachments

        Activity

          People

            Unassigned Unassigned
            rspadim roberto spadim
            Votes:
            2 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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