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 _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
