Support Questions

Find answers, ask questions, and share your expertise

How to limit Oozie database size?

avatar
Expert Contributor

Oozie Database size is growing at a rapid pace. It is currently @ 22gb but the customer would like to know how to limit the size of this db? and also looking for a procedure to archive old data so that it will never run of the space allocated. Can someone point me in the right direction to address this customer's concerns on Oozie Database size?

1 ACCEPTED SOLUTION

avatar
Master Mentor

@rbalam Oozie cleans up the database every 30 days by default, needless to say your customer should use an RDBMS like mysql and not derby in production. In latter case, you need to put derby on a large mount point, in case of RDBMS, all standard DBA practices apply.

View solution in original post

4 REPLIES 4

avatar
Master Mentor

@rbalam Oozie cleans up the database every 30 days by default, needless to say your customer should use an RDBMS like mysql and not derby in production. In latter case, you need to put derby on a large mount point, in case of RDBMS, all standard DBA practices apply.

avatar
Expert Contributor
@Artem Ervits

This customer is using mysql for Oozie but they are sharing it with other HDP components .. so what is the config to make the Oozie clean up data every 15 days? and also do we have a procedure if they want the old data in another database?

avatar
Master Mentor

here's mysql docs for oozie in hdp.

avatar
Master Mentor

@rbalam see this thread for property. Here's the whole list of properties you can look at.