On 18 Feb 2009, at 12:48 am, Ruslan Zakirov wrote: > First time I see something like that. May be it's better to ask on > mysql lists. And sure you should keep digging into a reason. My > practice shows that there is no such thing as "suddenly" in IT. There > is always some change that turn world up side down. > > optimize/analyze on InnoDB don't do the same job as on myisam tables, > it's documented in mysql's docs. You can find way to rebuild indexes > on a table and as the last resort use full re-load.
I think that's what I'm going to do - the slave of our RT instance, which is also running MySQL 5.0.51, performs the same query in only 15 seconds, not four minutes... 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