I'm currently running a roughly 8GB database on 2gb of ram (quad core xeon 2.4), webserver and db on the same machine. The indexes sit just over a 1GB and I have 768MB on the pool, iowait is very low and the index hit rate is high. The shredder indexes account for a large portion of it so it caches them back in at that time which is late at night. I still think you could get more out of it with some tuning. The indexes would probably help if you are doing a lot of queries against those fields though.
----- Original Message ----- From: "Mathew" <[email protected]> To: "Jesse Vincent" <[email protected]> Cc: "RT Users" <[email protected]> Sent: Friday, January 16, 2009 7:35 PM Subject: Re: [rt-users] Hardware Config >I was finally able to log into the system I'm consulting on. Using all of >this discussion as a jumping off point to figure out other steps to take >I've found a couple things which are clear problems. There are only 4GB >RAM as opposed to the 8GB which I thought it had. This would be moot >anyway as the system is 32-bit and the PAE kernel isn't in use. > > I found a query which gave me the database size. Turns out to be much > larger than I thought: 5.7GB vs the couple of GB I assumed. Add this to > the 4GB RAM and the my.cnf can't be tuned properly anyway. Kinda hard to > fit 5.7GB of database into 4GB of RAM. Essentially swaps are being done > and in the present config there isn't anything that can really be done > about it. > > I've recommended that, instead of building out a separate DB server, they > upgrade to RHEL 5.2 64-bit and upping the RAM. Once that is done the > MySQL config can be adjusted to make use of the greater capacity > eliminating at least that aspect of the problem. > > I made other points as well. I recommended upgrading MySQL from 5.0.27 > which I recall having minor issues which have caused problems in the past. > I also suggested having someone create indexes for the custom fields. > > Thanks for all the input folks. It's appreciated. > > -Mathew > > Jesse Vincent wrote: >>> 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. >> >> Start with that script. It just queries the database. It doesn't make any >> changes. But really, if you haven't done that yet, further discussion >> probably doesn't make much sense. > > -- > 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 > _______________________________________________ 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
