On 8/13/2011 9:01 AM, Reindl Harald wrote:
if it is a option for you to upgrade mysql to 5.5 i would strongly recommend this, our dbmail.machines became a hughe perofrmance boost against 5.1.x
OK, I finally got around to trying MySQL 5.5 as a final test. I'm still using the MySQL 5.1 client libraries, incidentally. Importing 18577 messages (560MB) into a single folder: real 320m32.330s user 2m25.413s sys 0m21.914s MySQL used 217 minutes' worth of CPU during this process. Searching Tests #msgs = 18577 [Updating Index] Time=2.29237, matches=18577 [NOFIND] Time=2.102401, matches=18577 [date] Time=1.958493, matches=18577 [here] Time=2.016579, matches=18577 Server settings (same 3GB HighMem + 2G/2G split virtual machine): skip-external-locking key_buffer_size = 256M max_allowed_packet = 16M table_open_cache = 256 sort_buffer_size = 32M read_buffer_size = 32M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 128M thread_cache_size = 8 query_cache_size= 128M thread_concurrency = 4 innodb_data_home_dir = /mail/db innodb_data_file_path = ibdata1:500M:autoextend innodb_log_group_home_dir = /mail/db innodb_buffer_pool_size = 512M innodb_additional_mem_pool_size = 40M innodb_log_file_size = 128M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 Yikes. =R= _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
