You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@sentry.apache.org by "Hadoop QA (JIRA)" <ji...@apache.org> on 2017/04/25 11:38:04 UTC
[jira] [Commented] (SENTRY-1488) Create scripts that DBA can use to
collect scale and usage stats
[ https://issues.apache.org/jira/browse/SENTRY-1488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15982741#comment-15982741 ]
Hadoop QA commented on SENTRY-1488:
-----------------------------------
Here are the results of testing the latest attachment
https://issues.apache.org/jira/secure/attachment/12831653/SENTRY-1488.0.patch against master.
{color:green}Overall:{color} +1 all checks pass
{color:green}SUCCESS:{color} all tests passed
Console output: https://builds.apache.org/job/PreCommit-SENTRY-Build/2560/console
This message is automatically generated.
> Create scripts that DBA can use to collect scale and usage stats
> ----------------------------------------------------------------
>
> Key: SENTRY-1488
> URL: https://issues.apache.org/jira/browse/SENTRY-1488
> Project: Sentry
> Issue Type: New Feature
> Components: Sentry
> Affects Versions: 1.8.0
> Reporter: Anne Yu
> Assignee: Anne Yu
> Attachments: SENTRY-1488.0.patch, stats-1.png, stats-2.png
>
>
> We could create a script/tool subfolder so that can add side tools into it. For example, we could simply create a script that gives us a row count of every table in the Sentry database, plus the same thing for every table in the Hive Metastore database. That will give us info like: total number of tables, total number of roles, total permissions, etc.
> To start with:
> {code}
> #Roles
> #Permissions
> #Groups
> #Permissions per Role: avg, medium and max
> #Roles per Permission: avg, medium and max
> #Groups per role: avg, medium and max
> #Roles per group: avg, medium and max
> #Databases
> #Tables
> #Views
> #Partitions
> #Tables per Database: avg, medium and max
> #Views per Database: avg, medium and max
> #Partitions per Table: avg, medium and max
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)