DB too large

RT Users
1

Hello,

I’ve been using request tracker for about a year now and it is working great.
However, over the last few months it seems the MySQL db is starting to get
too large. Is there anyway to automatically purge the DB of e-mails beyond
a certain age?

Thanks,
Ilan

2

Hello,

I’ve been using request tracker for about a year now and it is working great.
However, over the last few months it seems the MySQL db is starting to get
too large. Is there anyway to automatically purge the DB of e-mails beyond
a certain age?

Warning: This is applicable to RT2.

I know there are other ways, but you can use the Search utility to list all
tickets created before some_date, then use “Update all tickets at once” to
change status to “dead”, then use one of the utilities out there that purge
deleted tickets. I have attached one here.

    cheers
   - wash

Odhiambo Washington . WANANCHI ONLINE LTD (Nairobi, KE) |
. 1ere Etage, Loita Hse, Loita St., |
GSM: (+254) 722 743 223 . # 10286, 00100 NAIROBI |
GSM: (+254) 733 744 121 . (+254) 020 313 985 - 9 |
“Oh My God! They killed init! You Bastards!”
–from a /. post

purge-dead.pl (2.21 KB)

3

Are there similar utils for RT3? I think purging the deleted spam messages
alone would speed things up a lot. Last I checked the Request Tracker
database was over 300MB.

Thanks,
IlanOn Mon, Dec 15, 2003 at 03:32:03PM +0300, Odhiambo Washington wrote:

Hello,

I’ve been using request tracker for about a year now and it is working great.
However, over the last few months it seems the MySQL db is starting to get
too large. Is there anyway to automatically purge the DB of e-mails beyond
a certain age?

Warning: This is applicable to RT2.

I know there are other ways, but you can use the Search utility to list all
tickets created before some_date, then use “Update all tickets at once” to
change status to “dead”, then use one of the utilities out there that purge
deleted tickets. I have attached one here.

    cheers
   - wash

±---------------------------------±----------------------------------------+
Odhiambo Washington . WANANCHI ONLINE LTD (Nairobi, KE) |
. 1ere Etage, Loita Hse, Loita St., |
GSM: (+254) 722 743 223 . # 10286, 00100 NAIROBI |
GSM: (+254) 733 744 121 . (+254) 020 313 985 - 9 |
±--------------------------------±-----------------------------------------+
“Oh My God! They killed init! You Bastards!”
–from a /. post

Ilan Rabinovitch
ilan@fonz.net E-MAIL

The Southern California Llnux Expo: “Bringing businesses, academic institutions and the Linux community together in a way that no other conference does!” – http://www.socallinuxexpo.org