[rt-users] Rtx::Shredder: Indexes for Performance improvements on deleting Tickets

Dirk Pape pape-rt at inf.fu-berlin.de
Wed Apr 11 11:25:21 EDT 2007


using Shredder Version 0.6 with

rtx-shredder --plugin "Tickets=limit,50;status,deleted;updated_before,`date 
-I -d '1 month ago'`" --force

I added the following indexes, that improved purging deleted Tickets from 3 
hours to one minute.

on Transactions:

  KEY `Shredder` (`ReferenceType`,`OldReference`,`NewReference`),
  KEY `Shredder2` (`Type`,`OldValue`,`NewValue`),
  KEY `Transaction Order Created` (`Created`)

on CachedGroupMembers:

  KEY `Shredder` (`Via`)

may help some others if this is not already folklore.

Dr. Dirk Pape (eAS - Projektleitung Campus Management)
Freie Universitaet Berlin
Grunewaldstr. 34a, 12165 Berlin
Tel. +49 (0)30 838 75143, Fax. +49 (0)30 838 54654

More information about the rt-users mailing list