Rechercher dans le manuel MySQL
A.15 MySQL 8.0 FAQ: InnoDB Change Buffer
- A.15.1. What types of operations modify secondary indexes and result in change buffering?
- A.15.2. What is the benefit of the InnoDB change buffer?
- A.15.3. Does the change buffer support other types of indexes?
- A.15.4. How much space does InnoDB use for the change buffer?
- A.15.5. How do I determine the current size of the change buffer?
- A.15.6. When does change buffer merging occur?
- A.15.7. When is the change buffer flushed?
- A.15.8. When should the change buffer be used?
- A.15.9. When should the change buffer not be used?
- A.15.10. Where can I find additional information about the change buffer?
A.15.1. | What types of operations modify secondary indexes and result in change buffering? |
| |
A.15.2. |
What is the benefit of the |
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. | |
A.15.3. | Does the change buffer support other types of indexes? |
No. The change buffer only supports secondary indexes. Clustered indexes, full-text indexes, and spatial indexes are not supported. Full-text indexes have their own caching mechanism. | |
A.15.4. |
How much space does |
Prior to the introduction of the
In MySQL 5.6 and later, the
Change buffer pages are not required to persist in the buffer pool and may be evicted by LRU operations. | |
A.15.5. | How do I determine the current size of the change buffer? |
The current size of the change buffer is reported by
Relevant data points include:
For information about monitoring change buffer status, see Section 15.5.2, “Change Buffer”. | |
A.15.6. | When does change buffer merging occur? |
| |
A.15.7. | When is the change buffer flushed? |
Updated pages are flushed by the same flushing mechanism that flushes the other pages that occupy the buffer pool. | |
A.15.8. | When should the change buffer be used? |
The change buffer is a feature designed to reduce random I/O to
secondary indexes as indexes grow larger and no longer fit in
the | |
A.15.9. | When should the change buffer not be used? |
You might consider disabling the change buffer if the entire
data set fits within the | |
A.15.10. | Where can I find additional information about the change buffer? |
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-faqs-innodb-change-buffer.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.