spamassassin database

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?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: spamassassin database

On May 20, 2010 11:35:32 am John G. Heim wrote:
> 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?
Postgres :p

In seriousness though, go with whatever the rest of your database uses. There are probably some
minor differences between database engines, but for maintenance, you will not regret keeping things
consistent.

Colin

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: spamassassin database

> 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@soe.ucsc.edu
831-459-5354

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: spamassassin database

> Given a database that is doing 90% writes, what database engine should I
> use?

You may also want to increase your key_buffer_size:

http://dev.mysql.com/doc/refman/5.0/en/server-system-variabl es.html#sysvar_key_buffer_size

Tim Gustafson
Baskin School of Engineering
UC Santa Cruz
tjg@soe.ucsc.edu
831-459-5354

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org