较大日志缓冲池的不利之处是,紧急事故恢复所花的时间可能要稍微长一点。
The downside of a larger log buffer is that crash recovery can take slightly longer.
日志记录首先被写到内存中的日志缓冲池,然后再写到日志文件,通常是在日志缓冲池已满或者发生了一次提交时写到日志文件的。
Log records are written first to the log buffer in memory, and then to the log file, most commonly when the log buffer is full or a commit occurs.
此外,每一个数据库可拥有自己的数据库配置文件、目录表、日志、保留的缓冲池区域和表空间。
In addition, each database has its own database configuration file, catalog tables, logs, reserved buffer pool area, and table Spaces.
应用推荐