[rt-users] 2.0.9 bogs with >10K tickets
jesse at bestpractical.com
Fri Dec 21 00:49:01 EST 2001
It's probably worth turning on full query logging and doing some query analysis to see what other
indices would be helpful. I'd love to hear what you find.
On Thu, Dec 20, 2001 at 06:08:35PM -0500, Darren Nickerson wrote:
> >>>>> On Thu, 20 Dec 2001, "Darren" == Darren Nickerson wrote:
> Darren> Things have definitely improved!! Thanks!
> Substring searches by requestor and bulk updates on the returned results
> still aren't really feasible somehow though, wven with the new schema and
> indices. MySQL's processlist shows:
> | 16 | rt2 | localhost | rt2 | Query | 326 | Copying to tmp table |
> SELECT DISTINCT main.* FROM Tickets main, Watchers Watchers_1, Watchers W
> atchers_3 LEFT JOIN Users |
> And man . . . . does it ever chug. 3+ minutes even. Normal?
http://www.bestpractical.com/products/rt -- Trouble Ticketing. Free.
More information about the rt-users