EVOLUTION-MANAGER
Edit File: rocksdb_qcache.test
--source include/have_rocksdb.inc # Important: # The test needs to be run with --mysqld=--query-cache-type=1 -- source include/have_query_cache.inc --enable_connect_log create table t1 (pk int primary key, c char(8)) engine=RocksDB; insert into t1 values (1,'new'),(2,'new'); select * from t1; --connect (con1,localhost,root,,) update t1 set c = 'updated'; #select * from t1; --connection default flush status; show status like 'Qcache_hits'; show global status like 'Qcache_hits'; select * from t1; select sql_no_cache * from t1; select * from t1 where pk = 1; show status like 'Qcache_hits'; --echo # MariaDB: Qcache_not_cached is not incremented for select sql_no_cache queries --echo # so the following query produces 2, not 3: show status like 'Qcache_not_cached'; show global status like 'Qcache_hits'; drop table t1;