Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

stable

Clone or download

Read-only

Add missing index on the plugin_oauth2_authorization table

Download Browse

The app_id column is used to filter the authorizations when deleting and app. Since there is only a composite index on (user_id, app_id) MySQL is forced to do a full scan to find the rows. This can be a source of slowness when deleting an app. Part of story #14541: have OAuth2 project admin Change-Id: Ibb6c2856cf0d61d3dc2bd249a6aae06ccb213c5b

+46 −1
Thomas Gerbet (tgerbet) 2020-03-17 15:08
Thomas Gerbet (tgerbet) 2020-03-17 15:12
02e099916a3386465b5436b82fc2e5cde9ec0087
db517fa12391e2d1d2181400ce40ce762236f154
git #tuleap/stable/02e099916a3386465b5436b82fc2e5cde9ec0087

Modified Files

Side by side diff
Inline diff
Name
M plugins/oauth2_server/db/install.sql +2 −1 Go to diff View file
A plugins/oauth2_server/db/mysql/2020/202003171500_add_app_id_index_oauth2_authorization_table.php +44 −0 Go to diff View file