[
https://issues.apache.org/jira/browse/RANGER-4907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Subhrat Chaudhary updated RANGER-4907:
--------------------------------------
Description:
If a user has large number of associations with groups, policies, the user
delete operation can take large amount of time, especially while updating the
policies. Since to update a policy, we have large number of validations in
place. This can be even worse, if multiple user delete requests are received at
the same time. We can add following optimizations to improve the user delete
performance:
* Remove foreign key relation of x_user with x_auth_sess, with this we can
skip updating the user references in x_auth_sess when a user is deleted.
* Currently all policy reference for a user are cleaned up and updated ones
are added again. We can remove policy reference only for the user being deleted.
* Add new policy update method, take list of policies, update only the
policyText and push policy updates in bulk.
was:
If a user has large number of associations with groups, policies, the user
delete operation can take large amount of time, especially while updating the
policies. Since to update a policy, we have large number of validations in
place. This can be even worse, if multiple user delete requests are received at
the same time. We can add following optimizations to improve the user delete
performance:
* Remove foreign key relation of x_user with x_auth_sess, with this we can
skip updating the user references in x_auth_sess when a user is deleted.
* Currently all policy reference for a user are cleaned up and updated ones
are added again. We can remove policy reference only for the user being deleted.
> Optimize user and group delete operation
> ----------------------------------------
>
> Key: RANGER-4907
> URL: https://issues.apache.org/jira/browse/RANGER-4907
> Project: Ranger
> Issue Type: Improvement
> Components: admin
> Reporter: Subhrat Chaudhary
> Assignee: Subhrat Chaudhary
> Priority: Major
>
> If a user has large number of associations with groups, policies, the user
> delete operation can take large amount of time, especially while updating the
> policies. Since to update a policy, we have large number of validations in
> place. This can be even worse, if multiple user delete requests are received
> at the same time. We can add following optimizations to improve the user
> delete performance:
> * Remove foreign key relation of x_user with x_auth_sess, with this we can
> skip updating the user references in x_auth_sess when a user is deleted.
> * Currently all policy reference for a user are cleaned up and updated ones
> are added again. We can remove policy reference only for the user being
> deleted.
> * Add new policy update method, take list of policies, update only the
> policyText and push policy updates in bulk.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
