I absolutely agree. I've already told him that new hardware isn't going to make a difference even before asking about it here. However, in order to be able to cover my bases in proving him wrong (admittedly a task I chomp at the bit for) I decided to ask about it here.
I don't have direct access to the my.cnf file as I'm only a consultant these days but once I'm able to get that I'll give some more info. As also mentioned, I still need to take a look at the tuning scrip Ruslan pointed me to. Jesse Vincent wrote: > On Fri, Jan 16, 2009 at 02:37:30PM -0500, Mathew wrote: >> We presently have our RT installation running on the same hardware as the >> database: an Intel 1550 box with 4 cores of about 2.5GHz each and 8GB RAM. >> We've been plagued with speed issues even after upgrading to this. We >> realized initial performance gains when we installed to the new hardware >> about two and a half years ago but eventually that faded. > > Can you tell us about how you've tuned mysql, how many concurrent users > you have working with RT, how many tickets you have in RT, etc? > > No matter how beefy a server you've got, if you don't spend some time > tuning mysql, it will assume it's running on a single-core Pentium 133 > with 128 megs of RAM which is also your primary mail server. And the > performance you see will reflect that. > > I would strongly recommend that you invest some time in profiling and > tuning before just throwing a bigger box at your problem. RT runs just > great for many of our clients on hardware much more modest than what > you've got already. -- Keep up with my goings on at http://feeds.feedburner.com/theillien_atom _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users 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
