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