Downport of InnoDB/ICP from mysql 5.6 increased Innodb_buffer_pool_read_requests
Bug #929838 reported by
Sergey Petrunia
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
In Progress
|
High
|
Sergey Petrunia |
Bug Description
After downport of InnoDB/ICP from mysql 5.6 (revno: 2955, revision-id: <email address hidden>) the number of Innodb_
Fixed made by
revno: 3406 revision-id: <email address hidden>
revno: 3407 revision-id: <email address hidden>
address the problem for the most part, but certain difference remains.
Changed in maria: | |
milestone: | none → 5.3 |
Changed in maria: | |
importance: | Undecided → High |
status: | New → Confirmed |
status: | Confirmed → In Progress |
Changed in maria: | |
assignee: | Igor Babaev (igorb-seattle) → Sergey Petrunia (sergefp) |
To post a comment you must log in.
Ways to repeat:
1. Make the dataset: ./tests/ db/oltp. lua --oltp- table-size= 10000000 \ socket= /tmp/mysqld. sock \ table-engine= innodb prepare
./sysbench --test=
--db-driver=mysql --mysql-user=root --mysql-
--mysql-
2. Prepare two trees,
1. "Before" tree: 5.3 branched at -r2954
2. "After" tree: 5.3, branched at -r2955, with 3406
Run the attached script and watch the difference in output:
"Before" tree produces (showing only lines with 'OUT'):
incr OUT
13 OUT
incr OUT
12 OUT
incr OUT
12 OUT
incr OUT
12 OUT
incr OUT
12 OUT
"After" tree produces (showing only lines with 'OUT'):
incr OUT
14 OUT
incr OUT
13 OUT
incr OUT
13 OUT
incr OUT
13 OUT
incr OUT
13 OUT