[rt-devel] MySQL Performance issues with RT 2-1-xx

[Jesse Vincent]

It occurs to me that it hasn't recently been stressed enough that MySQL
itself _must_ be configured to take advantage of system memory. Out of
the box, it comes configured to use something like 64mb of RAM. The more
ram you let mysql have, the faster it will be. It's also worth moving up
to a more recent mysql (4.0.9+) and enabling mysql's built in "Query
Cache" which is known to give a huge performance boost for certain types
of applications.

	Jesse

On Fri, Mar 14, 2003 at 02:23:55PM +0100, Harald Wagener wrote:
> And another addition: When trying to access the 'Jumbo' view of a 
> ticket, MySQL uses up all of the CPU time, and after a timeout I get an 
> internal server error from the server. Restarting MySQL gets the system 
> up again
> 
> (RH8.0,Apache1.3.27,fastscgi,perl5.8.0,mysql-4.0.4).
> 
> Regards,
>     Harald
> 
> -- 
> Harald Wagener * FCB/Wilkens * An der Alster 42 * 20099 Hamburg
> 
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.