Huge Attachments.MYD file

RT Users
1

Hey everyone,

Just curious…my attachements.myd file in my mysql database is getting to
be rather huge…any ideas on pruning it to make it smaller?

Thanks!

-Rob.

2

delete tickets that contain viruses.

3

Thanks, tips.

We don’t have any of those. Next idea?

4

ummmmm… you sure?

tip 1 ) live with it.
tip 2 ) you sure you don’t have any viruses?

Mat

-----Original Message-----
From: Rob Mitzel [mailto:rmitzel@peer1.net]
Sent: Wednesday, 1 May 2002 2:08 AM
To: Matthew Watson; rt-users@lists.fsck.com
Subject: RE: [rt-users] Huge Attachments.MYD file

Thanks, tips.

We don’t have any of those. Next idea?

-----Original Message-----
From: rt-users-admin@lists.fsck.com
[mailto:rt-users-admin@lists.fsck.com]On Behalf Of Matthew Watson
Sent: April 29, 2002 3:14 PM
To: Rob Mitzel; rt-users@lists.fsck.com
Subject: RE: [rt-users] Huge Attachments.MYD file

delete tickets that contain viruses.

-----Original Message-----
From: rt-users-admin@lists.fsck.com
[mailto:rt-users-admin@lists.fsck.com]On Behalf Of Rob Mitzel
Sent: Tuesday, 30 April 2002 3:26 AM
To: rt-users@lists.fsck.com
Subject: [rt-users] Huge Attachments.MYD file

Hey everyone,

Just curious…my attachements.myd file in my mysql database is
getting to
be rather huge…any ideas on pruning it to make it smaller?

Thanks!

-Rob.

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm

5

I would offer the following:

perhaps you do not have viruses, but you might have spam, or people with
HTML mail, who automatically send a large image (like their vCard,
business card, whatever) with every file. I would spend maybe 15 minutes
looking at tickets and see if there are any that have large attachments.
I don’t know if there’s an easy way to search for this (there isn’t in the
web application, but maybe through your database there’s an easy query).
I’d be willing to bet that someone in your department is sending out
images, or forwarded spam complaints or somethign have large attachments.

Sheeri Kritzer
Systems Administrator
University Systems Group
Tufts University
617-627-3925
sheeri.kritzer@tufts.edu

6

At 5/1/2002 10:37 AM, you wrote:

I don’t know if there’s an easy way to search for this (there isn’t in the
web application, but maybe through your database there’s an easy query).

Using RT 2-0-13 w/ MySql… try this query. Should give you all attachments
and the ticket # associated, sorted by attachment size.

select b.Ticket,a.Filename,length(a.Content) as attachsz from Attachments
a, Transactions b where a.TransactionId=b.id and length(a.Content) is not
null order by attachsz desc;

Now the kicker here is that you’ll know where the pigs in your database are
– but is there a clean and easy way to delete them? My present guess is
there is not. (Clean and easy here refer to a technique that RT would
provide and Jesse wouldn’t frown on.)

Hope this helps

–D

7

At 5/1/2002 10:37 AM, you wrote:

I don’t know if there’s an easy way to search for this (there isn’t
in the web application, but maybe through your database there’s an
easy query).

Using RT 2-0-13 w/ MySql… try this query. Should give you all
attachments and the ticket # associated, sorted by attachment size.

select b.Ticket,a.Filename,length(a.Content) as attachsz from
Attachments a, Transactions b where a.TransactionId=b.id and
length(a.Content) is not null order by attachsz desc;

Now the kicker here is that you’ll know where the pigs in your
database are – but is there a clean and easy way to delete them?
My present guess is there is not. (Clean and easy here refer to a
technique that RT would provide and Jesse wouldn’t frown on.)

Betcha could replace them with something of very small length (like the
string ‘deleted’).

-Robin

Robin Powell's Old Home Page BTW, I’m male, honest.
le datni cu djica le nu zifre .iku’i .oi le so’e datni cu to’e te pilno
je xlali – RLP http://www.lojban.org/