What Is The Benefit Of The Innodb Change Buffer?

1.	What Is The Benefit Of The Innodb Change Buffer?
Answer» Buffering secondary INDEX CHANGES when secondary index pages are not in the buffer pool avoids expensive random access I/O OPERATIONS that would be required to IMMEDIATELY read in affected index pages from DISK. Buffered changes can be applied later, in batches, as pages are read into the buffer pool by other read operations. Buffering secondary index changes when secondary index pages are not in the buffer pool avoids expensive random access I/O operations that would be required to immediately read in affected index pages from disk. Buffered changes can be applied later, in batches, as pages are read into the buffer pool by other read operations.

Answer»

Buffering secondary INDEX CHANGES when secondary index pages are not in the buffer pool avoids expensive random access I/O OPERATIONS that would be required to IMMEDIATELY read in affected index pages from DISK. Buffered changes can be applied later, in batches, as pages are read into the buffer pool by other read operations.

Buffering secondary index changes when secondary index pages are not in the buffer pool avoids expensive random access I/O operations that would be required to immediately read in affected index pages from disk. Buffered changes can be applied later, in batches, as pages are read into the buffer pool by other read operations.

Discussion

No Comment Found

Related InterviewSolutions

What Types Of Operations Modify Secondary Indexes And Result In Change Buffering?
What Is The Benefit Of The Innodb Change Buffer?
Does The Change Buffer Support Other Types Of Indexes?
How Much Space Does Innodb Use For The Change Buffer?
How Do I Determine The Current Size Of The Change Buffer?
When Does Change Buffer Merging Occur?
When Is The Change Buffer Flushed?
When Should The Change Buffer Be Used?
When Should The Change Buffer Not Be Used?
Can I Commit Or Roll Back Transactions Inside A Stored Procedure?