Details
-
Bug
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Not a Bug
-
5.5.31
-
None
-
Debian Squeeze amd64
Description
Normally, only the SESSION status variables are flushed/reset when FLUSH STATUS is called but the Subquery_cache_hit and Subquery_cache_miss variables are globally reset (knowing that these status variables have the same value for the GLOBAL and SESSION scope).
MariaDB \[(none)]> SHOW GLOBAL STATUS LIKE 'Subquery_cache%'; FLUSH STATUS; SHOW GLOBAL STATUS LIKE 'Subquery_cache%';
|
+---------------------+-----------+
|
| Variable_name | Value |
|
+---------------------+-----------+
|
| Subquery_cache_hit | 732043764 |
|
| Subquery_cache_miss | 46946161 |
|
+---------------------+-----------+
|
2 rows in set (0.00 sec)
|
|
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
+---------------------+-------+
|
| Variable_name | Value |
|
+---------------------+-------+
|
| Subquery_cache_hit | 0 |
|
| Subquery_cache_miss | 0 |
|
+---------------------+-------+
|
2 rows in set (0.00 sec)
|