summaryrefslogtreecommitdiff
path: root/mysql-test/r/query_cache_debug.result
diff options
context:
space:
mode:
authorunknown <thek@adventure.(none)>2008-01-07 21:06:18 +0100
committerunknown <thek@adventure.(none)>2008-01-07 21:06:18 +0100
commit44101143f7668cc753f9f78057f164469b051760 (patch)
tree43e90ecdb33547c3d30ebba07889eb7b6c7928fe /mysql-test/r/query_cache_debug.result
parent8a824b6733fcdb69429b4c09d2397d73b4182414 (diff)
downloadmariadb-git-44101143f7668cc753f9f78057f164469b051760.tar.gz
Fixed test layout error.
mysql-test/r/query_cache.result: Moved test which requires debug binaries to a new file. mysql-test/t/query_cache.test: Moved test which requires debug binaries to a new file. mysql-test/r/query_cache_debug.result: Moved test which requires debug binaries to a new file. mysql-test/t/query_cache_debug.test: Moved test which requires debug binaries to a new file.
Diffstat (limited to 'mysql-test/r/query_cache_debug.result')
-rw-r--r--mysql-test/r/query_cache_debug.result24
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/query_cache_debug.result b/mysql-test/r/query_cache_debug.result
new file mode 100644
index 00000000000..4a4948c9845
--- /dev/null
+++ b/mysql-test/r/query_cache_debug.result
@@ -0,0 +1,24 @@
+flush status;
+set query_cache_type=DEMAND;
+set global query_cache_size= 1024*1024*512;
+drop table if exists t1;
+create table t1 (a varchar(100));
+insert into t1 values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'),('bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb');
+Activate debug hook and attempt to retrieve the statement from the cache.
+set session debug='+d,wait_in_query_cache_insert';
+select SQL_CACHE * from t1;;
+On a second connection; clear the query cache.
+show status like 'Qcache_queries_in_cache';
+Variable_name Value
+Qcache_queries_in_cache 1
+set global query_cache_size= 0;;
+Signal the debug hook to release the lock.
+select id from information_schema.processlist where state='wait_in_query_cache_insert' into @thread_id;
+kill query @thread_id;
+Show query cache status.
+show status like 'Qcache_queries_in_cache';
+Variable_name Value
+Qcache_queries_in_cache 1
+set global query_cache_size= 0;
+use test;
+drop table t1;