We are finally releasing our production DBMail system.
I would like to make some optimizations to MySQL to ensure best performance.
Could you give me some general guidelines for setting my.cnf to work best with
DBMail?
I know there are plenty of books on this.. but thought maybe you could give some
general guidelines since you've probably done some load testing.
4GB's Ram dual proc machines
We are running MySQL 4.
- max_connections - We have at 500, is there some sort of formula for this.
should it be based on the amount of ram we have?
- query_caching - Set at 16MB. Again I was thinking this would be based on RAM
but all the examples I've seen use 16MB.
Thanks any info would be great,
- Kevin
begin:vcard
fn:Kevin Baker
n:Baker;Kevin
email;internet:[EMAIL PROTECTED]
tel;work:858-454-5532
version:2.1
end:vcard
