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

subsystem dml missing in information_schema.innodb_metrics

    XMLWordPrintable

Details

    Description

      information_schema.innodb_metrics is missing counters for dml_*
      In MariaDB 10.11.11

      SELECT name, subsystem, enabled FROM INFORMATION_SCHEMA.INNODB_METRICS where subsystem = 'dml';
      Empty set (0.001 sec)
      

      In MariaDB 10.6.18

      +--------------------+-----------+---------+
      | name               | subsystem | enabled |
      +--------------------+-----------+---------+
      | dml_reads          | dml       |       1 |
      | dml_inserts        | dml       |       1 |
      | dml_deletes        | dml       |       1 |
      | dml_updates        | dml       |       1 |
      | dml_system_reads   | dml       |       1 |
      | dml_system_inserts | dml       |       1 |
      | dml_system_deletes | dml       |       1 |
      | dml_system_updates | dml       |       1 |
      +--------------------+-----------+---------+
      

      If this is on purpose than it should be stated here https://mariadb.com/kb/en/information-schema-innodb_metrics-table/

      This information would be used by https://github.com/prometheus/mysqld_exporter

      I didn't find any information regarding this issue in the knowledge base or bug tracker. Sorry if I missed it.

      Attachments

        Issue Links

          Activity

            People

              stefan.hinz Stefan Hinz
              martinh Martin Huxhold
              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.