Description:
Manual for MySQL 5.6, https://dev.mysql.com/doc/refman/5.6/en/innodb-preload-buffer-pool.html, writes about the innodb_buffer_pool_pct variable:
"Before you dump pages from the buffer pool, configure the percentage of most-recently-used buffer pool pages that you want to dump by setting the innodb_buffer_pool_dump_pct option. If you plan to dump buffer pool pages while the server is running, you can configure the option dynamically:
SET GLOBAL innodb_buffer_dump_pct=40;"
This variable just does NOT exist in MySQL 5.6, from what I can see:
mysql> select version();
+------------+
| version() |
+------------+
| 5.6.24-log |
+------------+
1 row in set (0.00 sec)
mysql> show variables like 'innodb%dump%';
+-------------------------------------+-------+
| Variable_name | Value |
+-------------------------------------+-------+
| innodb_buffer_pool_dump_at_shutdown | OFF |
| innodb_buffer_pool_dump_now | OFF |
+-------------------------------------+-------+
2 rows in set (0.00 sec)
mysql> SET GLOBAL innodb_buffer_dump_pct=40;
ERROR 1193 (HY000): Unknown system variable 'innodb_buffer_dump_pct'
mysql>
You can also find this note at the beginning that refers to 5.7.7:
"Note
The innodb_buffer_pool_dump_at_shutdown and innodb_buffer_pool_load_at_startup configuration options are enabled by default as of MySQL 5.7.7, and the default value for innodb_buffer_pool_dump_pct is reduced from 100 to 25."
Why this is at all noted on the page for version 5.6?
How to repeat:
Try to follow the manual and set/use innodb_buffer_dump_pct variable on 5.6. Try to find its description in the manual for 5.6 anywhere outside of https://dev.mysql.com/doc/refman/5.6/en/innodb-preload-buffer-pool.html
Suggested fix:
Fix the manual for 5.6 to NOT refer to 5.7 or 5.7-specific settings.
