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

[Kelly F. Hickel]

Jesse,
	Have you got any tips (or pointers to pages) for that? We use
MySQL for bugzilla and bonsai as well, and it could definitely use a
performance boost.  We've got it on some fairly serious (IBM server dual
cpu's, raid 5, etc) hardware, and it's still the weak link.....

Kelly F. Hickel
Senior Software Architect
MQSoftware, Inc
952.345.8677
kfh at mqsoftware.com


-----Original Message-----
From: Jesse Vincent [mailto:jesse at bestpractical.com] 
Sent: Friday, March 14, 2003 1:02 PM
To: Harald Wagener
Cc: rt-devel at lists.fsck.com
Subject: [rt-devel] MySQL Performance issues with RT 2-1-xx


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.
_______________________________________________
rt-devel mailing list
rt-devel at lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel