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

mariadb-admin flush-status command should do FLUSH GLOBAL STATUS

    XMLWordPrintable

Details

    • Bug
    • Status: In Testing (View Workflow)
    • Critical
    • Resolution: Unresolved
    • N/A
    • 11.5
    • Scripts & Clients
    • None

    Description

      mariadb-admin flush-status runs FLUSH STATUS command. After MDEV-33145, apparently it should run FLUSH GLOBAL STATUS instead, it would be closer to what it did before. I don't believe there is a need for a new command in the tool, as FLUSH [SESSION] STATUS is simply meaningless in this context.

      --connect (con1,localhost,root,)
      --connect (con2,localhost,root,)
      --connect (con3,localhost,root,)
      --disconnect con1
      --disconnect con2
      --disconnect con3
       
      --connection default
      show status like 'Max_used_connections';
      show global status like 'Max_used_connections';
       
      --echo #
      --echo # Running mariadb-admin flush-status
      --echo #
      --exec $MYSQLADMIN flush-status
       
      show status like 'Max_used_connections';
      show global status like 'Max_used_connections';
      

      Before MDEV-33145:

      11.4 53a359cf0d8e5501e64eaa8a294ed42c4e939a78

      show status like 'Max_used_connections';
      Variable_name	Value
      Max_used_connections	4
      show global status like 'Max_used_connections';
      Variable_name	Value
      Max_used_connections	4
      #
      # Running mariadb-admin flush-status
      #
      show status like 'Max_used_connections';
      Variable_name	Value
      Max_used_connections	2
      show global status like 'Max_used_connections';
      Variable_name	Value
      Max_used_connections	2
      

      After:

      bb-11.5-MDEV-33145-flush-global-status dd182933a1dac15cb592990eb5fb04b9030a6a92

      show status like 'Max_used_connections';
      Variable_name	Value
      Max_used_connections	4
      show global status like 'Max_used_connections';
      Variable_name	Value
      Max_used_connections	4
      #
      # Running mariadb-admin flush-status
      #
      show status like 'Max_used_connections';
      Variable_name	Value
      Max_used_connections	4
      show global status like 'Max_used_connections';
      Variable_name	Value
      Max_used_connections	4
      

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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