I will probably take this to a MySQL list as well, but there's a good bit of knowledge on this list that might help...
We are seeing extremely slow MySQL startup on our Dell PE 1955. MySQL becomes available very quickly, but takes approximately 1.5 hours to fill the memory cache and let go of the processor. I see 95-105 % proc utilization by MySQL (it's using one of 4 procs???) and the very very slow growth of mem utilization. We've set the following for InnoDB parameters innodb_buffer_pool_size = 2G innodb_additional_mem_pool_size = 250M innodb_log_file_size = 250M innodb_log_buffer_size = 100M innodb_flush_log_at_trx_commit = 2 # System has 2 dual core Xeon 3GHz procs, and 8GB of RAM. Performance is ABYSSMAL while loading the cache - but once the cache is loaded and mem utilization tops out around 2.9GB, then performance improves quite a bit... Any help here? Erik
