Skip to:

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

getUsersIsAllowed in a large sites can result in terrible MySQL query performance

Description

Site has two sections and 150+ groups. Using MySQL 5.6. The query observed returns 152 results.

The old getSelectRealmRoleGroupUserIdSql seems to use a sub-query for no apparent reason.

Attaching screenshots showing query performance with two separate MySQL 5.6 instances.

Attachments

2

Activity

Show:
Fixed

Details

Priority

Affects versions

Fix versions

Components

Assignee

Reporter

Labels

Created October 16, 2016 at 1:56 PM
Updated April 25, 2018 at 3:19 PM
Resolved October 17, 2016 at 1:29 PM