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)