Let mysqltuner (http://rackerhacker.com/mysqltuner/) have a look at your database. Lots of useful stuff. We went from 180 second full text queries, to 7 seconds, just be tweaking innodb_buffer_pool_size.
Cheers Toby Richard Ellis wrote: > Hi All, > > We have recently updated our RT instance from 3.4.6 running on Solaris 9 > to a new server running Solaris 10 and 3.6.4. > > Everything works perfectly and we have removed all of the customisations > that we used to use for a virtually vanilla 3.6.4 install. However, when > opening the Query Builder page, performance slows to a massive extent. > Average page load is under 1 second, but performing any action in Query > Builder averages 400 seconds. > > I thought it was the database so upgraded mysql from 5.0.34 to 5.0.51a, > but that made no difference. I then upgraded DBIx::SearchBuilder to the > latest version and DBD::mysql but it is still as bad. Even upgraded > every single perl module to latest and restarted everything, but still > as bad. > > mysqlcheck rt3 says everything is ok. > > There are only 10,000 tickets so it shouldn't be a volume problem. > > Running on perl 5.8.8. > > Anyone any ideas? > > Richard > > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com LEGAL NOTICE Unless expressly stated otherwise, information contained in this message is confidential. If this message is not intended for you, please inform [EMAIL PROTECTED] and delete the message. The Cambridge Crystallographic Data Centre is a company Limited by Guarantee and a Registered Charity. Registered in England No. 2155347 Registered Charity No. 800579 Registered office 12 Union Road, Cambridge CB2 1EZ. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com