[rt-users] RT 3.4.5 slow loading/large query for RT: At a Glance page

[Jesse Vincent]

On Mon, Feb 20, 2006 at 02:37:33PM +1030, Tim wrote:
> Hi All,
> 
> I was recently tasked with upgrading RT from 3.0.11 to 3.4.5 for my 
> company, basicaly we use RT to handle all incoming requests from 
> customers as well as internal requests between branches, so the database 
> is very large 650k + tickets from a large number of individual users - 
> pretty much anyone that emails the company on the specified support 
> address.
> 
> We have a front end box with SearchBuilder 1.38, Apache 2.0.54, mod_perl 
> 2,RT 3.4.5 (p4 2.8 ghz 1.5 gig ram) and a backend box, running the mysql 
> RT database Fedora Core 4, Mysql 4.1.16 (p4 3 ghz 4 gig ram 10k rpm WD 
> raptor drive. The upgrade process was all very smooth ( I dumped the old 
> DB - transferred it to the new server, configured the appropriate my.cnf 
> settings, imported the database and then ran the schema upgrades) and in 
> initial testing everything seemed fine, however when all the support 
> staff started logging on this particular query grinds the server to a 
> halt by maxing out the CPU on the rt-sql server.
>

Can you tell us how you've tuned and optimized your mysql instance?