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

    • Bug
    • Status: Closed (View Workflow)
    • Trivial
    • Resolution: Not a Bug
    • 5.5.31
    • 5.5.32
    • 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)

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.