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

SHOW ENGINE INNODB STATUS doesn't seem to report row operations anymore

    XMLWordPrintable

Details

    Description

      Starting with version 10.11 (maybe earlier), it looks like `SHOW ENGINE INNODB STATUS` doesn't report "Row operations" stats anymore.

      On a fresh install:

      > SHOW ENGINE INNODB STATUS\G
      		 
      [...]
      		 
      --------------
      		 
      ROW OPERATIONS
      		 
      --------------
      		 
      0 read views open inside InnoDB
      		 
      state: sleeping
      		 
      ----------------------------
      		 
      END OF INNODB MONITOR OUTPUT
      		 
      ============================

      By contrast, the documentation still references counters that were found in previous versions:
      https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status 

      --------------
      		 
      ROW OPERATIONS
      		 
      --------------
      		 
      0 queries inside InnoDB, 0 queries in queue
      		 
      0 read views open inside InnoDB
      		 
      Process ID=4267, Main thread ID=140272021272320, state: sleeping
      		 
      Number of rows inserted 1, updated 0, deleted 0, read 1
      		 
      0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
      		 
      Number of system rows inserted 0, updated 0, deleted 0, read 0
      		 
      0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s

      I didn't find anything in the documentation about a format change, or deprecation of those counters. Are such discrepancies expected? Is there a way to restore them to get more information about row operations in `SHOW ENGINE INNODB STATUS`?

      Thanks!

      Attachments

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-28539 Some InnoDB counters are duplicating generic SHOW STATUS

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-18391 Print ENGINE INNODB STATUS in machine parsable format

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31772 Innodb_rows_* missing on mariadb-server 10.11.3

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37152 buf_page_get_gen -> buf_pool->stat.n_page_gets++ high cpu utilisation

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

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              Kilian kilian
              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.