但是,如果总的缓冲区大小太大,并且没有足够的存储器可用来分配给它们,那么将为每种页大小分配最少的缓冲池,性能就会急剧下降。
However, if the total buffer size is too large, and there is not enough storage to allocate them, a minimum system buffer pool for each page size is allocated, and performance is sharply reduced.
与其他内存缓冲区相比,缓冲池对数据库性能的影响最为显著。
Compared to other memory buffers, buffer pools have the most significant impact on database performance.
拥有多个缓冲池可以将数据保存在缓冲区中。
Having more than one buffer pool can preserve data in the buffers.
应用推荐