← Back to team overview

maria-developers team mailing list archive

Re: extended keys

 

On 12/14/2012 11:33 AM, Rich Prohaska wrote:
> MySQL 5.6.9 changed how the number of key parts are measured.  They
> replaced one simple counter (key_parts) with four counters.  Glancing
> at the code, i assume that this was done to support extended keys.  If
> so, the mariadb implementation of extended keys is a lot simpler.  We
> have to maintain the tokudb storage engine on both mysql and mariadb.
> Is the mariadb design going to change to match the 5.6 implementation,
> or are the designs now separate?
> Thanks
> Rich Prohaska

Hi,

MariaDB supports extended keys starting with first version of 5.5.
See https://kb.askmonty.org/en/extended-keys/.

See also blogs:

http://igors-notes.blogspot.com/2011/12/3-way-join-that-touches-only-indexes.html

http://s.petrunia.net/blog/?p=74

The interesting thing is that Oracle essentially pulled MariaDB
implementation for this feature into a mysql version that was in RC.
Yet one hardly can find anything about the feature in the changelog or
in the manual.

Regards,
Igor.



> 
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-developers
> Post to     : maria-developers@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help   : https://help.launchpad.net/ListHelp



References