Bug #112127 SHOW ENGINE INNODB STATUS doesn't report total buffer pool bytes

• Submitted: 22 Aug 2023 1:01
• Modified: 22 Aug 2023 6:01
• Reporter: Tsubasa Tanaka (OCA)
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 8.0.27 and later, 8.1.0
• OS: CentOS (7.9)
• CPU Architecture: x86

[22 Aug 2023 1:01] Tsubasa Tanaka

Description:
The output of "SHOW ENGINE INNODB STATUS" lacks "Total large memory allocated" value.
After 8.0.27 and later, including 8.1.0, returns always 0 instead of real allocated memory bytes.

How to repeat:
### 8.0.26

mysql> SELECT @@version, @@innodb_buffer_pool_size;
+-----------+---------------------------+
| @@version | @@innodb_buffer_pool_size |
+-----------+---------------------------+
| 8.0.26    |                 134217728 |
+-----------+---------------------------+
1 row in set (0.00 sec)

mysql> SHOW ENGINE INNODB STATUS\G
*************************** 1. row ***************************
  Type: InnoDB
  Name:
Status:
=====================================
2023-08-22 00:56:26 140280686102272 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 7 seconds
<snip>
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 137039872
Dictionary memory allocated 366605
Buffer pool size   8192
<snip>

### 8.0.27
mysql> SELECT @@version, @@innodb_buffer_pool_size;
+-----------+---------------------------+
| @@version | @@innodb_buffer_pool_size |
+-----------+---------------------------+
| 8.0.27    |                 134217728 |
+-----------+---------------------------+
1 row in set (0.00 sec)

mysql> SHOW ENGINE INNODB STATUS\G
*************************** 1. row ***************************
  Type: InnoDB
  Name:
Status:
=====================================
2023-08-22 00:56:57 140199880595200 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 6 seconds
<snip>
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 366605
Buffer pool size   8192
<snip>

### 8.1.0

mysql81 36> SELECT @@version, @@innodb_buffer_pool_size;
+-------------+---------------------------+
| @@version   | @@innodb_buffer_pool_size |
+-------------+---------------------------+
| 8.1.0-debug |                  67108864 |
+-------------+---------------------------+
1 row in set (0.00 sec)

mysql81 36> SHOW ENGINE INNODB STATUS\G
*************************** 1. row ***************************
  Type: InnoDB
  Name:
Status:
=====================================
2023-08-22 10:00:44 139785418151680 INNODB MONITOR OUTPUT
=====================================
<snip>
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 643375
Buffer pool size   4096
<snip>

[22 Aug 2023 6:01] MySQL Verification Team

Hello tanaka-San,

Thank you for the report and feedback.

regards,
Umesh