Home | Previous Page | Next Page   Disk, Memory, and Process Management >

Shared Memory

In This Chapter
Shared Memory
Shared-Memory Use
Shared-Memory Allocation
Shared-Memory Size
Action to Take If SHMTOTAL Is Exceeded
Processes That Attach to Shared Memory
How a Client Attaches to the Communications Portion (UNIX)
How Utilities Attach to Shared Memory
How Virtual Processors Attach to Shared Memory
Obtaining Key Values for Shared-Memory Segments
Specifying Where to Attach the First Shared-Memory Segment
Attaching Additional Shared-Memory Segments
Defining the Shared-Memory Lower-Boundary Address
Resident Shared-Memory Segments
Resident Portion of Shared Memory
Shared-Memory Header
Shared-Memory Buffer Pool
Buffer Overflow to the Virtual Portion
Buffer Size
Logical-Log Buffer
Physical-Log Buffer
High-Availability Data-Replication Buffer
Lock Table
Virtual Portion of Shared Memory
Management of the Virtual Portion of Shared Memory
Size of the Virtual Portion of Shared Memory
Components of the Virtual Portion of Shared Memory
Shared-Memory Internal Tables
Big Buffers
Session Data
Thread Data
Data-Distribution Cache
Dictionary Cache
SQL Statement Cache
Sorting Memory
SPL Routine and the UDR Cache
Global Pool
Communications Portion of Shared Memory (UNIX)
Virtual-Extension Portion of Shared Memory
Concurrency Control
Shared-Memory Mutexes
Shared-Memory Buffer Locks
Types of Buffer Locks
Database Server Thread Access to Shared Buffers
FIFO/LRU Queues
Components of LRU Queue
Pages in Least-Recently Used Order
LRU Queues and Buffer-Pool Management
Number of LRU Queues to Configure
Number of Cleaners to Allocate
Number of Pages Added to the MLRU Queues
End of MLRU Cleaning
Configuring the Database Server to Read Ahead
Database Server Thread Access to Buffer Pages
Flushing Data to Disk
Flushing Buffer-Pool Buffers
Flushing Before-Images First
Flushing the Physical-Log Buffer
Synchronizing Buffer Flushing
Describing Flushing Activity
Foreground Write
LRU Write
Chunk Write
Flushing the Logical-Log Buffer
After a Transaction Is Prepared or Terminated in a Database with Unbuffered Logging
When a Session That Uses Nonlogging Databases or Unbuffered Logging Terminates
When a Checkpoint Occurs
When a Page Is Modified That Does Not Require a Before-Image in the Physical-Log File
Buffering Large-Object Data
Writing Simple Large Objects
Blobpages and Shared Memory
Creation of Simple Large Objects
Creation of Blobpage Buffers
Accessing Smart Large Objects
Memory Use on 64-Bit Platforms
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]