> 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-variables.html#sysvar_key_buffer_size
Tim Gustafson
Baskin School of Engineering
UC Santa Cruz
t...@soe.ucsc.
> 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
> us
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 doi
