MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:Kristofer Pettersson Date:October 27 2008 4:41pm
Subject:bzr commit into mysql-6.0 branch (kristofer.pettersson:2743) Bug#38551
View as plain text  
#At file:///export/home/thek/bzr/mysql-6.0-bug38551/

 2743 Kristofer Pettersson	2008-10-27
      Bug#38551 query cache can still consume [very little] cpu time even when it is off.
      
      Adding additional test case.
added:
  mysql-test/r/query_cache_disabled.result
  mysql-test/t/query_cache_disabled-master.opt
  mysql-test/t/query_cache_disabled.test

=== added file 'mysql-test/r/query_cache_disabled.result'
--- a/mysql-test/r/query_cache_disabled.result	1970-01-01 00:00:00 +0000
+++ b/mysql-test/r/query_cache_disabled.result	2008-10-27 16:41:27 +0000
@@ -0,0 +1,30 @@
+SHOW GLOBAL VARIABLES LIKE 'query_cache_type';
+Variable_name	Value
+query_cache_type	OFF
+SET GLOBAL query_cache_type=ON;
+ERROR HY000: Incorrect arguments to SET
+SHOW WARNINGS;
+Level	Code	Message
+Warning	1738	<query_cache_type> option ignored
+Error	1210	Incorrect arguments to SET
+SET GLOBAL query_cache_type=DEMAND;
+ERROR HY000: Incorrect arguments to SET
+SHOW WARNINGS;
+Level	Code	Message
+Warning	1738	<query_cache_type> option ignored
+Error	1210	Incorrect arguments to SET
+SET GLOBAL query_cache_type=OFF;
+ERROR HY000: Incorrect arguments to SET
+SHOW WARNINGS;
+Level	Code	Message
+Warning	1738	<query_cache_type> option ignored
+Error	1210	Incorrect arguments to SET
+SET GLOBAL query_cache_size=1024*1024;
+Warnings:
+Warning	1738	<query_cache_size> option ignored
+SHOW WARNINGS;
+Level	Code	Message
+Warning	1738	<query_cache_size> option ignored
+SHOW GLOBAL VARIABLES LIKE 'query_cache_size';
+Variable_name	Value
+query_cache_size	0

=== added file 'mysql-test/t/query_cache_disabled-master.opt'
--- a/mysql-test/t/query_cache_disabled-master.opt	1970-01-01 00:00:00 +0000
+++ b/mysql-test/t/query_cache_disabled-master.opt	2008-10-27 16:41:27 +0000
@@ -0,0 +1 @@
+--query_cache_type=0

=== added file 'mysql-test/t/query_cache_disabled.test'
--- a/mysql-test/t/query_cache_disabled.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/t/query_cache_disabled.test	2008-10-27 16:41:27 +0000
@@ -0,0 +1,18 @@
+#
+# Bug#38551 query cache can still consume [very little] cpu time even when it is off.
+#
+SHOW GLOBAL VARIABLES LIKE 'query_cache_type';
+--error ER_WRONG_ARGUMENTS
+SET GLOBAL query_cache_type=ON;
+SHOW WARNINGS;
+--error ER_WRONG_ARGUMENTS
+SET GLOBAL query_cache_type=DEMAND;
+SHOW WARNINGS;
+--error ER_WRONG_ARGUMENTS
+SET GLOBAL query_cache_type=OFF;
+SHOW WARNINGS;
+SET GLOBAL query_cache_size=1024*1024;
+SHOW WARNINGS;
+SHOW GLOBAL VARIABLES LIKE 'query_cache_size';
+
+

Thread
bzr commit into mysql-6.0 branch (kristofer.pettersson:2743) Bug#38551Kristofer Pettersson27 Oct