diff options
| author | unknown <bell@sanja.is.com.ua> | 2002-03-15 23:57:31 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2002-03-15 23:57:31 +0200 |
| commit | 0510e98e11666728d21ae29621adbe134454dc71 (patch) | |
| tree | 691610fcbd4313eb2d79af0b91394cb2b9410f21 /mysql-test/t/innodb_cache.test | |
| parent | 75a268a65be94b15b1651b2dab1c969d24238f48 (diff) | |
| download | mariadb-git-0510e98e11666728d21ae29621adbe134454dc71.tar.gz | |
processing trunsactional tables in query cache
mysql-test/r/innodb_cache.result:
new test for query cache with transactions
mysql-test/t/innodb_cache.test:
new test for query cache with transactions
sql/sql_cache.cc:
processing trunsactional tables in query cache & removing strlen
sql/sql_class.cc:
processing trunsactional tables in query cache & added transaction-live memory
sql/sql_class.h:
processing trunsactional tables in query cache & added transaction-live memory
sql/sql_parse.cc:
processing trunsactional tables in query cache & added transaction-live memory
sql/table.h:
removing strlen operation from query cache
Diffstat (limited to 'mysql-test/t/innodb_cache.test')
| -rw-r--r-- | mysql-test/t/innodb_cache.test | 37 |
1 files changed, 36 insertions, 1 deletions
diff --git a/mysql-test/t/innodb_cache.test b/mysql-test/t/innodb_cache.test index 0a162a9debe..065671476a0 100644 --- a/mysql-test/t/innodb_cache.test +++ b/mysql-test/t/innodb_cache.test @@ -3,7 +3,8 @@ # # Without auto_commit. # -drop table if exists t1; +drop table if exists t1, t2, t3; +flush status; set autocommit=0; create table t1 (a int not null) type=innodb; insert into t1 values (1),(2),(3); @@ -12,3 +13,37 @@ show status like "Qcache_queries_in_cache"; drop table t1; commit; set autocommit=1; +begin; +create table t1 (a int not null) type=innodb; +insert into t1 values (1),(2),(3); +select * from t1; +show status like "Qcache_queries_in_cache"; +drop table t1; +commit; +create table t1 (a int not null) type=innodb; +create table t2 (a int not null) type=innodb; +create table t3 (a int not null) type=innodb; +insert into t1 values (1),(2); +insert into t2 values (1),(2); +insert into t3 values (1),(2); +select * from t1; +select * from t2; +select * from t3; +show status like "Qcache_queries_in_cache"; +show status like "Qcache_hits"; +begin; +select * from t1; +select * from t2; +select * from t3; +show status like "Qcache_queries_in_cache"; +show status like "Qcache_hits"; +insert into t1 values (3); +insert into t2 values (3); +insert into t1 values (4); +select * from t1; +select * from t2; +select * from t3; +show status like "Qcache_queries_in_cache"; +show status like "Qcache_hits"; +commit; +show status like "Qcache_queries_in_cache";
\ No newline at end of file |