Make your log files big, even as big as the buffer pool. When InnoDB has written the log files full, it has to write the modified contents of the buffer pool to disk in a checkpoint. Small log files cause many unnecessary disk writes. The drawback of big log files is that the recovery time is longer.里面的the buffer pool 是key_buffer_size参数设置的值的大小吗?或者是innodb_buffer_pool_size参数设置的值的大小吗?
Make your log files big, even as big as the buffer pool. When InnoDB has written the log files full, it has to write the modified contents of the buffer pool to disk in a checkpoint. Small log files cause many unnecessary disk writes. The drawback of big log files is that the recovery time is longer.里面的the buffer pool 是key_buffer_size参数设置的值的大小吗?或者是innodb_buffer_pool_size参数设置的值的大小吗?
确定是innodb_log_buffer_size吗?
我探讨的是innodb啊,跟myisam有何关联呢?