较大日志缓冲池的不利之处是,紧急事故恢复所花的时间可能要稍微长一点。
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.
当您在大型审核日志表格中运行查询功能时,您可能会在您的数据库系统不得不向缓冲池读入数千页面以进行计算时而结束。
When you run queries for very large audit log tables, you can end up with a situation where your database system has to read thousands of pages into the bufferpool to compute the result.
当您在大型审核日志表格中运行查询功能时,您可能会在您的数据库系统不得不向缓冲池读入数千页面以进行计算时而结束。
When you run queries for very large audit log tables, you can end up with a situation where your database system has to read thousands of pages into the bufferpool to compute the result.
应用推荐