Am 13.06.2012 10:16, schrieb ITronic Harald Leithner: > Hi Jorge, > > I upgraded form dbmail 2.2 to 3.0 and mysql 5.0 to percona server 5.5 but on > a new hardware so I couldn't give you > any good information about performance but I think Reindl Harald may have > some information about the innodb > compressed feature in mysql 5.5
these are my innodb-settings with MySQL 5.5 on a machine with 9500 MB RAM (VMware ESXi) and around 8.75 GB messages reduced to 6.51 due compressed tables these settings combined with upgrade to 5.5 made our dbmail setup much faster as before we are using compressed tables since 2009 / MySQL 5.1 in 5.1 you needed innodb_plugin, 5.5 supports native be aware you need "innodb_file_per_table" for this feature 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
