Bug #69129 innodb_flush_neighbors is listed as boolean, but can take three values
Submitted: 3 May 2013 5:47 Modified: 11 Jun 2013 18:14
Reporter: Erlend Dahl Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Bugs System CPU Architecture:Any

[3 May 2013 5:47] Erlend Dahl
According to 


innodb_flush_neighbors is boolean, but in reality it can take three values:

static MYSQL_SYSVAR_ULONG(flush_neighbors, srv_flush_neighbors,
  "Set to 0 (don't flush neighbors from buffer pool),"
  " 1 (flush contiguous neighbors from buffer pool)"
  " or 2 (flush neighbors from buffer pool),"
  " when flushing a block",
  NULL, NULL, 1, 0, 2, 0);

How to repeat:
Grep for MYSQL_SYSVAR in ha_innodb.cc
[3 May 2013 8:13] Erlend Dahl
Note that in bug#69046, there is a request to explain what the impact of these settings are and in which situations they apply.
[11 Jun 2013 18:14] Bugs System
Documentation for innodb_flush_neighbours has been revised in version 5.6 and 5.7 of the reference manual.

Thank you for the bug report.