62,614
社区成员
发帖
与我相关
我的任务
分享
key_buffer_size = 256M
max_allowed_packet = 10M
table_open_cache = 512
sort_buffer_size = 16M
read_buffer_size = 128M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 80
#query_cache_size= 128M
query_cache_size= 256M
# Try number of CPU's*2 for thread_concurrency
#thread_concurrency = 8
thread_concurrency = 16
tmp_table_size = 1024M
innodb_autoextend_increment = 1000
innodb_data_file_path = ibdata1:4000M;ibdata2:4000M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/log/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 512M
innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 256M
innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
innodb_flush_log_at_trx_commit = 2
#innodb_lock_wait_timeout = 50
sync-binlog=1
bulk_insert_buffer_size=12M
innodb_flush_method=O_DIRECT
innodb_thread_concurrency=1000