Bug #105570 Dynamic setting variable innodb_buffer_pool_load_abort cannot take effect

• Submitted: 15 Nov 2021 8:53
• Modified: 15 Nov 2021 9:00
• Reporter: yi qian
• Status: Verified
• Category: MySQL Server: Options
• Severity: S2 (Serious)
• Version: 8.0.25, 8.0.27, 5.7.36
• OS: Any
• CPU Architecture: Any
• Tags: innodb_buffer_pool_load_abort

[15 Nov 2021 8:53] yi qian

Description:
When setting variable innodb_buffer_pool_load_abort, the result shows that the setting is successful. In fact, the setting  does not take effect.

How to repeat:
1. View the current value of the variable
mysql> show global variables like "innodb_buffer_pool_load_abort";
+-------------------------------+-------+
| Variable_name                 | Value |
+-------------------------------+-------+
| innodb_buffer_pool_load_abort | OFF   |
+-------------------------------+-------+
1 row in set (0.01 sec)

2. Setting variables 
mysql> SET GLOBAL innodb_buffer_pool_load_abort=ON;
Query OK, 0 rows affected (0.00 sec)

3. View the current value of the variable
mysql> show global variables like "innodb_buffer_pool_load_abort";
+-------------------------------+-------+
| Variable_name                 | Value |
+-------------------------------+-------+
| innodb_buffer_pool_load_abort | OFF   |
+-------------------------------+-------+
1 row in set (0.00 sec)

[15 Nov 2021 9:00] MySQL Verification Team

Hello yi qian,

Thank you for the report and feedback.

regards,
Umesh