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) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.6, 5.7 OS:Any
Assigned to: CPU Architecture:Any

[4 Sep 2015 9:12] tsubasa tanaka
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 " 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.

[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.