Den 2012-07-19 03:06, Thomas Johnson skrev:
I'm wondering if anybody else out there who is using mysql for this could share their /etc/my.cnf file? Or the output of "SHOW GLOBAL VARIABLES"?
i think you need to google mysqltuner ? (it gives servial links) but in gentoo/funtoo its just emerge mysqltuner, this helped me optimize my own mysql server very much without wasting ram on it, it would be usefull to know what values you get in mysqltuner as a starting point
try migrade all tables to innodb, and reduce cache on other supported backend will save ram and get more power from mysql, innodb is better on ram usage, try keepin it all in innodb cache, is more ram efficient then all in myisam, but maybe you really need ha_innodb enabled ?
i dont know how clustered mysql would help here since spamassassin and amavisd does not use it very much imho
