> Most probably, 4.1 gens good plan for this.
It just occurred to me that this seems to have started since I added the
extra indexes for the Shredder - is that possible? It is actually
possible to have "conflicting" indexes? Here are the indexes I added:
CREATE INDEX SHRD_CGM1 ON CachedGroupMem
It's happening all the time now for some reason. This is really odd - it
just seems to have started - here's a typical example - state is
"Copying to tmp table" during the execution:
# Time: 070406 17:25:05
# [EMAIL PROTECTED]: rt_user[rt_user] @ localhost []
# Query_time: 38 Lock_time: 0 Rows_s
On Apr 7, 2007, at 12:53 AM, Philip Kime wrote:
"Rows_sent: 288 ", So it's not that large group, but "Rows_examined:
54167891" wwhat is really wierd.
Yeah. MySQL 5?
5.0.27. It is intermittent - first time I've seen it was yesterday.
Still using SearchBuilder 1.43 on that box.
Hey Todd,
> "Rows_sent: 288 ", So it's not that large group, but "Rows_examined:
> 54167891" wwhat is really wierd.
>Yeah. MySQL 5?
5.0.27. It is intermittent - first time I've seen it was yesterday.
Still using SearchBuilder 1.43 on that box.
PK
___
http://li
At Thursday 4/5/2007 09:14 PM, Philip Kime wrote:
Hmm - not that I know of - we don't have that many users, even if
they could all own tickets, it would be about 1300 users. Is that
large enough to be a problem?
Philip,
A quick check would be to remove the owner drop-down and see if
things s
On 4/6/07, Jesse Vincent <[EMAIL PROTECTED]> wrote:
On Apr 6, 2007, at 9:15 PM, Ruslan Zakirov wrote:
> On 4/6/07, Jesse Vincent <[EMAIL PROTECTED]> wrote:
>>
>>
>> On Apr 6, 2007, at 8:05 AM, Philip Kime wrote:
>>
>> Strangely, our RT server has suddenly started being really slow
>> loading up
On Apr 6, 2007, at 9:15 PM, Ruslan Zakirov wrote:
On 4/6/07, Jesse Vincent <[EMAIL PROTECTED]> wrote:
On Apr 6, 2007, at 8:05 AM, Philip Kime wrote:
Strangely, our RT server has suddenly started being really slow
loading up
the search page and running searches - the same query is logged i
On 4/6/07, Jesse Vincent <[EMAIL PROTECTED]> wrote:
On Apr 6, 2007, at 8:05 AM, Philip Kime wrote:
Strangely, our RT server has suddenly started being really slow loading up
the search page and running searches - the same query is logged in the
slow-log every time - any ideas:
Likely you gran
On Apr 6, 2007, at 10:14 AM, Philip Kime wrote:
Hmm - not that I know of - we don't have that many users, even if
they could all own tickets, it would be about 1300 users. Is that
large enough to be a problem? Normally the Owner list is less than
100 users so I could check if someone did s
Hmm - not that I know of - we don't have that many users, even if they
could all own tickets, it would be about 1300 users. Is that large
enough to be a problem? Normally the Owner list is less than 100 users
so I could check if someone did something. It seems back to normal now
though ...
I noti
On Apr 6, 2007, at 8:05 AM, Philip Kime wrote:
Strangely, our RT server has suddenly started being really slow
loading up the search page and running searches - the same query is
logged in the slow-log every time - any ideas:
Likely you granted some large group of users the right to own t
down to a input field could help, but I didn't tried
it till now.
Torsten
-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: rt-users@lists.bestpractical.com
Sent: Fri Apr 06 01:05:30 2007
Subject: [rt-users] Really slow Search page startup suddenly
Strangel
Strangely, our RT server has suddenly started being really slow loading
up the search page and running searches - the same query is logged in
the slow-log every time - any ideas:
# Time: 070405 16:01:56
# [EMAIL PROTECTED]: rt_user[rt_user] @ localhost []
# Query_time: 38 Lock_time: 0 Rows_sent
13 matches
Mail list logo
