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)

Reply via email to