informix 逻辑日志和物理日志(国外英语资料).docVIP

informix 逻辑日志和物理日志(国外英语资料) The physical log and logical logs in the informix database are two very important disk artifacts. 1. The physical log Physical log is a contiguous disk space. The main purpose is to provide the raw data image for the rapid recovery of the system. Physical log in page to allocate and release for the unit, it is called before the content of stored images (as the name suggests, the appearance of the original data before modifying the data image). When one of Shared memory pages to be modified before (modified) for the first time, system to modify the data before first image () before images stored in the physical log. Thus, before the entire operation of the user is fully successful, the modified image of all the data pages he has modified is saved, and once the problem occurs, The system can quickly recover from before images in the physical log. It is important to note that before the first time the data page has been modified before the image is saved, All changes to the page are no longer written before image after the before image is written and it is released. When the user writes this page and the logical log is released, The before image can be released. 2. The logical logs Logical logs are composed of several separate disk Spaces, each a continuous disk space. There are at least three logical log blocks for an Informix Dynamic Server system, The maximum data can be configured by the administrator (no more than 32,767 blocks). Is the purpose of the logical log will remember to modify system each operation, each are saved, so that when the system problems can REDO (REDO) according to its content or transaction cannot proceed to rollback (UNDO). The content of the logical log records mainly consists of the impact of the transaction on the system, the DDL statement, and the checkpoint (checkpoint) record. Physical logs are maintained by the system, often without maintenance. Maintenance of logical logs. Backup of logical logs First, the