Percona Server with XtraDB

innodb_adaptive_flushing_method and innodb_flush_neighbor_pages partially broken

Reported by Laurynas Biveinis on 2012-08-21
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Server
High
Laurynas Biveinis
5.1
High
Laurynas Biveinis
5.5
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.

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.

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

Other bug subscribers