Anne Yu created SENTRY-1488:
-------------------------------
Summary: 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, sentry-ha-redesign
Reporter: Anne Yu
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.4#6332)
