diff options
author | unknown <thek@adventure.(none)> | 2008-01-07 21:06:18 +0100 |
---|---|---|
committer | unknown <thek@adventure.(none)> | 2008-01-07 21:06:18 +0100 |
commit | 44101143f7668cc753f9f78057f164469b051760 (patch) | |
tree | 43e90ecdb33547c3d30ebba07889eb7b6c7928fe /mysql-test/r/query_cache_debug.result | |
parent | 8a824b6733fcdb69429b4c09d2397d73b4182414 (diff) | |
download | mariadb-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.result | 24 |
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; |