On 03/01/2014 08:00 PM, Clint Byrum wrote: > Excerpts from Robert Collins's message of 2014-03-01 14:26:57 -0800: >> On 1 March 2014 13:28, Clint Byrum <cl...@fewbar.com> wrote: >> >>> +1. A Keystone record belongs to Keystone, and it should have a Keystone >>> ID. External records that are linked should be linked separately. >>> >>> It may not be obvious to everyone, but MySQL uses B-trees for indexes. >>> B-trees cannot have variable-length keys. >> >> Hmm, B-Trees and B+-Trees both can have variable length keys. I'll >> accept an assertion that MySQL index B-trees cannot - but we should be >> precise here, because its not a global limitation. >> > > Sorry, I misspoke, _InnoDB's_ b-tree's cannot have variable length keys. > :-P
On a previous project we did a transition from varchar based UUID to
binary based UUID in MySQL. The micro benchmarks on joins got faster by
a factor of 10,000 (yes 10k). Granted, MySQL has evolved since then, and
this was a micro benchmark, however this is definitely work considering.
-Sean
--
Sean Dague
Samsung Research America
s...@dague.net / sean.da...@samsung.com
http://dague.net
signature.asc
Description: OpenPGP digital signature
_______________________________________________ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
