[rt-users] Severe performance problems suddenly in RT 3.8.2

[Jesse Vincent]

On Tue 17.Feb'09 at 16:51:57 +0000, Tim Cutts wrote:
> We migrated our RT server to RT 3.8.2 a week ago, and all went well  
> until today, 

From what version?

> when suddenly we've been hit by a massive performance  
> problem.  It seems that almost any query which touches the Attachments  
> table takes an absolute age to complete.  

Anything in mysql's error logs?

What does EXPLAIN SELECT COUNT(id) FROM Attachments say?

> Is there anything I ought to be looking at?  The database server is  
> MySQL 5.0.32

MySQL versions > 4.1 and < 5.0.45 are known to have a crippling query
optimizer bug that WILL hurt you on RT, but I'm not sure this is that.
> 
> Tim
> 
> 
> -- 
>  The Wellcome Trust Sanger Institute is operated by Genome Research 
>  Limited, a charity registered in England with number 1021457 and a 
>  company registered in England with number 2742969, whose registered 
>  office is 215 Euston Road, London, NW1 2BE. 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
> 

-- 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 194 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090217/86a99844/attachment.sig>