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
key_buffer = 128M
table_cache = 256
sort_buffer_size = 2M
read_buffer_size = 2M
myisam_sort_buffer_size = 16M
thread_cache = 8
#query_cache_type = ON
query_cache_size= 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 4
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
