Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Performance regression when Authenticating

Description

8.0.30 shows a noticeable performance regression when authenticating. Please check the mysqlslap output below:

P_S shows exclusive locks around the ACL cache while the workload is read only.

Threads stall around the ACL cache lock.

P_S points to the line 3852 on sql_auth_cache.cc file, which belongs to the function Acl_cache_lock_guard.

I don't see any new commit around this code. Maybe it's related to the new LDAP features on this version.

Customers also reported complete MySQL stalls around the ACL cache when the connection is already established. Unfortunately, I was not able to reproduce this behavior with already connected threads.

 

Environment

None

AFFECTED CS IDs

CS0033330

Activity

Show:

Yura Sorokin February 16, 2023 at 4:14 PM

Done

Assignee

Reporter

Needs Review

Needs QA

Fix versions

Priority

Created January 30, 2023 at 11:37 PM
Updated March 6, 2024 at 9:49 AM
Resolved February 16, 2023 at 4:14 PM