innodb_adaptive_flushing_method and innodb_flush_neighbor_pages partially broken
Bug #1039384 reported by
Laurynas Biveinis
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_
so
innodb_
Also, srv_adaptive_
Related branches
lp:~laurynas-biveinis/percona-server/bug1039384-5.1
- Stewart Smith (community): Approve
-
Diff: 363 lines (+344/-0)4 files modifiedPercona-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 modifiedPercona-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)
To post a comment you must log in.
SET GLOBAL innodb_ adaptive_ flushing_ method= '0'; innodb_ adaptive_ flushing_ method; innodb_ adaptive_ flushing_ method SCHEMA. GLOBAL_ VARIABLES WHERE VARIABLE_ NAME='innodb_ adaptive_ flushing_ method' ; ADAPTIVE_ FLUSHING_ METHOD 0 SCHEMA. SESSION_ VARIABLES WHERE VARIABLE_ NAME='innodb_ adaptive_ flushing_ method' ; ADAPTIVE_ FLUSHING_ METHOD 0
SELECT @@GLOBAL.
@@GLOBAL.
0
SELECT * FROM INFORMATION_
VARIABLE_NAME VARIABLE_VALUE
INNODB_
SELECT * FROM INFORMATION_
VARIABLE_NAME VARIABLE_VALUE
INNODB_
It should be s/0/native instead.