1000万条数据导入mysql(二)

2014-11-24 15:59:58 · 作者: · 浏览: 8
able_cache=256
#tmp_table_size=35M
#***MyISAM Specific options
key_buffer_size=512M
read_buffer_size=32M
read_rnd_buffer_size=32M
sort_buffer_size=32M
#***INNODB Specific options ***
innodb_additional_mem_pool_size=128M
innodb_flush_log_at_trx_commit=0
innodb_log_buffer_size=8M
innodb_buffer_pool_size=1G
innodb_log_file_size=256M
innodb_thread_concurrency=18
######################################