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
