← Back to team overview

enterprise-support team mailing list archive

[Bug 1679155] [NEW] InnoDB adaptive hash index uses a bad partitioning algorithm for the real world

 

Public bug reported:

This is track fixing upstream https://bugs.mysql.com/bug.php?id=81814 by
replacing the current AHI partitioning function that hashes on both
index id and space id, with an index id-based one to ensure more uniform
bucket distribution

** Affects: mysql-server
     Importance: Unknown
         Status: Unknown

** Affects: percona-server
     Importance: Wishlist
     Assignee: Laurynas Biveinis (laurynas-biveinis)
         Status: In Progress

** Affects: percona-server/5.5
     Importance: Wishlist
         Status: Won't Fix

** Affects: percona-server/5.6
     Importance: Wishlist
         Status: Won't Fix

** Affects: percona-server/5.7
     Importance: Wishlist
     Assignee: Laurynas Biveinis (laurynas-biveinis)
         Status: In Progress


** Tags: ahi-partitions performance upstream

** Tags added: ahi-partitions performance upstream

** Also affects: percona-server/5.6
   Importance: Undecided
       Status: New

** Also affects: percona-server/5.5
   Importance: Undecided
       Status: New

** Also affects: percona-server/5.7
   Importance: Undecided
       Status: New

** Changed in: percona-server/5.5
       Status: New => Invalid

** Changed in: percona-server/5.5
       Status: Invalid => Won't Fix

** Changed in: percona-server/5.6
       Status: New => Won't Fix

** Changed in: percona-server/5.5
   Importance: Undecided => Wishlist

** Changed in: percona-server/5.6
   Importance: Undecided => Wishlist

** Changed in: percona-server/5.7
     Assignee: (unassigned) => Laurynas Biveinis (laurynas-biveinis)

** Changed in: percona-server/5.7
   Importance: Undecided => Wishlist

** Changed in: percona-server/5.7
       Status: New => In Progress

** Bug watch added: MySQL Bug System #81814
   http://bugs.mysql.com/bug.php?id=81814

** Also affects: mysql-server via
   http://bugs.mysql.com/bug.php?id=81814
   Importance: Unknown
       Status: Unknown

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1679155

Title:
  InnoDB adaptive hash index uses a bad partitioning algorithm for the
  real world

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1679155/+subscriptions


Follow ups