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)
• Status: Closed
• Category: MySQL Server: DML
• Severity: S3 (Non-critical)
• OS: Any
• 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] MySQL Verification Team

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.