diff options
| author | unknown <bell@sanja.is.com.ua> | 2003-05-31 01:41:11 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2003-05-31 01:41:11 +0300 |
| commit | 185f0092bc8b8ee558a2bad15308168623e94b42 (patch) | |
| tree | a6c3d47ac304c63ae1c1a787b2d1d870fa4924ef /mysql-test/t/query_cache.test | |
| parent | 0829e8706dd7d3ebb415865493ea71297d5d8781 (diff) | |
| download | mariadb-git-185f0092bc8b8ee558a2bad15308168623e94b42.tar.gz | |
fixed bug 549 - incorect query cache memory formating on very small query cache sizes
mysql-test/r/query_cache.result:
test of 2 parts of bug 549
mysql-test/t/query_cache.test:
test of 2 parts of bug 549
sql/sql_cache.cc:
fixed query cache size showing
fixed query cache low memory detection
Diffstat (limited to 'mysql-test/t/query_cache.test')
| -rw-r--r-- | mysql-test/t/query_cache.test | 35 |
1 files changed, 26 insertions, 9 deletions
diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test index 33f226f9253..f0f3063c00d 100644 --- a/mysql-test/t/query_cache.test +++ b/mysql-test/t/query_cache.test @@ -343,18 +343,35 @@ show status like "Qcache_queries_in_cache"; # # Test of query cache resizing # +create table t1 (a int); set GLOBAL query_cache_size=1000; show global variables like "query_cache_size"; -set GLOBAL query_cache_size=1100; -set GLOBAL query_cache_size=1200; -set GLOBAL query_cache_size=1300; -set GLOBAL query_cache_size=1400; -set GLOBAL query_cache_size=1500; -set GLOBAL query_cache_size=1600; -set GLOBAL query_cache_size=1700; -set GLOBAL query_cache_size=1800; -set GLOBAL query_cache_size=1900; +select * from t1; +set GLOBAL query_cache_size=1024; +show global variables like "query_cache_size"; +select * from t1; +set GLOBAL query_cache_size=10240; +show global variables like "query_cache_size"; +select * from t1; +set GLOBAL query_cache_size=20480; +show global variables like "query_cache_size"; +select * from t1; +set GLOBAL query_cache_size=40960; +show global variables like "query_cache_size"; +select * from t1; +set GLOBAL query_cache_size=51200; +show global variables like "query_cache_size"; +select * from t1; +set GLOBAL query_cache_size=61440; +show global variables like "query_cache_size"; +select * from t1; +set GLOBAL query_cache_size=81920; show global variables like "query_cache_size"; +select * from t1; +set GLOBAL query_cache_size=102400; +show global variables like "query_cache_size"; +select * from t1; +drop table t1; # # Temporary tables |