MariaDB [test]> create table t1 (i int);
|
Query OK, 0 rows affected (0.41 sec)
|
|
MariaDB [test]> with cte as (select * from t1) select * from cte;
|
Empty set (0.01 sec)
|
|
MariaDB [test]> show status like 'Qcache%';
|
+-------------------------+---------+
|
| Variable_name | Value |
|
+-------------------------+---------+
|
| Qcache_free_blocks | 1 |
|
| Qcache_free_memory | 1031080 |
|
| Qcache_hits | 0 |
|
| Qcache_inserts | 0 |
|
| Qcache_lowmem_prunes | 0 |
|
| Qcache_not_cached | 0 |
|
| Qcache_queries_in_cache | 0 |
|
| Qcache_total_blocks | 1 |
|
+-------------------------+---------+
|
8 rows in set (0.00 sec)
|
|
MariaDB [test]> select @@query_cache_type, @@query_cache_size;
|
+--------------------+--------------------+
|
| @@query_cache_type | @@query_cache_size |
|
+--------------------+--------------------+
|
| ON | 1048576 |
|
+--------------------+--------------------+
|
1 row in set (0.00 sec)
|