However, if the log buffer is very big, then the default _log_io_size threshold will be big also, and so background writes may seldom be triggered. This means that all the redo will have to be flushed by sync writes, and so log file sync waits will take longer than otherwise. This impacts commit response time, and possibly DBWn performance as well.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22664653/viewspace-672003/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
