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)