[openstack-dev] [all][keystone] Increase of USER_ID length maximum from 64 to 255

Dolph Mathews dolph.mathews at gmail.com
Mon Mar 3 17:37:24 UTC 2014


On Mon, Mar 3, 2014 at 8:48 AM, Jay Pipes <jaypipes at gmail.com> wrote:

> On Sun, 2014-03-02 at 12:05 -0800, Morgan Fainberg wrote:
> > Having done some work with MySQL (specifically around similar data
> > sets) and discussing the changes with some former coworkers (MySQL
> > experts) I am inclined to believe the move from varchar  to binary
> > absolutely would increase performance like this.
> >
> >
> > However, I would like to get some real benchmarks around it and if it
> > really makes a difference we should get a smart "UUID" type into the
> > common SQLlibs (can pgsql see a similar benefit? Db2?) I think this
> > conversation. Should be split off from the keystone one at hand - I
> > don't want valuable information / discussions to get lost.
>
> No disagreement on either point. However, this should be done after the
> standardization to a UUID user_id in Keystone, as a separate performance
> improvement patch. Agree?
>
> Best,
> -jay
>
>
>
++ https://blueprints.launchpad.net/keystone/+spec/sql-id-binary-16


>
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20140303/685adcb3/attachment.html>


More information about the OpenStack-dev mailing list