Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,369,457
Community Members
 
Community Events
168
Community Groups

SQL Server table sizes

Edited

Hi All,

Our sql database has gotten quite large and on checking the table sizes we've found that the following table AO_544E33_AUDIT_LOG_ENTRY is taking up the majority of the space. 

Currently the JIRA.MBF file size is 32GB and the table size is 20GB.

It lists comms going back to the creation of our Jira instance. 

Can this table be truncated?

Many thanks

Tom

2 answers

1 accepted

4 votes
Answer accepted
Tuncay Senturk Community Leader Sep 08, 2022

Hi @Tom Vines 

Those tables starting with AO_ are the tables which are used by plugins. As far as I know, AO_544E33 is the prefix for Email this Issue (JETI) plugin.

Since it says AUDIT_LOG, probably it will be ok to back up the table and truncate but I'd clearly recommend checking the plugin's documentation or raising the team a ticket and then moving forward.

I hope it helps!

Hi @Tuncay Senturk ,

Thanks for your response.  Yeah found the settings in Email This Issue so need to discuss the time period to keep!

Many thanks

Tom

Ah this is an feature with Email This Issue

Tuncay Senturk Community Leader Sep 08, 2022

I think yes, just raise them a ticket and see what they say

Suggest an answer

Log in or Sign up to answer