让检查点以如此之高的频率出现,不但可以让必须传输的脏页面的数量降至最低,而且还最大限度地降低网络与存储帧的缓存成本。
Having the checkpoints occur at this high a frequency minimizes the number of dirty pages that must be transferred and also minimizes the buffering cost for network and storage frames.
检查点是指数据库服务器在特定的时间点对磁盘上的页面和共享内存缓冲区中的页面进行同步。
A checkpoint refers to a point when the database server synchronizes the pages on disk with the pages in the shared-memory buffers.
数据写入到数据库时,指针称为检查点会更新以反映新的或更新页面写入到数据库。
As data is written to the database, a pointer called the checkpoint is updated to reflect the new or updated page that was written to the database.
应用推荐