Hi Everyone, Just recently, well the last month or so we have been having trouble with RT. I think it is a database related problem but am unsure where to go. When loading Tickets we get to wait times of some 14seconds or so and the whole interface for other users also slows to a crawl. At these times apache is freaking out and consumes most of the CPU also.
I thought it may have been the indexes on the attachments table being dis-organised so I optimised all tables in the database. Our attachments table is some 3gig at the moment and now I am totally at a loss... Any ideas what could cause this, mysql is complaining about any queries that hit the attachments table which is why I started there. *Regards,* *Aaron Guise 027 212 6638 aa...@guise.net.nz *
_______________________________________________ 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
