Please see my comments below : On Thu, 2005-12-01 at 14:06 -0600, Ross Anderson wrote: > I have read the suggestions for optimization for innodb however I'm > curious if anyone can help me understand which buffers are common (thus > used by innodb action) and which are specific to myiasm. The server has > 2GB of ram but runs multiple services. I have a number of different > types of connections also. Some are repeated queries to static tables > and others are dynamic read write to large tables. > > Thanks in advance! > Ross Anderson > > mysql 4.0.25 > linux-2.6.14 > >
MyISAM storage engine specific : > key_buffer = 128M > myisam_sort_buffer_size = 16M Effecting all engines: > thread_cache = 8 > #query_cache_type = ON > query_cache_size= 32M > # Try number of CPU's*2 for thread_concurrency > thread_concurrency = 4 > sort_buffer_size = 2M > read_buffer_size = 2M > table_cache = 256 InnoDB specific: > innodb_buffer_pool_size = 768M > innodb_additional_mem_pool_size = 20M > innodb_log_file_size = 256M > innodb_log_buffer_size = 8M > innodb_flush_log_at_trx_commit = 0 > innodb_lock_wait_timeout = 50 > innodb_status_file=0 Also if there is too much IO, try to increase number of innodb log files from 2 to something like 4. Check http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html for full list of system variables. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]