Specifies the maximum delay between an application executing a COMMIT and the COMMIT actually being written to disk when the delayed_commits option is set to On.

Allowed values

Integer, in milliseconds

Default

500

Scope

Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.

Remarks

This option has meaning only when delayed_commits is set to On. it governs when a COMMIT entry in the transaction log is written to disk. With delayed_commits set to On, the database server waits for the number of milliseconds set in the delayed_commit_timeout option for other connections to fill a page of the log before writing the current page contents to disk. See delayed_commits option [database].