diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/query_cache.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/query_cache.result | 34 |
1 files changed, 22 insertions, 12 deletions
diff --git a/mysql-test/suite/perfschema/r/query_cache.result b/mysql-test/suite/perfschema/r/query_cache.result index ae64c90582c..4c31d9ded5f 100644 --- a/mysql-test/suite/perfschema/r/query_cache.result +++ b/mysql-test/suite/perfschema/r/query_cache.result @@ -3,21 +3,27 @@ drop table if exists t1; create table t1 (a int not null); insert into t1 values (1), (2), (3); SET GLOBAL query_cache_size=1355776; +Warnings: +Warning 1287 '@@query_cache_size' is deprecated and will be removed in a future release. flush query cache; +Warnings: +Warning 1681 'FLUSH QUERY CACHE' is deprecated and will be removed in a future release. reset query cache; +Warnings: +Warning 1681 'RESET QUERY CACHE' is deprecated and will be removed in a future release. flush status; select * from t1; a 1 2 3 -show status like "Qcache_queries_in_cache"; +show global status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 -show status like "Qcache_inserts"; +show global status like "Qcache_inserts"; Variable_name Value Qcache_inserts 1 -show status like "Qcache_hits"; +show global status like "Qcache_hits"; Variable_name Value Qcache_hits 0 select * from t1; @@ -25,13 +31,13 @@ a 1 2 3 -show status like "Qcache_queries_in_cache"; +show global status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 -show status like "Qcache_inserts"; +show global status like "Qcache_inserts"; Variable_name Value Qcache_inserts 1 -show status like "Qcache_hits"; +show global status like "Qcache_hits"; Variable_name Value Qcache_hits 1 select spins from performance_schema.events_waits_current order by event_name limit 1; @@ -40,13 +46,15 @@ NULL select * from performance_schema.setup_timers where name='wait'; NAME TIMER_NAME wait {CYCLE_OR_NANOSECOND} -show status like "Qcache_queries_in_cache"; +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release. +show global status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 -show status like "Qcache_inserts"; +show global status like "Qcache_inserts"; Variable_name Value Qcache_inserts 1 -show status like "Qcache_hits"; +show global status like "Qcache_hits"; Variable_name Value Qcache_hits 1 select spins from performance_schema.events_waits_current order by event_name limit 1; @@ -55,13 +63,15 @@ NULL select * from performance_schema.setup_timers where name='wait'; NAME TIMER_NAME wait {CYCLE_OR_NANOSECOND} -show status like "Qcache_queries_in_cache"; +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release. +show global status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 -show status like "Qcache_inserts"; +show global status like "Qcache_inserts"; Variable_name Value Qcache_inserts 1 -show status like "Qcache_hits"; +show global status like "Qcache_hits"; Variable_name Value Qcache_hits 1 SET GLOBAL query_cache_size=@save_query_cache_size; |