Bug #90244 Contribution: Mirror acl_users Array with Map
Submitted: 28 Mar 2018 13:55 Modified: 27 Sep 2018 17:34
Reporter: OCA Admin (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[28 Mar 2018 13:55] OCA Admin
Description:
This bug tracks a contribution by Eric Herman (Github user: ericherman) as described in http://github.com/mysql/mysql-server/pull/201

How to repeat:
See description

Suggested fix:
See contribution code attached
[28 Mar 2018 13:55] OCA Admin
Contribution submitted via Github - Mirror acl_users Array with Map 
(*) Contribution by Eric Herman (Github ericherman, mysql-server/pull/201#issuecomment-375071994): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_176297087.txt (text/plain), 15.19 KiB.

[28 Mar 2018 14:50] Miguel Solorzano
Thank you for the contribution.
[30 Mar 2018 9:44] Eric Herman
see also BUG#88834
[20 Apr 2018 7:28] Eric Herman
I have rebased on 8.0.11 and updated to follow the Google C++ Style.

https://github.com/mysql/mysql-server/pull/203
[23 Apr 2018 17:02] OCA Admin
Contribution submitted via Github - Mirror acl_users Array with Map -- rebased on mysql-8.0.11 
(*) Contribution by Eric Herman (Github ericherman, mysql-server/pull/203#issuecomment-383278282): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_182979995.txt (text/plain), 16.42 KiB.

[8 May 2018 13:01] Mohammed Gaafar
perf top showing a lot of time spent in str_cmp while applying grants for several users.

Attachment: Screen Shot 2018-05-08 at 14.41.18.png (image/png, text), 490.90 KiB.

[27 Sep 2018 17:34] Paul Dubois
Posted by developer:
 
Fixed in 8.0.13.

Performance for locating user account entries in the in-memory
privilege structures has been improved. Thanks to Eric Herman for the
contribution.