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: sa...@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > --
pgpx8QMwPLYHm.pgp
Description: PGP signature
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com