innodb_adaptive_flushing_method and innodb_flush_neighbor_pages partially broken

Bug #1039384 reported by Laurynas Biveinis on 2012-08-21
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
High
Laurynas Biveinis
5.1
Fix Released
High
Laurynas Biveinis
5.5
Fix Released
High
Laurynas Biveinis

Bug Description

Spinned off from bug 1037343:

 innodb_flush_neigbor=0 is not translated internally into 0 value, but rather into 3.
so
 innodb_flush_neigbor=0 is not equal innodb_flush_neigbor=none,

Also, srv_adaptive_flushing_method is set mod 3 in server startup, but mod 4 during dynamic update.

Related branches

SET GLOBAL innodb_adaptive_flushing_method='0';
SELECT @@GLOBAL.innodb_adaptive_flushing_method;
@@GLOBAL.innodb_adaptive_flushing_method
0
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='innodb_adaptive_flushing_method';
VARIABLE_NAME VARIABLE_VALUE
INNODB_ADAPTIVE_FLUSHING_METHOD 0
SELECT * FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='innodb_adaptive_flushing_method';
VARIABLE_NAME VARIABLE_VALUE
INNODB_ADAPTIVE_FLUSHING_METHOD 0

It should be s/0/native instead.

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-578

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers