[rt-users] RT 3.6.4 poor query performance
Toby Darling
darling at ccdc.cam.ac.uk
Thu Mar 13 09:45:42 EDT 2008
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: sales at bestpractical.com
>
>
> 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 postmaster at ccdc.cam.ac.uk 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.
More information about the rt-users
mailing list