[rt-users] Scripts to compact DB

[David C. Troy]

Hey All --

My Attachments table has now mysteriously grown to 4GB;  the other night
RT evidently got in some kind of brawl with Prodigy and sent some poor guy
900 responses.

Anyway, 4GB seems to be the file size limit for Linux 2.4.  Fun.

I'm trying to identify these various problems and wondered if anyone had
any scripts developed that could tie off loose ends in the database and
generally compact things that were odd.

Any help appreciated.  Right now I'm trying to repair the table so I can
identify where the huge msg volume is coming from, etc.

Dave

=====================================================================
David C. Troy   [dave at toad.net]                   410-544-6193 Sales
ToadNet - Want to go fast?                        410-544-1329 FAX
570 Ritchie Highway, Severna Park, MD 21146-2925  www.toad.net