...,将缓冲区划分成多个小块,存储不同的写入数据,而不必为小数据浪费整个缓冲区空间,同时还可以等所有段写满后统一写入,性能更好。读缓存(Read Cache),将读取过的数据暂时保存在缓冲区中,如果主机再次需要时可直接从缓冲区提供,加快速度。
基于144个网页-相关网页
Cache Read 同一个块操作
Read Cache: Percentage of times the page should be read from the buffer pool.
Read Cache:应该从缓冲区池读取的页面百分比。
Read cache hits should be in excess of 99 percent, and we would like write cache hits to be above 95 percent.
读命中率应超过 99%,写缓存命中率最好达到 95% 左右。
We cannot pay attention to read cache hit rate since we have been sequentially scanning a huge table over and over.
由于我们一遍又一遍地顺序扫描一个巨大的表,这样我们就无法关注读缓存命中率。
应用推荐