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

Jay Pipes jaypipes at gmail.com
Mon Mar 3 14:48:31 UTC 2014


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





More information about the OpenStack-dev mailing list