Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4693

FLUSH STATUS is reseting Subquery_cache_miss and Subquery_cache_hits global status variables

    XMLWordPrintable

    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
    • Labels:
    • 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)

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            jb-boin Jean Weisbuch
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration