[MCOL-978] Disable Query Cache for ColumnStore Created: 2017-10-17  Updated: 2018-05-11  Resolved: 2018-05-11

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: 1.2.0

Type: New Feature Priority: Major
Reporter: Andrew Hutchings (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Epic Link: MariaDB ColumnStore Generic Engine phase 1
Sprint: 2017-25, 2018-01, 2018-02, 2018-03, 2018-04, 2018-05, 2018-06, 2018-07, 2018-08, 2018-09, 2018-10

 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.

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2017-12-12 ]

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.

Comment by Daniel Lee (Inactive) [ 2018-05-11 ]

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

Generated at Thu Feb 08 02:25:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.