Shredder for requestors?

Hi,

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
at all.

Equally, the sessions table has entries going back to 2003 in it - is
that normal? Shouldn’t they expire?

Best Regards,

Howard

Greetings!

Howard Jones wrote:

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
at all.
I’d like to have a tool like it too. Someone got it?

Equally, the sessions table has entries going back to 2003 in it - is
that normal? Shouldn’t they expire?
http://wiki.bestpractical.com/index.cgi?CleanupSessions

SY, Danial.

Danial Klimkin,
Falk eSolutions AG Russia

Danial Klimkin wrote:

Greetings!

Howard Jones wrote:

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 at all.

I’d like to have a tool like it too. Someone got it?

I plan continue Shredder development in the near future. This is not
easy to clear users and be sure that you didn’t break RT because almost
all tables depend on users table.
also shredder require test suite to be writen, in other case you can’t
be sure it does delete only data you requested.

Patches are wellcome.

Best regards, Ruslan.