[jira] [Created] (RANGER-4246) Performance Optimizations for deleting large number of users/groups

["Abhishek Kumar (Jira)" <ji...@apache.org>]

Abhishek Kumar created RANGER-4246:
--------------------------------------

             Summary: Performance Optimizations for deleting large number of users/groups
                 Key: RANGER-4246
                 URL: https://issues.apache.org/jira/browse/RANGER-4246
             Project: Ranger
          Issue Type: Improvement
          Components: Ranger
    Affects Versions: 2.4.0
            Reporter: Abhishek Kumar
            Assignee: Abhishek Kumar


RANGER-4230 includes changes to significantly improve the running time for user/group deletes when there are large number of users/groups in ranger. Typically operations like deleting external users/groups are supposed to be performed in a maintenance window. 

However, even after changes in RANGER-4230 go through, in the worst case the running time can still be in the order of several minutes or may be a few hours. To further bring down the time to best achievable running times, ranger db schema changes are required with ON DELETE CASCADE and ON DELETE NULL in the relevant db tables. This Jira tracks the work regarding the same. 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)