Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-978

Disable Query Cache for ColumnStore

Details

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

    Description

      This is a minor change to our storage engine plugin to state that query cache for ColumnStore is not possible (since writes can happen from other MariaDB servers):

      handler::table_cache_type()
      		 
      return HA_CACHE_TBL_NOCACHE;

      Also undo any modifications to server that do the same thing.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          LinuxJedi Andrew Hutchings (Inactive) added a comment -

          For QA:

          set global query_cache_type=on;
          		 
          set query_cache_type=on;
          		 
          set global query_cache_size=1024*1024;
          		 
          set infinidb_vtable_mode=0;

          Execute a query against a ColumnStore table.

          show status like 'Qcache_queries_in_cache';

          Before the patch this will equal 1. After the patch it will equal 0.

          LinuxJedi Andrew Hutchings (Inactive) added a comment - For QA: set global query_cache_type= on ; set query_cache_type= on ; set global query_cache_size=1024*1024; set infinidb_vtable_mode=0; Execute a query against a ColumnStore table. show status like 'Qcache_queries_in_cache' ; Before the patch this will equal 1. After the patch it will equal 0.
          dleeyh Daniel Lee (Inactive) added a comment -

          Build verified: 1.2.0 source

          /root/columnstore/mariadb-columnstore-server
          commit 4334641df0df040e0f53332c11dc8e29dc34b8b7
          Merge: 960853c cd5e845
          Author: David.Hall <david.hall@mariadb.com>
          Date: Mon Apr 9 13:23:44 2018 -0500

          Merge pull request #107 from mariadb-corporation/dev-merge-up-20180409

          Dev merge up 20180409

          /root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
          commit d8d386b960cbfa77d3077fc84f31e076f867efaa
          Merge: 24b8c79 305bae1
          Author: David.Hall <david.hall@mariadb.com>
          Date: Wed May 9 15:13:47 2018 -0500

          Merge pull request #468 from mariadb-corporation/MCOL-1402

          MCOL-1402 Fix addtime/subtime

          dleeyh Daniel Lee (Inactive) added a comment - Build verified: 1.2.0 source /root/columnstore/mariadb-columnstore-server commit 4334641df0df040e0f53332c11dc8e29dc34b8b7 Merge: 960853c cd5e845 Author: David.Hall <david.hall@mariadb.com> Date: Mon Apr 9 13:23:44 2018 -0500 Merge pull request #107 from mariadb-corporation/dev-merge-up-20180409 Dev merge up 20180409 /root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine commit d8d386b960cbfa77d3077fc84f31e076f867efaa Merge: 24b8c79 305bae1 Author: David.Hall <david.hall@mariadb.com> Date: Wed May 9 15:13:47 2018 -0500 Merge pull request #468 from mariadb-corporation/ MCOL-1402 MCOL-1402 Fix addtime/subtime

          People

            dleeyh Daniel Lee (Inactive)
            LinuxJedi Andrew Hutchings (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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