Rt-shredder - quicker method?

Hi All,

I’ve got an RT system (3.8) with a database 50G, and around 500k of tickets. I’m using rt-shredder to delete tickets older than 2 years, and it’s taken about 2 days to delete around 20k. I estimate it will take around 30 days to complete.

Is there any way to speed up the process? I toyed with the idea of deleting the tickets manually and using rt-validator to correct the database but I feel this might be a step too far…?

Thanks
Tim

Timothy Arnold
Senior Engineer, Operations (Network, Security & Facilities Group), UKSolutions

Telephone: 0845 004 1333, option 2
Email: timothy.arnold@uksolutions.co.uk
Web: http://www.uksolutions.co.uk/
UKS Ltd, Birmingham Road, Studley, Warwickshire, B80 7BG Registered in England Number 3036806
This email must be read in conjunction with the legal & service notices on http://www.uksolutions.co.uk/disclaimer

Hello,

In additon to indexes described in shredder documentation people
suggested index on Via column in CachedGroupMembers table and said
that it improves performance amazingly.On Wed, Jun 24, 2009 at 8:32 PM, Timothy Arnoldtimothy.arnold@uksolutions.co.uk wrote:

Hi All,

I’ve got an RT system (3.8) with a database 50G, and around 500k of tickets. I’m using rt-shredder to delete tickets older than 2 years, and it’s taken about 2 days to delete around 20k. I estimate it will take around 30 days to complete.

Is there any way to speed up the process? I toyed with the idea of deleting the tickets manually and using rt-validator to correct the database but I feel this might be a step too far…?

Thanks
Tim

Timothy Arnold
Senior Engineer, Operations (Network, Security & Facilities Group), UKSolutions

Best regards, Ruslan.

Ruslan Zakirov <ruslan.zakirov gmail.com> writes:

Hello,

In additon to indexes described in shredder documentation people
suggested index on Via column in CachedGroupMembers table and said
that it improves performance amazingly.

Has anyone else noticed a marked delay in the Query Builder search page after
adding the recommended indexes? Where it used to display in less than ~5
seconds, it’s now averaging ~16 seconds.

What have I managed to break, now?

Simon

I’m pretty sure you have a slow query in the log of slow queries.

It happens on mysql when version of the server is older than 5.0.45,
cuz a query RT runs to build owners may slowdown because of mysql’s
optimizer bug. Even on 5.0.45+ some indexes changes may be required to
improve situation.

If you’re not eperienced in optimizing mysql then you can drop indexes
on CachedGroupMembers table that starts from MemberId column.On Mon, Jun 29, 2009 at 4:47 PM, Simon Jestersklutch@hostile.org wrote:

Ruslan Zakirov <ruslan.zakirov gmail.com> writes:

Hello,

In additon to indexes described in shredder documentation people
suggested index on Via column in CachedGroupMembers table and said
that it improves performance amazingly.

Has anyone else noticed a marked delay in the Query Builder search page after
adding the recommended indexes? Where it used to display in less than ~5
seconds, it’s now averaging ~16 seconds.

What have I managed to break, now?

Simon


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

In additon to indexes described in shredder documentation people
suggested index on Via column in CachedGroupMembers table and said
that it improves performance amazingly.

Adding an index on the Via column has significantly increased the performance. For the record I ran:

CREATE INDEX SHREDDER_CGM3 ON CachedGroupMembers(Via);

Thanks for the tip!
Tim

Timothy Arnold
Senior Engineer, Operations (Network, Security & Facilities Group), UKSolutions

Telephone: 0845 004 1333, option 2
Email: timothy.arnold@uksolutions.co.uk
Web: http://www.uksolutions.co.uk/
UKS Ltd, Birmingham Road, Studley, Warwickshire, B80 7BG Registered in England Number 3036806
This email must be read in conjunction with the legal & service notices on http://www.uksolutions.co.uk/disclaimer