Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Trivial
-
Resolution: Not a Bug
-
Affects Version/s: 5.5.31
-
Fix Version/s: 5.5.32
-
Component/s: None
-
Environment: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)
|