[rt-users] delete_dead_tickets.pl

[Greg Dickerson]

Steve's script saved my ass and my DB :-). Here is a modified version of his script to do cleanup on very large MySQL DB's.

Don't forget to add those index's

**** snip sent to Steve ****
Steve,
    Thank you for putting together the delete dead tickets script. I found
that on our system (a really slow one) that the script took over 24 hours to
delete 3-4 thousand records so I asked one of our Perl/MySQL programmers to
check out the code. They made the edits you see in the attachment. We also
added indexes on the tables that matched the where clause. With the edits
and indexes it rips trough a few thousand records in minutes. Hope you will
find the edit satisfactory.

******

Here is a link to his original script also.

> http://dev.inet-technologies.com/rt2/



Greg
--------
Greg Dickerson
Support Manager
O'Reilly & Associates, Inc.
1005 Gravenstein Highway North
Sebastopol, CA  95472
Phone:(707)827-7215


----- Original Message -----
From: "Carles Amigó" <carles at inlander.es>
To: <rt-users at lists.fsck.com>
Sent: Wednesday, November 14, 2001 8:29 AM
Subject: [rt-users] delete_dead_tickets.pl


> Where can i find the Steve Poirier's delete_dead_tickets.pl script?
>
> I have been looking the list archives, and i want to delete some old
> tickets to minimize the database size.
>
> Thanks
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Cleanup-Dead.zip
Type: application/x-zip-compressed
Size: 1141 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20011114/6532293b/attachment.bin>