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

"innodb_monitor_disable = default" does not reset all monitors "enable" stataus to default

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.6, 10.11, 11.1(EOL), 11.2, 10.4(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 11.0(EOL), 11.3(EOL)
    • 10.4(EOL)
    • None

    Description

      SET GLOBAL innodb_monitor_disable = default;
      

      Does not restore all metrics enabling to default values.
      The following test shows differences:

      --source include/have_innodb.inc                                                
      --source include/have_debug.inc                                                 
                                                                                      
      SET GLOBAL innodb_monitor_disable = default;                                    
      --eval select name, enabled from information_schema.innodb_metrics into outfile '$MYSQL_TMP_DIR/out-1'
                                                                                      
      SET GLOBAL innodb_monitor_disable=all;                                          
      SET GLOBAL innodb_monitor_disable = default;                                    
                                                                                      
      --eval select name, enabled from information_schema.innodb_metrics into outfile '$MYSQL_TMP_DIR/out-2'
                                                                                      
      --exec diff -u $MYSQL_TMP_DIR/out-1 $MYSQL_TMP_DIR/out-2                        
                                                                                      
      --remove-file $MYSQL_TMP_DIR/out-1                                              
      --remove-file $MYSQL_TMP_DIR/out-2 
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              vlad.lesin Vladislav Lesin
              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.