Hey guys,
I'm looking for any best practices or a formula that is commonly used in
setting the value for thread concurrency in the configuration file.
I have 24 instances running on a sun 2900 server with 32GB or ram.
Here is a sample of my configuration file.
#use this line mfor mysql 4.1
old-passwords
server-id = 2216
net_buffer_length=65536
net_read_timeout=120
net_write_timeout=180
key_buffer=64M
max_allowed_packet=1M
table_cache=2048
sort_buffer=1M
record_buffer=1M
myisam_sort_buffer_size=16M
max_connections=2500
thread_cache=8
# Try number of CPU's*2
thread_concurrency=4
query_cache_size=256M
query_cache_limit=128K
#only availble in 4.1
innodb_file_per_table
innodb_buffer_pool_size=500M
innodb_additional_mem_pool_size=25M
innodb_log_archive=0
innodb_log_files_in_group=3
innodb_log_file_size=100M
innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=2
innodb_file_io_threads=4
innodb_lock_wait_timeout=30
#innodb_flush_method=fdatasync
#innodb_fast_shutdown=1
innodb_thread_concurrency=5
transaction-isolation = READ-UNCOMMITTED
[mysqld140]
bind-address=xxx.xxx.xxx.xxx
old-passwords
mysqld=/usr/local/mysql/bin/mysqld_safe
pid-file=/p01/abq/mysqladmin/abq_pid
basedir=/usr/local/mysql
datadir=/p01/abq/mysqldata
socket=/p01/abq/mysqladmin/mysql.sock
port=3306
local-infile=1
user=mysql
tmpdir = /tmp/abq/
log = /p01/abq/mysqllogs
log-bin = /p01/abq/mysqllogs/abq-bin
log-err = /p01/abq/mysqllogs/abq.err
log-slow-queries = /p01/abq/mysqllogs/abq_slow_query.log
innodb_file_per_table
set-variable = innodb_buffer_pool_size=500M
set-variable = innodb_additional_mem_pool_size=25M
innodb_data_home_dir = /p01/abq/mysqldata/innodb/
innodb_data_file_path = ibdata1_abq:100M:autoextend:max:4096M
# .._log_arch_dir must be the
same
# as .._log_group_home_dir
innodb_log_group_home_dir = /p01/abq/mysqladmin/iblogs
innodb_log_arch_dir = /p01/abq/mysqladmin/iblogs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
