【效能優化】Can the log buffer be too big?

楊奇龍發表於2010-08-27
優化
     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部落格 ” ，連結：http://blog.itpub.net/22664653/viewspace-672003/，如需轉載，請註明出處，否則將追究法律責任。

相關文章