On Aug 7, 2008, at 6:37 PM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > _______________________________________________ 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
