answersLogoWhite

0

fuzzy checkpointIn a fuzzy checkpoint, the database server does not flush the modified pages in the shared-memory buffer pool to disk for certain types of operations, called fuzzy operations. When a fuzzy checkpoint completes, the pages might not be consistent with each other, because the database server does not flush all data pages to disk. A fuzzy checkpoint completes much more quickly than a full checkpoint and reduces the amount of physical logging during heavy update activity. When necessary, the database server performs a full checkpoint to ensure the physical consistency of all data on disk. Fuzzy Operations

The following commonly used operations are fuzzy for built-in data types:

  • Inserts
  • Updates
  • Deletes

The following operations are nonfuzzy:

  • Inserts, updates, and deletes for rows that contain user-defined data types, smart large objects (CLOB and BLOB data types), or simple large objects (TEXT and Byte data types)
  • Table alters and loads
  • Operations that create or modify indexes (B-tree, R-tree, or user-defined indexes)

The database server flushes all the modified data pages for nonfuzzy operations to disk during a fuzzy checkpoint in the same way as for a full checkpoint.

Important:

Fuzzy checkpoints are disabled for the primary and secondary servers in a High-Availability Data Replication pair.

Write-Ahead Logging and Fast Recovery

Fuzzy checkpoint uses write-ahead logging for fast recovery. Write-ahead logging means that the logical-log records representing changes to fuzzy data must be on disk before the changed data replaces the previous version of the data on disk. Fast recovery begins with the oldest update not yet flushed to disk rather than with the previous checkpoint.

Fuzzy checkpoints result in slightly longer roll-forward fast-recovery times. The database server occasionally performs a full checkpoint to prevent loss of old logical-log records.

Fuzzy Checkpoints Improve Performance

Fuzzy checkpoints are much faster than full checkpoints and improve transaction throughput. Because the database server does not log fuzzy operations in the physical log, the physical log does not fill as quickly, and checkpoints occur less often. For example, if you are inserting and updating a lot of data, checkpoints occur less frequently and are shorter.

The database server skips a full checkpoint if all data is physically consistent when the checkpoint interval expires. It skips a fuzzy checkpoint only if no pages have been dirtied since the last checkpoint.

To improve transaction throughput, use the BUFFERPOOL configuration parameter to increase thelru_max_dirty and lru_max_dirty values. However, do not change the gap between the lru_max_dirty andlru_max_dirty values.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is difference between check point and save point in DBMS?

save point saves the dbms and check point simply check the database thats it simple


What are highlights of DBMS?

NA_ what are highlights of advanced DBMS what are highlights of advanced DBMS what are highlights of advanced DBMS


Is java DBMS?

no, Java is not dbms.. Java is a programming language Dbms is database


Is SQL DBMS or RDBMS?

dbms


if you want to disign new DBMS to any organization first you must set of requiments and set of features that DBMS product must provide to fill requiments. discribe the process of evaluating and selecting the best DBMS product. ?

Know what you need and check each need is met by the product


What are three types of dbms?

Hierarchical DBMSNetwork DBMSRelational DBMS


What are rows in dbms?

In DBMS the data is stored in the form of table . Each row in DBMS is known as tuple.


What are the importance of dbms in industrial environment?

importance of DBMS


What is the purpose of dbms?

What is the purpose of dbms?DBMS is a software that organises the creation, storage and maintenance of Databases for end users.


When was Polyhedra DBMS created?

Polyhedra DBMS was created in 1993.


What is the use of dbms?

DataBase Management System (DBMS)is a software package# it allows data to be effectively stored, retrieved and manipulatedand # the data stored in a DBMS packege can be accessed by multiple users and by multiple application programs like (SQL Server, Oracle, Ms-Access) .Types of DBMS# Hierarachical DBMS (HDBMS)# Network DBMS (NDBMS)# Relational DBMS (RDBMS)# Object Oriented DataBase(OODB)# Distributed DBMS (DDBMS)


What is DBMS?

DBMS is short for database management system . DBMS is the collection of related records.