[rt-devel] shredding users

Alex Vandiver alexmv at bestpractical.com
Fri Jul 18 13:25:08 EDT 2014


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


More information about the rt-devel mailing list