Bug #78323 Incorrect sample statement in doc "Preloading the InnoDB Buffer Pool"

• Submitted: 4 Sep 2015 9:12
• Modified: 24 Sep 2015 22:26
• Reporter: Tsubasa Tanaka (OCA)
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.6, 5.7
• OS: Any
• CPU Architecture: Any

[4 Sep 2015 9:12] Tsubasa Tanaka

Description:
Docs say

```
Aborting a Buffer Pool Load

To abort a buffer pool load operation, issue the statement:

SET innodb_buffer_pool_load_abort=ON;
```

in "14.3.3.5 Preloading the InnoDB Buffer Pool for Faster Restart".
* http://dev.mysql.com/doc/refman/5.6/en/innodb-preload-buffer-pool.html
* http://dev.mysql.com/doc/refman/5.7/en/innodb-preload-buffer-pool.html

But innodb_buffer_pool_load_abort is global variable.
Sample statement should be `SET GLOBAL innodb_buffer_pool_load_abort=ON;`.

* http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_buffer_pool_lo...
* http://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_buffer_pool_lo...

How to repeat:
mysql> SET innodb_buffer_pool_load_abort= 1;
ERROR 1229 (HY000): Variable 'innodb_buffer_pool_load_abort' is a GLOBAL variable and should be set with SET GLOBAL

Suggested fix:
Fix sample statement correctly.

* http://dev.mysql.com/doc/refman/5.6/en/innodb-preload-buffer-pool.html
* http://dev.mysql.com/doc/refman/5.7/en/innodb-preload-buffer-pool.html

[4 Sep 2015 9:20] MySQL Verification Team

Hello Tsubasa-San,

Thank you for the report.

Thanks,
Umesh

[24 Sep 2015 22:26] Daniel Price

Posted by developer:
 
The referenced content was corrected. The change should appear online within 24 hours.

Thank you for the bug report.