InnoDB的配置

http://www.cnblogs.com/szx_rencaijob/archive/2010/04/28/1723211.html

推荐InnoDB的配置(1G内存情况,主要运行mysql服务器):

innodb_buffer_pool_size = 600M 
innodb_additional_mem_pool_size = 64M 
# 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_lock_wait_timeout = 50 
innodb_file_per_table

其中innodb_flush_log_at_trx_commit和innodb_file_per_table对I/O性能影响最大。

原文地址:https://www.cnblogs.com/kxxx/p/6026616.html