Am 24.06.2012 04:56, schrieb remy: > I have a fresh installation of dbmail 3.0.2. (mysql 5.1.46; postfix > 2.7.1 in a openSuSE 11.3 everthing in the same server).
update to MySQl 5.5 if possible > (some supposedly relevant parameters from supposedly relevant config files:) they most interesting ones are innodb-settings but let's look to you provided ones get "mysqltunber.pl", it will show you taht many of your settings below would kill you machine in the worst case if all connections are used by out-of-memorfy BUT do not blindly believe any output from mysqltuner to higher settings, you should use uit more to make sure not wasting ressources without any benefit > my.cnf > key_buffer_size = 16M may be way to less, depens on your databases (mysqltuner) > max_allowed_packet = 180M OK > table_open_cache = 64 http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_table_open_cache should be max_connections x table_count > sort_buffer_size = 4M this is wy too high buffer allocatin happens per connection / thread memorfy allocation needs ressources sort_buffer_size = 320K > net_buffer_length = 32K remove this one > read_buffer_size = 2M way to high, also per connection / thread and there are many benchmarks that allocation above 128K may slow down things dramatically read_buffer_size = 128K > read_rnd_buffer_size = 4M way too high read_rnd_buffer_size = 256K > myisam_sort_buffer_size = 32M this one is OK and needed for "optimize tbale" on large MyISAM tables ___________________________________ what is much more interesting are the innodb-settings you did not care about - below my reommended ones for MySQL 5.5 while you must check with the error-log which are not supported at 5.1 if you can not upgrade "innodb_buffer_pool_size" is the most important one and should be in the baest case as lage as the whole database, my expiereince is that 33-50% are for dbmail OK "innodb_log_file_size" is a litle problematic to change please consult google how to do or leave it untouched and maybe "innodb_log_buffer_size" can help you reduce the pressure here innodb_buffer_pool_size = 3072M innodb_buffer_pool_instances = 3 innodb_purge_threads = 1 innodb_max_purge_lag = 200000 innodb_max_dirty_pages_pct = 60 innodb_additional_mem_pool_size = 64M innodb_log_file_size = 512M innodb_log_buffer_size = 256M innodb_thread_concurrency = 32 innodb_thread_sleep_delay = 10 innodb_flush_log_at_trx_commit = 2 innodb_support_xa = 1 innodb_lock_wait_timeout = 50 innodb_table_locks = 0 innodb_checksums = 0 innodb_file_format = barracuda innodb_file_per_table = 1 innodb_open_files = 600 innodb_io_capacity = 300 innodb_read_io_threads = 8 innodb_write_io_threads = 8 transaction-isolation = READ-COMMITTED
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
