Percona Server moved to https://jira.percona.com/projects/PS

innodb_adaptive_flushing_method and innodb_flush_neighbor_pages partially broken

Bug #1039384 reported by Laurynas Biveinis
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
Percona Server moved to https://jira.percona.com/projects/PS 5.5.27-28.1
5.1
Fix Released
High
Laurynas Biveinis
Percona Server moved to https://jira.percona.com/projects/PS 5.1.65-14.0
5.5
Fix Released
High
Laurynas Biveinis
Percona Server moved to https://jira.percona.com/projects/PS 5.5.27-28.1

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

lp:~laurynas-biveinis/percona-server/bug1039384-5.1
Stewart Smith (community): Approve
Diff: 363 lines (+344/-0)
4 files modified
Percona-Server/mysql-test/suite/innodb_plugin/r/innodb_adaptive_checkpoint_basic.result (+97/-0)
Percona-Server/mysql-test/suite/innodb_plugin/r/innodb_read_ahead_basic.result (+97/-0)
Percona-Server/mysql-test/suite/innodb_plugin/t/innodb_adaptive_checkpoint_basic.test (+75/-0)
Percona-Server/mysql-test/suite/innodb_plugin/t/innodb_read_ahead_basic.test (+75/-0)
lp:~laurynas-biveinis/percona-server/bug1039384-5.5
Stewart Smith (community): Approve
Sergei Glushchenko (community): Approve
Diff: 903 lines (+799/-16)
15 files modified
Percona-Server/mysql-test/suite/sys_vars/r/innodb_adaptive_flushing_method_basic.result (+79/-3)
Percona-Server/mysql-test/suite/sys_vars/r/innodb_adaptive_flushing_method_startup.result (+18/-0)
Percona-Server/mysql-test/suite/sys_vars/r/innodb_corrupt_table_action_basic.result (+48/-2)
Percona-Server/mysql-test/suite/sys_vars/r/innodb_flush_neighbor_pages_basic.result (+79/-3)
Percona-Server/mysql-test/suite/sys_vars/r/innodb_flush_neighbor_pages_startup.result (+18/-0)
Percona-Server/mysql-test/suite/sys_vars/r/innodb_read_ahead_basic.result (+99/-3)
Percona-Server/mysql-test/suite/sys_vars/r/innodb_read_ahead_startup.result (+24/-0)
Percona-Server/mysql-test/suite/sys_vars/t/innodb_adaptive_flushing_method_basic.test (+62/-1)
Percona-Server/mysql-test/suite/sys_vars/t/innodb_adaptive_flushing_method_startup.test (+57/-0)
Percona-Server/mysql-test/suite/sys_vars/t/innodb_corrupt_table_action_basic.test (+47/-1)
Percona-Server/mysql-test/suite/sys_vars/t/innodb_flush_neighbor_pages_basic.test (+62/-1)
Percona-Server/mysql-test/suite/sys_vars/t/innodb_flush_neighbor_pages_startup.test (+57/-0)
Percona-Server/mysql-test/suite/sys_vars/t/innodb_read_ahead_basic.test (+72/-1)
Percona-Server/mysql-test/suite/sys_vars/t/innodb_read_ahead_startup.test (+75/-0)
Percona-Server/storage/innobase/handler/ha_innodb.cc (+2/-1)
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

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.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.