When you create a table space, you can associate it with a specific buffer pool (database cache) as well as to specific containers.
当创建表空间时,可以将它与特定的缓冲区池(数据库缓存)关联起来,并关联到特定的容器。
Memory impacts the number of client connections and the size of the buffer pool and database cache allocated by the server.
内存影响客户端连接的数量、缓冲池的大小,以及服务器分配的数据库缓存的大小。
Identify problems with memory, including low buffer pool hit ratios, catalog cache hit ratios, and package cache hit ratios.
识别内存问题,包括较低的缓冲池命中率、较低的目录缓存命中率和较低的包缓存命中率。
Writes Cache: Parentage of time that a page was written to the buffer pool but not to disk.
WritesCache:页面写到缓冲区池(而不是磁盘)的次数百分比。
Read Cache: Percentage of times the page should be read from the buffer pool.
ReadCache:应该从缓冲区池读取的页面百分比。
Read Cache: Percentage of times the page should be read from the buffer pool.
ReadCache:应该从缓冲区池读取的页面百分比。
应用推荐