maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #04997
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