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

FLUSH GLOBAL STATUS

Details

    Description

      It could be interresting to be able to reset some of the global statuts values in case some important changes has been made to the MariaDB configuration, on the OS or on the applications using the server and you want to monitor how MariaDB is behaving with the new settings without restarting MariaDB.

      For example, these variables could be reset with a FLUSH GLOBAL STATUS : Bytes_received, Bytes_sent, Com_%, Connections, Created_tmp_%, Handler_%, Opened_%, Sort_%, Rows_%, queries, Questions, Select_%.

      An old bug/feature request on MySQL for it : http://bugs.mysql.com/bug.php?id=22875.

      Attachments

        Issue Links

          is part of

          New Feature - A new feature of the product, which has yet to be developed. MDEV-33145 Add FLUSH GLOBAL STATUS

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          links to

          Web Link Bug #22875 "FLUSH STATUS" does not reset global Com_% status variables

          Activity

            Ascending order - Click to sort in descending order
            juan.vera Juan added a comment - - edited

            It would be great if every status variable that counts actions got flushed when running FLUSH GLOBAL STATUS, such as this sampling of status variables that are not flushed in 10.0.38, 10.1.38, 10.2.23, 10.3.13, 10.4.3:

            Binlog_commits
            		 
            Binlog_group_commits
            		 
            Bytes_received
            		 
            Bytes_sent
            		 
            Innodb_buffer_pool_pages_flushed
            		 
            Innodb_buffer_pool_read_ahead_evicted
            		 
            Innodb_buffer_pool_read_requests
            		 
            Innodb_buffer_pool_reads
            		 
            Innodb_buffer_pool_write_requests
            		 
            Innodb_data_read
            		 
            Innodb_data_reads
            		 
            Innodb_dblwr_pages_written
            		 
            Innodb_dblwr_writes
            		 
            Innodb_log_writes
            		 
            Innodb_os_log_fsyncs
            		 
            Innodb_os_log_written
            		 
            Innodb_pages_created
            		 
            Innodb_pages_read
            		 
            Innodb_pages_written
            		 
            Innodb_s_lock_os_waits
            		 
            Innodb_s_lock_spin_waits
            		 
            Innodb_x_lock_os_waits
            		 
            Innodb_x_lock_spin_waits
            		 
            Opened_files
            		 
            Queries
            		 
            Syncs
            		 
            Threads_created

            juan.vera Juan added a comment - - edited It would be great if every status variable that counts actions got flushed when running FLUSH GLOBAL STATUS, such as this sampling of status variables that are not flushed in 10.0.38, 10.1.38, 10.2.23, 10.3.13, 10.4.3: Binlog_commits Binlog_group_commits Bytes_received Bytes_sent Innodb_buffer_pool_pages_flushed Innodb_buffer_pool_read_ahead_evicted Innodb_buffer_pool_read_requests Innodb_buffer_pool_reads Innodb_buffer_pool_write_requests Innodb_data_read Innodb_data_reads Innodb_dblwr_pages_written Innodb_dblwr_writes Innodb_log_writes Innodb_os_log_fsyncs Innodb_os_log_written Innodb_pages_created Innodb_pages_read Innodb_pages_written Innodb_s_lock_os_waits Innodb_s_lock_spin_waits Innodb_x_lock_os_waits Innodb_x_lock_spin_waits Opened_files Queries Syncs Threads_created
            GeoffMontee Geoff Montee (Inactive) added a comment -

            https://mariadb.com/kb/en/library/flush/#global-status-variables-that-support-flush-status

            GeoffMontee Geoff Montee (Inactive) added a comment - https://mariadb.com/kb/en/library/flush/#global-status-variables-that-support-flush-status

            People

              Unassigned Unassigned
              jb-boin Jean Weisbuch
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.