InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
When Should The Change Buffer Not Be Used? |
|
Answer» You might consider disabling the change buffer if the ENTIRE data set fits within the InnoDB buffer pool, if you have relatively few SECONDARY indexes, or if you are USING solid-state storage, where random reads are about as fast as sequential reads. Before making configuration changes, it is recommended that you run tests using a REPRESENTATIVE workload to determine if disabling the change buffer PROVIDES any benefit. You might consider disabling the change buffer if the entire data set fits within the InnoDB buffer pool, if you have relatively few secondary indexes, or if you are using solid-state storage, where random reads are about as fast as sequential reads. Before making configuration changes, it is recommended that you run tests using a representative workload to determine if disabling the change buffer provides any benefit. |
|