[rt-users] Slow Query Log

[Jesse Vincent]

On Aug 7, 2008, at 6:37 PM, <zbigniew at starpower.net> <zbigniew at starpower.net 
 > wrote:

> I'm using RT 3.8 and Mysql 5.0.51a on Fedora Core 9.
>
> I've been noticing some slowness using the interface.  Most of the  
> time it is when updating tickets.  Reviewing the slow query log I  
> found the following.

It'd help if you could:

* send the complete queries
* send the actual metainformation about how slow is slow
* run 'explains' for these queries
* tell us about your RT server hardware configuration
* tell us a bit about what you've already done to tune your database

Best,
Jesse

>
>
> Out of a total of 53133 log entries there where
> 14369 entries for SELECT count(main.id) FROM ObjectCustomF
> 5540 entries for SELECT  * FROM Templates WHERE Queue = '
> 18967 entries for SELECT main.* FROM CustomFields main JOI
> 9397 entries for SELECT main.* FROM Tickets main  WHERE (
>
> Oddly enough, I don't use CustomFields.
>
> Any suggestions on how to speed things up?
>
>
> _______________________________________________
> 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
>