you can do a coupla things.. run mysqltuner.pl (freely available on the web) and follow its recommendations as to tuning your my.cnf
SD you keep mentioning tuning MySQL
Are there any caveats involved with just running the mysqltuner.pl script?
I never tried it so was a little uncomfortable trying same.
Also how do I determine I have access to my.cnf to make changes.(Can't seem to find it)