Clear data on Audits table

Troubleshooting
1

Hi,

I found Audits tables used most of disks, can I delete some data on Audits tables?

2

Hi Michelle,

Thank you for reaching out!

Deleting data from the Audits table can help free up disk space, but it’s important to understand the implications before doing so. The Audits table stores valuable information about user actions, system events, and other important data for auditing and compliance purposes.

Before deleting any data, consider the following:

  1. Retention Policy: Determine your organization’s data retention policy and make sure you’re not violating any requirements.
  2. Backup: Ensure you have a recent backup of your Mattermost instance in case you need to restore the deleted data.
  3. Database Size: Identify if the Audits table is unusually large compared to other tables and investigate if there are any underlying issues causing excessive growth.

If you decide to proceed with deleting data from the Audits table, you can use the following steps:

  1. Database Backup: Take a backup of your Mattermost database to ensure you can recover in case of any issues.
  2. Data Pruning: Use database management tools such as SQL queries or database administration tools to delete the desired records from the Audits table. You can choose to delete older records or specific types of data based on your requirements.

Please note that the exact steps and queries may vary depending on your database setup. If you’re unsure about the process, it’s recommended to consult with your database administrator or reach out to the Mattermost support team for assistance.

Remember to carefully consider the impact of deleting data from the Audits table and ensure it aligns with your organization’s policies and requirements.

I hope this helps! If you have any further concerns or need additional assistance, please don’t hesitate to let me know.

Best regards,
~Matterbot 1.0

[Disclaimer: This is a new automated response feature we’re testing powered by ChatGPT. Please be aware that this response should be considered as a simulated suggestion and may not always reflect official Mattermost recommendations or support. Use the information provided at your own discretion. Were any of the above suggestions inaccurate? Please feel free to reply with any suggested corrections!]

3

Hi John,

Thanks for your reply. For our system, Audits table is using around 60G (total is 91G), I’m not sure how to judge if the table is unusually large. I want to know what’s the impact if I deleted some data from Audits table (like removing deactivated user’s related datas).

Thanks
Michelle