innodb_buffer_pool_size=107M
# Size of each log file in a log group. You should set the combined size# of log files to about 25%-100% of your buffer pool size to avoid# unneeded buffer pool flush activity on log file overwrite. However,# note that a larger logfile size will increase the time needed for the# recovery process.
innodb_log_file_size=54M
# Number of threads allowed inside the InnoDB kernel. The optimal value# depends highly on the application, hardware as well as the OS# scheduler properties. A too high value may lead to thread thrashing.
innodb_thread_concurrency=10
log-bin=mysql-bin
来源: http://mp.weixin.qq.com/s/6p-YQ9bD1cKI5OS-B4x3hQ