From: Tim Gustafson
Date: May 21 2010 1:58am
Subject: Re: spamassassin database
List-Archive: http://lists.mysql.com/mysql/221634
Message-Id: <726484591.89931274407100793.JavaMail.root@mail-01.cse.ucsc.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

> Right now I have the spamassassin bayesian rules database in mysql myisam
> tables on our mail server. I want to move it to our database server.
> Mysqltuner tells me that the read/write ratio is 10/90. 90% writes.
> 
> Given a database that is doing 90% writes, what database engine should I
> use?

myISAM will be the fastest for this type of access, I think.

Tim Gustafson
Baskin School of Engineering
UC Santa Cruz
tjg@stripped
831-459-5354