Re: [rt-users] rtx-shredder mysql optimization

2008-04-01 Thread Ruslan Zakirov
http://search.cpan.org/~ruz/RTx-Shredder-0.07/lib/RTx/Shredder.pm#Database_indexes On Wed, Apr 2, 2008 at 5:02 AM, Alex Moura <[EMAIL PROTECTED]> wrote: > Hello, > > I'd like to ask the mysql experts for any tips that would help improving > rtx-shredder performance. > > There database are already

Re: [rt-users] rtx-shredder mysql optimization

2008-04-01 Thread Alex Moura
Another bit of information about the issue that may help is the following "top" display, _during_ a rtx-shredder running and after it finished: The next "top" output was captured with a running rtx-shredder (removing a single ticket): -- last pid: 51170; load averages: 0.

[rt-users] rtx-shredder mysql optimization

2008-04-01 Thread Alex Moura
Hello, I'd like to ask the mysql experts for any tips that would help improving rtx-shredder performance. There database are already has indexes in an attempt to improve the performence: CREATE INDEX objectcf_type_id on ObjectCustomFieldValues(Objectid, ObjectType); CREATE INDEX acl_type_id on A