且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

【性能优化】Can the log buffer be too big?

更新时间:2022-08-12 16:00:29

     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.