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

Innodb_rows_* missing on mariadb-server 10.11.3

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.10(EOL), 10.11, 11.0(EOL)
    • 10.11
    • None
    • None
    • OS: Debian 12 (Bookworm)
      MariaDB Server: 10.11.3

    Description

      On MariaDB Server 10.11.3 (the default version on Debian 12), the Innodb_rows_* columns from SHOW GLOBAL STATUS are missing:

      $ sudo apt install mariadb-server
      ...
      $ mysql --version
      mysql  Ver 15.1 Distrib 10.11.3-MariaDB, for debian-linux-gnu (x86_64) using  EditLine wrapper
      $ sudo mysql -Bse 'SHOW GLOBAL STATUS;' | grep Innodb_rows
      $
      

      This doesn't occur on 10.5.19 (the default version on Debian 11):

      $ sudo apt install mariadb-server
      ...
      $ mysql --version
      mysql  Ver 15.1 Distrib 10.5.19-MariaDB, for debian-linux-gnu (x86_64) using  EditLine wrapper
      $ sudo mysql -Bse 'SHOW GLOBAL STATUS;' | grep Innodb_rows
      Innodb_rows_deleted     0
      Innodb_rows_inserted    0
      Innodb_rows_read        0
      Innodb_rows_updated     0
      $
      

      I tried creating a dummy database with a dummy table and dummy rows but I still don't see the columns.

      Likewise, SHOW ENGINE INNODB STATUS doesn't show row operations on 10.11.3:

      $ sudo mysql -Bse 'SHOW ENGINE INNODB STATUS;' | sed 's/\\n/\n/g'
      ...
      --------------
      ROW OPERATIONS
      --------------
      0 read views open inside InnoDB
      state: sleeping
      ----------------------------
      END OF INNODB MONITOR OUTPUT
      ============================
      

      But it does on 10.5.19:

      $ sudo mysql -Bse 'SHOW ENGINE INNODB STATUS;' | sed 's/\\n/\n/g'
      ...
      --------------
      ROW OPERATIONS
      --------------
      0 read views open inside InnoDB
      Process ID=0, Main thread ID=0, state: sleeping
      Number of 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
      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
      ----------------------------
      END OF INNODB MONITOR OUTPUT
      ============================
      

      Did something relevant change between those two versions? How do I get those values on 10.11.3? I don't see any callouts in the docs about those values being removed or renamed after 10.5.19.

      Attachments

        Issue Links

          Activity

            People

              ralf.gebhardt Ralf Gebhardt
              jefferbrecht Jeff Erbrecht
              Votes:
              1 Vote for this issue
              Watchers:
              9 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.