This is something I have always had a problem with optimising a mysql configuration. Some of my main problems come from getting the right buffer size as alot of the config variables are per connection and a lot arent and there seems to be no way of telling between them in the descriptions.
Anyway my new server has 12 cores and 64 gb of ram and im thinking of giving 32 gb to mysql any recomendations on a my.cnf for that?