Database Cleanup Inquiry for Kill Bill

[Pardos Dedondo]

Good morning,

We are currently experiencing high operational activity and extensive usage of Kill Bill. As a result, the database size is growing significantly.

We would like to ask whether it is possible to perform cleanup operations on the following tables:

• audit_log
• bus_events_history
• invoice_billing_events
• bus_ext_events_history
• payment_attempt_history
• payment_attempts
• subscription_events
• invoice_items
• subscription_event_history
• subscriptions
• subscription_history
• payment_transaction_history

From our understanding, the *_history tables may be easier to clear, although we would appreciate your confirmation on this point. For the other tables, the process appears to be more complex.

If it is confirmed that a full cleanup is not feasible, could you please advise on how to safely perform data retention or archival strategies to reduce table sizes without compromising Kill Bill’s functionality?

Thank you in advance for your support.

Best regards,

Pardos

[karan bansal]

Hi Pardos,

Let me find more details about history tables and get back to you. 

In the meantime, could you confirm if you have any old accounts that can be removed. We do have an available Db proc to clear out old accounts. 

Regards

Karan

[Pardos Dedondo]

Hi,

Thanks for your reply. Unfortunately, we cannot deleted old accounts. We'll wait for your check about other tables.

Best regards,

Pardos