Adaptive hash index partitions not tested in MTR

Bug #1214449 reported by Laurynas Biveinis on 2013-08-20
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Undecided
Unassigned
5.1
Undecided
Unassigned
5.5
Low
Laurynas Biveinis
5.6
Undecided
Unassigned

Bug Description

Adaptive hash index partitions do not have a single MTR test. A basic test would be setting partitions to > 1 and running some workload with number of index trees >> AHI partitions and buffer pool size setting that would allow non-trivial amount of AHI pages. A bit more advanced test would be collecting failures, if any, from --mysqld=--innodb-adaptive-hash-index-partitions=N run to a testcase.

The bug does not apply for 5.6 but such testcases need to be created for https://blueprints.launchpad.net/percona-server/+spec/ahi-part-5-6 blueprint work.

Related branches

lp:~laurynas-biveinis/percona-server/ahi-partitions-5.6-5.5
Alexey Kopytov (community): Approve on 2013-08-29
lp:~laurynas-biveinis/percona-server/ahi-partitions-5.6-5.6
Alexey Kopytov (community): Approve on 2013-08-29
tags: added: ahi-partitions xtradb

MTR --mysqld=--innodb-adaptive-hash-index-partitions=8 run is clean: http://jenkins.percona.com/job/percona-server-5.5-param/824/

Does this also test (innodb_buffer_pool_instances > 1) with
(innodb_adaptive_hash_index_partitions > 1), since that
particular combination has had a few bug reports earlier.

It would also be good to include this in RQG's combination
testing.

Raghu -

Code review tells that the number of buffer pool instances should be completely orthogonal to the number of AHI partitions. Were there any bugs that were repeatable with ibpi > 1 and not repeatable with ibpi = 1 while the number of AHI partitions was kept constant at > 1?

Re. RQG, see PQA-58 for AHI partitions and I'm asking Roel the status of ibpi > 1 testing there.

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

Other bug subscribers

Related blueprints