Re: shredding users
Alex Vandiver <[email protected]>
| Newsgroups | gmane.comp.bug-tracking.request-tracker.devel |
|---|---|
| Organization | Best Practical Solutions, LLC |
| Message-ID | <[email protected]> |
On 07/18/2014 04:23 AM, Christian Loos wrote: > attached some details on query times and index creation. > > Without this index shred the user with the WebUI results in killing > mysqld in my case. Shred the user with sbin/rt-shredder takes constantly > 30 minutes due to the Attachments query. > After creating the index shred a user with the WebUI takes 1 minute. > > I think you should highly recommend the index in the shredder > documentation or even think about adding this index for all users. I've added this index to the list of suggested indexes in the shredder documentation (commit 3d7e596 on 4.0-trunk); we'll discuss if it makes sense to apply more generally. - Alex -- RT Training - Boston, September 9-10 http://bestpractical.com/training