:19
> To: Jesse Vincent
> Cc: rt-users
> Subject: Re: [rt-users] Certain RT operations painfully slow.
>
> On Tue, Jan 18, 2011 at 1:13 PM, Jesse Vincent
> wrote:
> > Todd,
> >
> >> >> Which causes this long running mysql query:
> >> >>
Understood. Thanks.
On Tue, Jan 18, 2011 at 1:45 PM, Jesse Vincent wrote:
>> RT version 3.6.3.
>
> You really need to come up to (at least) 3.8 for anyone here at BPS to
> be able to even hope to help you on this one. We've made many, many
> improvements to the codepaths you're touching. (To say
> RT version 3.6.3.
You really need to come up to (at least) 3.8 for anyone here at BPS to
be able to even hope to help you on this one. We've made many, many
improvements to the codepaths you're touching. (To say nothing of how
much we've cut down the size of the CachedGroupMembers table.)
Best
And here is the slow query for adding a new member to a group that is
AdminCc on a large number of tickets:
db: rt3
Command: Query
Time: 59
State: Sending data
Info: SELECT main.* FROM CachedGroupMembers main WHERE
((main.MemberId = 541915))
mysql> explain SELECT main.* FROM Cached
On Tue, Jan 18, 2011 at 1:13 PM, Jesse Vincent wrote:
> Todd,
>
>> >> Which causes this long running mysql query:
>> >>
>> >> Time: 86
>> >> Info: SELECT main.* FROM CachedGroupMembers main WHERE ((main.Via =
>> >> '28522070')) AND ((main.id != '28522070'))
>> >>
>> >> Can anyone recommen
Todd,
> >> Which causes this long running mysql query:
> >>
> >> Time: 86
> >> Info: SELECT main.* FROM CachedGroupMembers main WHERE ((main.Via =
> >> '28522070')) AND ((main.id != '28522070'))
> >>
> >> Can anyone recommend an approach to fixing this problem?
> >
> > What does an EXPLAI
Sorry, forgot the list.
Kenn
On Tue, Jan 18, 2011 at 9:55 AM, Kenneth Crocker wrote:
> Todd,
>
> I'm thinking this AdminCc group has a whole bunch of Global rights. That
> would do it.
>
> We did something similar but made it a bit more granular; we create a
> Global Group for AdminCc but only
On Tue, Jan 18, 2011 at 12:48 PM, Jesse Vincent wrote:
>
>
>
> On Tue, Jan 18, 2011 at 12:43:47PM -0500, Todd Chapman wrote:
>> RT Users,
>>
>> A few years ago we started adding a group as AdminCc to many tickets.
>> It made sense for our process and seemed like a good idea at the time.
>> Fast fo
On Tue, Jan 18, 2011 at 12:43:47PM -0500, Todd Chapman wrote:
> RT Users,
>
> A few years ago we started adding a group as AdminCc to many tickets.
> It made sense for our process and seemed like a good idea at the time.
> Fast forward to today. This group is AdminCc on many, many tickets.
> No
RT Users,
A few years ago we started adding a group as AdminCc to many tickets.
It made sense for our process and seemed like a good idea at the time.
Fast forward to today. This group is AdminCc on many, many tickets.
Now when we add a new member to the group it can take 15 minutes for
the add to
10 matches
Mail list logo