Hello,
--Am 18. November 2007 22:17:42 +0300 schrieb Ruslan Zakirov
[EMAIL PROTECTED]:
Script creates schema and data. The following query must use range
search for the second table instead of 'ref'.
so this is from our site:
Reading table information for completion of table and column
ticket search page becoming a problem
Heya, guys.
Finally I found some time to test this problem on mysql 5.0 and even
has writen a script to reproduce it, but it showed that mysql 5.0.45
has no this bug. My script and doogles helped me to prove that it
really works as expected. So I really
Script creates schema and data. The following query must use range
search for the second table instead of 'ref'.
SELECT STRAIGHT_JOIN g.id FROM acl a, grp g WHERE
g.type = a.type
AND (
( g.domain = 'RT::Ticket-Role' AND g.instance = 10 )
OR ( g.domain = 'RT::Queue-Role'
on Monday and let you
know how it works.
Thanks,
Wojtek
-Original Message-
From: Ruslan Zakirov [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 17, 2007 5:54 PM
To: Wojciech Jawor; Philip Kime; RT users
Subject: Re: [rt-users] Slow ticket search page becoming a problem
Heya, guys.
Finally
Heya, guys.
Finally I found some time to test this problem on mysql 5.0 and even
has writen a script to reproduce it, but it showed that mysql 5.0.45
has no this bug. My script and doogles helped me to prove that it
really works as expected. So I really recommend upgrade to 5.0.45 at
least for
On Sun, Nov 18, 2007 at 04:54:03AM +0300, Ruslan Zakirov wrote:
Heya, guys.
Finally I found some time to test this problem on mysql 5.0 and even
has writen a script to reproduce it, but it showed that mysql 5.0.45
has no this bug. My script and doogles helped me to prove that it
really
Hi, guys.
The explain is bad :( I mean gives us nothing good. I think we need an
index on the Groups table to make it better. Run the following query
to create an index. This may take some time, but I'm not sure how
much, depends on size of the table.
CREATE INDEX RUZ_G1 ON Groups(Type,
PROTECTED]
Sent: Thu 26/04/2007 17:34
To: Philip Kime
Cc: Jesse Vincent; Todd Chapman; RT Users
Subject: Re: [rt-users] Slow ticket search page becoming a problem
Philip, please try the following query and send us times and EXPLAIN:
SELECT STRAIGHT_JOIN DISTINCT main.* FROM
ACL ACL_4,
Groups
a huge problem for us.
Thanks,
Wojciech Jawor
Software Architect
Shopzilla, Inc.
-Original Message-
From: Ruslan Zakirov [mailto:[EMAIL PROTECTED]
Sent: Thu 26/04/2007 17:34
To: Philip Kime
Cc: Jesse Vincent; Todd Chapman; RT Users
Subject: Re: [rt-users] Slow ticket search page becoming
That looks suspiciously like the problem I'd been talking to you
about before, Todd.
On Apr 25, 2007, at 11:27 PM, Philip Kime wrote:
I know I asked this before but I've been swamped and lost track of
there the discussion got to.
RT 3.6.3, Mysql 5.0.27. The main ticket search page is
as far as I can see estimation of rows is very wrong I do think it's
mysql bug, I suggest you rebuild all indexes and run analyze on
tables.
On 4/26/07, Jesse Vincent [EMAIL PROTECTED] wrote:
That looks suspiciously like the problem I'd been talking to you about
before, Todd.
On Apr 25, 2007,
The problem seems to be caused by the ORDER BY clause. If I remove this,
it's very fast.
PK
From: Jesse Vincent [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 26, 2007 6:00 AM
To: Todd Chapman
Cc: Philip Kime; RT Users
Subject: Re: [rt-users] Slow ticket
that this would need a SearchBuilder mod to force the use of
the index related to the ORDER BY clause?
PK
From: Jesse Vincent [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 26, 2007 6:00 AM
To: Todd Chapman
Cc: Philip Kime; RT Users
Subject: Re: [rt-users] Slow ticket
Philip, please try the following query and send us times and EXPLAIN:
SELECT STRAIGHT_JOIN DISTINCT main.* FROM
ACL ACL_4,
Groups Groups_3,
CachedGroupMembers CachedGroupMembers_2,
Principals Principals_1,
Users main
WHERE ((ACL_4.PrincipalType = Groups_3.Type))
AND
PROTECTED]
Sent: Thursday, April 26, 2007 5:34 PM
To: Philip Kime
Cc: Jesse Vincent; Todd Chapman; RT Users
Subject: Re: [rt-users] Slow ticket search page becoming a problem
Philip, please try the following query and send us times and EXPLAIN:
SELECT STRAIGHT_JOIN DISTINCT main.* FROM
ACL ACL_4
I know I asked this before but I've been swamped and lost track of there
the discussion got to.
RT 3.6.3, Mysql 5.0.27. The main ticket search page is really slow to
load, typically 45 seconds, sometimes longer. Problem query and explain
below. It's starting to become a problem for us. Seems
16 matches
Mail list logo