[rt-users] Hardware Config

[Curtis Bruneau]

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" <mathew.snyder at gmail.com>
To: "Jesse Vincent" <jesse at bestpractical.com>
Cc: "RT Users" <rt-users at bestpractical.com>
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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>