Re: [rt-users] Really slow Search page startup suddenly

2007-04-06 Thread Ruslan Zakirov
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

Re: [rt-users] Really slow Search page startup suddenly

2007-04-06 Thread Jesse Vincent
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 in

Re: [rt-users] Really slow Search page startup suddenly

2007-04-06 Thread Ruslan Zakirov
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 the search

RE: [rt-users] Really slow Search page startup suddenly

2007-04-06 Thread Stephen Turner
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

RE: [rt-users] Really slow Search page startup suddenly

2007-04-06 Thread Philip Kime
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

Re: [rt-users] Really slow Search page startup suddenly

2007-04-05 Thread Jesse Vincent
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

RE: [rt-users] Really slow Search page startup suddenly

2007-04-05 Thread Philip Kime
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

Re: [rt-users] Really slow Search page startup suddenly

2007-04-05 Thread Jesse Vincent
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