On Mon, Nov 26, 2007 at 04:50:33PM +0000, Mark Chappell wrote:
> Jesse Vincent wrote:
> >Can you talk about what you've done to tune your MySQL server? MySQL
> >performance tuning can take you a lot larger than you're currently at.
> >Having enough RAM and _using_ it are both important for keeping mysql
> >purring.
>
> The bulk of the tuning was done before my time, it's mostly a stock RT
> with some minor my.conf changes
You likely want to have a look at the "my innodb 4gb heavy" sample
config file. And then turn on the slow query log and have a look at
indexing.
-jesse
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:
If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch
today.
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.
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
