hege at hege
May 19, 2008, 8:04 AM
Post #4 of 4
(74 views)
Permalink
|
On Mon, May 19, 2008 at 11:12:40AM -0300, Luis Hernán Otegui wrote:
> Mark:
>
> 2008/5/18 Marc Perkel <marc[at]perkel.com>:
> > Just looking for some my.cnf example files for SA.
> >
> > Server has 4 gigs of ram, dual core CPU. What do I want in my my.cnf file?
> >
> > Thanks in advance.
>
> Could you AT LEAST post this kind of questions as OFF TOPIC??? Or
> maybe to the right list? (Mysql, Postfix, etc.)
How is this OFF TOPIC IN CAPITALS? What does Postfix have to do with
MySQL+SA? If you read Marcs last posts, you see the connection. Would have
been more clear if he continued in that thread though.
To answer, there isn't anything special that SA needs. Only normal MySQL
performance tuning.
Just see how big your tables are with "show table status", sum data+index
sizes and multiply that by 1.5x to get a minimal innodb_buffer_pool_size.
You want all data in buffers.
Depending on platform, research following parameters:
innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 0
To save marginal overhead, you can disable query cache as bayes queries are
random and cache isn't even used for prepared statements. If you have
something else than SA in your db, you might want to enable it.
query_cache_type = 0
Cheers,
Henrik
|
