At some point in the past, our RT has had a pretty serious flurry of
spam, and as a result, I have 201K rows in Principals, 145K+ in each of
Groups and GroupMembers, and 450K rows in CachedGroupMembers. These seem
like pretty high numbers to me (we probably have somewhere around 2-300
active users, at most).
Recently I tried loading the database dump into a new database, and it
took 31 hours, which is a little concerning.
Does anyone already have a tool like RTx-Shredder to remove "orphaned"
Principals, and their associated junk? I guess the requirement is
Requestors who are only associated with deleted tickets, or no tickets
Equally, the sessions table has entries going back to 2003 in it - is
that normal? Shouldn’t they expire?