On Mon, May 19, 2008 at 11:12:40AM -0300, Luis Hernán Otegui wrote: > Mark: > > 2008/5/18 Marc Perkel <[EMAIL PROTECTED]>: > > 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
