Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

nav_audit grows quite large in size as compared to other databases under CM

avatar
Explorer

Hi,

 

We have seen few of our clusters getting affected because ibdata1 under mysql grows too large to occupy all the disk. On further checking it was nav_audt DB under CM databases which occupied all the space. Could this be because of BDR setup in the environment and if thats the case how can this be avoided. As a workaround,we are just changing the retention period for nav audits in CM.

 

Thanks

Pravdeep

1 ACCEPTED SOLUTION

avatar
Explorer

Hi,

 

Thanks for your response, we eventually found out the reason upon checking the tables under nav_audit database which were loaded with getfacl records under them. We changed the regex to avoid logging getfacls and decreased the timepeiord to retain nav audits to 30 instead of 90(default) to bring down the disk usage of this database.

 

 

Thanks & Regards

Pravdeep

View solution in original post

4 REPLIES 4

avatar
Contributor

Hi Praveep,

Disk usage on Navigator audit is based on the audit events occurring in the cluster as a whole, and BDR will only contribute a select percentage of this (the exact value will differ between environments). Typically Navigator audit/metadata disk usage is many times greater than other Cloudera Manager Management components and you should provision disk space accordingly. Please see our documentation for additional assistance scoping your disk requirements, and for the components which contribute audits:

http://www.cloudera.com/documentation/enterprise/latest/topics/cm_ig_reqs_space.html

 

Thanks,

MJ

avatar
Explorer

Hi,

 

Thanks for your response, we eventually found out the reason upon checking the tables under nav_audit database which were loaded with getfacl records under them. We changed the regex to avoid logging getfacls and decreased the timepeiord to retain nav audits to 30 instead of 90(default) to bring down the disk usage of this database.

 

 

Thanks & Regards

Pravdeep

avatar
New Contributor

Hi, 

Could you please provide the steps.

 

Thanks 

 

 

 

avatar
Contributor

Hi Pravi,
Please review the documentation here: https://docs.cloudera.com/documentation/enterprise/latest/topics/cn_admcfg_audit_filters.html

 

and let us know if you have any questions.

 

Thanks,

MJ