Bug #112798 The configuration value of innodb_buffer_pool_size underflow
Submitted: 23 Oct 2023 7:02 Modified: 23 Oct 2023 7:44
Reporter: Ying FU Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Options Severity:S2 (Serious)
Version:8.1, 8.0.34 OS:Linux
Assigned to: CPU Architecture:Any

[23 Oct 2023 7:02] Ying FU
Description:
Set innodb_buffer_pool_size to the maximum value twice, the configuration value of innodb_buffer_pool_size will underflow.

While it will not happen on MariaDB.

How to repeat:
mysql> show global variables like 'innodb_buffer_pool_%size' ;
+-------------------------------+-----------+
| Variable_name                 | Value     |
+-------------------------------+-----------+
| innodb_buffer_pool_chunk_size | 134217728 |
| innodb_buffer_pool_size       | 134217728 |
+-------------------------------+-----------+
2 rows in set (0.01 sec)

mysql> SET GLOBAL innodb_buffer_pool_size = 18446744073709551615;
Query OK, 0 rows affected, 2 warnings (0.00 sec)

mysql> SET GLOBAL innodb_buffer_pool_size = 18446744073709551615;
Query OK, 0 rows affected, 2 warnings (0.00 sec)

mysql> show global variables like 'innodb_buffer_pool_%size' ;
+-------------------------------+----------------------+
| Variable_name                 | Value                |
+-------------------------------+----------------------+
| innodb_buffer_pool_chunk_size | 134217728            |
| innodb_buffer_pool_size       | -9223372036854775808 |
+-------------------------------+----------------------+
[23 Oct 2023 7:44] MySQL Verification Team
Hello ying ying,

Thank you for the report and feedback.

regards,
Umesh