On 6/30/07, James Greig <[EMAIL PROTECTED]> wrote:
Hi, We have a dbmail setup with around 5000 users using dbmail setup across several machines. The MYSql server is on a pe 2950 quad 3ghz with 2 gig of RAM. MYSql is the ONLY service on this machine. Does anyone have a recommended my.cnf for dbmail on an innodb database. Also, the recommended indexes for dbmail (in their alter table syntax). The most relevant my.cnf options we currently have are: innodb_buffer_pool_size = 512M innodb_additional_mem_pool_size = 50M innodb_log_file_size = 5M innodb_log_buffer_size = 64M innodb_flush_log_at_trx_commit = 0 innodb_lock_wait_timeout = 50 # * Fine Tuning # key_buffer = 384M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 8 #max_connections = 100 table_cache = 512 #thread_concurrency = 10 # # * Query Cache Configuration # query_cache_limit = 1M query_cache_size = 16M Thanx in advance! -- James Greig Mor-Pah Studios http://www.mor-pah.net _______________________________________________
5000 users. Wow. I wonder what performance of dbmail-mysql combination for this. I am no MySql guru but Paul this is an opportunity to see how dbmail performs for many users like this. --
zamri Linux System Administrator Kolej ShahPutra Kuantan Pahang Malaysia Tel : 609.573.777.7 ext 119 web : http://muhdzamri.blogspot.com
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
