[
https://issues.apache.org/jira/browse/RANGER-4896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Madhan Neethiraj updated RANGER-4896:
-------------------------------------
Description:
Ranger records all logins to admin server in {{x_auth_sess}} table. This table
has foreign key reference to user record stored in {{x_portal_user}} table.
When a user is deleted in Ranger, all related records in {{x_auth_sess}} table
are deleted - which can take a long time if the user has large number of login
records in {{x_auth_sess}} table.
Removing foreign key references from {{x_auth_sess}} to {{x_portal_user}} table
will eliminate the need to remove {{x_auth_sess}} records when a user is
deleted - which can significantly reduce the time taken to delete users. In
addition, this can improve performance of user login as well. Also, it might be
desirable to retain login records even after deletion of users.
was:
Ranger records all logins to admin server in {{x_auth_sess}} table. This table
has foreign key reference to user record stored in {{x_portal_user}} table.
When a user is deleted in Ranger, all related records in {{x_auth_sess}} table
are deleted - which can take a long time if the user has large number of login
records in {{x_auth_sess}} table.
Removing foreign key references from {{x_auth_sess}} to {{x_portal_user}} table
will eliminate the need to remove {{x_auth_sess}} records when a user is
deleted - which can significantly reduce the time taken to delete users. In
addition, this can improve performance of user login as well.
> foreign key references to user table should be removed from login records
> table
> -------------------------------------------------------------------------------
>
> Key: RANGER-4896
> URL: https://issues.apache.org/jira/browse/RANGER-4896
> Project: Ranger
> Issue Type: Improvement
> Components: Ranger
> Reporter: Madhan Neethiraj
> Priority: Major
>
> Ranger records all logins to admin server in {{x_auth_sess}} table. This
> table has foreign key reference to user record stored in {{x_portal_user}}
> table.
> When a user is deleted in Ranger, all related records in {{x_auth_sess}}
> table are deleted - which can take a long time if the user has large number
> of login records in {{x_auth_sess}} table.
> Removing foreign key references from {{x_auth_sess}} to {{x_portal_user}}
> table will eliminate the need to remove {{x_auth_sess}} records when a user
> is deleted - which can significantly reduce the time taken to delete users.
> In addition, this can improve performance of user login as well. Also, it
> might be desirable to retain login records even after deletion of users.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
