InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Do I Determine The Current Size Of The Change Buffer? |
|
Answer» The CURRENT SIZE of the change BUFFER is reported by SHOW ENGINE INNODB STATUS G, under the INSERT BUFFER AND ADAPTIVE HASH INDEX heading. For example: INSERT BUFFER AND ADAPTIVE HASH INDEX Ibuf: size 1, free list len 0, seg size 2, 0 merges Relevant data points include: size: The number of pages used within the change buffer. Change buffer size is EQUAL to seg size - (1 + free list len). The 1 + value represents the change buffer header page. seg size: The size of the change buffer, in pages. The current size of the change buffer is reported by SHOW ENGINE INNODB STATUS G, under the INSERT BUFFER AND ADAPTIVE HASH INDEX heading. For example: INSERT BUFFER AND ADAPTIVE HASH INDEX Ibuf: size 1, free list len 0, seg size 2, 0 merges Relevant data points include: size: The number of pages used within the change buffer. Change buffer size is equal to seg size - (1 + free list len). The 1 + value represents the change buffer header page. seg size: The size of the change buffer, in pages. |
|