Transactions and locks for innodb quarantine database

[Benny Pedersen]

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