diff options
| author | unknown <sanja@askmonty.org> | 2013-10-16 16:07:25 +0300 |
|---|---|---|
| committer | unknown <sanja@askmonty.org> | 2013-10-16 16:07:25 +0300 |
| commit | 73f8b4dac263964482b532199151c87596f191b7 (patch) | |
| tree | 509fca20a93a577d6bae7fc4ca344d25d91161d2 /mysql-test/t/query_cache.test | |
| parent | 2f4db5348a43dea3ba21831955d0a029140d797c (diff) | |
| download | mariadb-git-73f8b4dac263964482b532199151c87596f191b7.tar.gz | |
MDEV-4981: Account for queries handled by query-cache in USER_STATISTICS (and in HOST_STATISTICS)
fix for SP & PS
Diffstat (limited to 'mysql-test/t/query_cache.test')
| -rw-r--r-- | mysql-test/t/query_cache.test | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test index d2f3e22d19d..47fa628190a 100644 --- a/mysql-test/t/query_cache.test +++ b/mysql-test/t/query_cache.test @@ -1665,7 +1665,47 @@ select SELECT_COMMANDS,ROWS_SENT,EMPTY_QUERIES from INFORMATION_SCHEMA.USER_STAT where USER="root"; show status like "Qcache_hits"; +FLUSH USER_STATISTICS; +FLUSH CLIENT_STATISTICS; +flush status; + +create procedure p1() + select * from t1; +call p1; +select SELECT_COMMANDS,ROWS_SENT,EMPTY_QUERIES from INFORMATION_SCHEMA.CLIENT_STATISTICS +where CLIENT="localhost"; +select SELECT_COMMANDS,ROWS_SENT,EMPTY_QUERIES from INFORMATION_SCHEMA.USER_STATISTICS +where USER="root"; +show status like "Qcache_hits"; +call p1; +call p1; +select SELECT_COMMANDS,ROWS_SENT,EMPTY_QUERIES from INFORMATION_SCHEMA.CLIENT_STATISTICS +where CLIENT="localhost"; +select SELECT_COMMANDS,ROWS_SENT,EMPTY_QUERIES from INFORMATION_SCHEMA.USER_STATISTICS +where USER="root"; +show status like "Qcache_hits"; + +FLUSH USER_STATISTICS; +FLUSH CLIENT_STATISTICS; +flush status; + +SET GLOBAL query_cache_size= 0; +call p1; +select SELECT_COMMANDS,ROWS_SENT,EMPTY_QUERIES from INFORMATION_SCHEMA.CLIENT_STATISTICS +where CLIENT="localhost"; +select SELECT_COMMANDS,ROWS_SENT,EMPTY_QUERIES from INFORMATION_SCHEMA.USER_STATISTICS +where USER="root"; +show status like "Qcache_hits"; +call p1; +call p1; +select SELECT_COMMANDS,ROWS_SENT,EMPTY_QUERIES from INFORMATION_SCHEMA.CLIENT_STATISTICS +where CLIENT="localhost"; +select SELECT_COMMANDS,ROWS_SENT,EMPTY_QUERIES from INFORMATION_SCHEMA.USER_STATISTICS +where USER="root"; +show status like "Qcache_hits"; +drop procedure p1; drop table t1; +set GLOBAL query_cache_size=1355776; SET GLOBAL userstat=default; --echo End of 5.5 tests |