Details
-
Bug
-
Status: Stalled (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.10, 10.11, 11.0
-
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
- relates to
-
MDEV-28539 Some InnoDB counters are duplicating generic SHOW STATUS
-
- Closed
-