mysql4.conf
#
# (dim) MySQL Config
#
[mysqld]
max_connections=2000
# myisam
key_buffer_size=2000M
thread_concurrency=16
low_priority_updates=1
# files
innodb_file_per_table
innodb_data_home_dir=/RAID5/data4/innodb
innodb_data_file_path=data1:20M:autoextend
innodb_log_group_home_dir=/RAID5/data4/innodb
innodb_log_file_size=500M
# buffers
innodb_buffer_pool_size=2000M
innodb_additional_mem_pool_size=20M
innodb_log_buffer_size=8M
# tune
##transaction-isolation=READ-COMMITTED
## (since V5) innodb_checksums=0
## (since V5) innodb_doublewrite=0
## (since V5) innodb_support_xa=0
innodb_thread_concurrency=16
##innodb_commit_concurrency=??
##innodb_concurrency_tickets=500
##innodb_file_io_threads=16
innodb_flush_log_at_trx_commit=1
##innodb_flush_method=
##innodb_lock_wait_timeout=50
##innodb_max_dirty_pages_pct=90
##innodb_sync_spin_loops=??
##innodb_thread_sleep_delay=10000