Percona Server moved to https://jira.percona.com/projects/PS

  1. Series 5.6
  2. Bug #1021131
  3. Comment #4

Comment 4 for bug 1021131

Revision history for this message
Oleksandr "Sanja" Byelkin (sanja-byelkin) wrote :

Here is part ofthe patch in mysql-test/t/query_cache.test:

--echo New query cache switching OFF mechanism test
set global query_cache_size=1024*1024*20;
set global query_cache_type=on;
select @@query_cache_size, @@global.query_cache_type, @@local.query_cache_type;
set global query_cache_size=0;
select @@query_cache_size, @@global.query_cache_type, @@local.query_cache_type;
set global query_cache_size=1024*1024*20;
select @@query_cache_size, @@global.query_cache_type, @@local.query_cache_type;
set global query_cache_type=off;
select @@query_cache_size, @@global.query_cache_type, @@local.query_cache_type;
set global query_cache_type=on;
select @@query_cache_size, @@global.query_cache_type, @@local.query_cache_type;
set local query_cache_type= on;
select @@query_cache_size, @@global.query_cache_type, @@local.query_cache_type;