[DOC] AHI partitions not always optimal

Bug #1413564 reported by Kenny Gryp
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Medium
Hrvoje Matijakovic
5.5
Fix Released
Medium
Hrvoje Matijakovic
5.6
Fix Released
Medium
Hrvoje Matijakovic

Bug Description

See Chat:

10:44 <@gryp> laurynas: hi! about multiple AH partitions. that's per index. How is the size of these partitions? Is
              that in case of 2: 50% or can they grow to different sizes?
10:45 < laurynas> gryp: actually I don't know from the top of my head
10:47 < laurynas> gryp: let's see if I can see this in the source code quickly
10:48 < laurynas> gryp: 2: 50%
10:49 <@gryp> laurynas: auch! OK. Thanks.
10:50 < laurynas> :) yep not very good for very large few tables

Tags: doc
Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

Set to confirmed. We should update details in doc that
"hash indexes are assigned to each one based on index_id" is not enough
" When greater than one, the specified number of partitions are created across which to perform the adaptive search."
 in this case we should explain that index is split into N equal parts

http://www.percona.com/doc/percona-server/5.5/scalability/innodb_adaptive_hash_index_partitions.html

Changed in percona-server:
status: New → Confirmed
Changed in percona-server:
importance: Undecided → Medium
status: Confirmed → Triaged
Revision history for this message
Hrvoje Matijakovic (hrvojem) wrote :
Changed in percona-server:
status: Triaged → Fix Released
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-1602

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

Other bug subscribers

Remote bug watches

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