[rt-users] DB Growth

[Jeff Stark]

Thanks Forrest,

We found that there were a couple of tickets where (somehow) the
requestor had attached the same file (roughly 5MB) over 100 times.

Thanks, 

- Stark



-----Original Message-----
From: Forrest Blount [mailto:forrest at itasoftware.com] 
Sent: Friday, June 29, 2007 4:40 PM
To: Jeff Stark
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] DB Growth

Check to see if a scrip is caught in a loop sending/adding attachments
to your tickets (and your db).

Forrest

Jeff Stark wrote:
> Can anyone explain why we are seeing exponential growth in our 
> "Attachments" table?
>
> It appears to be related to emails sent by the system, but looking for

> more concise explanation.
>  
> We only have approximately 5000 tickets yet our Attachments table (we 
> don't have actual attachments enabled) is growing significantly to
8GB.
>  
> Thanks,
>  
>
> *-Stark*
>
> ----------------------------------------------------------------------
> --
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com Commercial support: 
> sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com