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.
但是,如果总的缓冲区大小太大,并且没有足够的存储器可用来分配给它们,那么将为每种页大小分配最少的缓冲池,性能就会急剧下降。
Use the database system monitor to help you tune this configuration parameter using information from the snapshot data (or event monitor) about write activity from a buffer pool.
使用数据库系统监视器,利用有关从缓冲池进行写操作的快照数据(或事件监视器)信息来帮助您调优该配置参数。
This 8mb buffer holds over 40,000 trace records that can be useful in diagnosing system and transaction work related to optimized local adapter requests.
这个8MB的缓冲区存放超过40,000条跟踪记录,可用于诊断系统和有关优化的本地适配器请求的事务工作。
Tune the federated system for local processing in the areas of application heap, statement heap, buffer pool, sort heap, and temp tablespace.
为应用程序堆、语句堆、缓冲池和临时表空间这些区域中的本地处理调优联邦系统。
For example, say that you cannot afford to have large buffer pools due to memory constraints on the test system and would like to configure the size the same without actually having them in reality.
例如,假设由于测试系统上的内存约束,您无法获得大型的缓冲池,并且希望将大小配置得相同,实际上却不是真正有这么大。
You can use the snapshot report to derive information such as the buffer pool hit ratio, amount of sort heap overflows, and the system workload.
您可以使用快照来获得诸如缓冲池命中率、排序堆溢出的次数以及系统工作负载之类的信息。
Information about system configuration can include the size of the buffer pool, the sort heap, and more.
关于系统配置的信息包括缓冲池的大小、排序堆的大小等等。
The kernel ring buffer is also used for some events after the system is booted. These include certain program failures and hot-plug events.
在系统启动后,内核环缓冲区也可以用于一些事件,其中包括某些程序失败和热插拔事件。
Beginning in 2004, users should start avoiding any operating system that fails to provide at least some automatic protection against buffer overflows.
从2004年开始,用户应该开始避免使用这样的操作系统,即它们至少没有对缓冲区溢出提供某种自动保护机制。
Further, applications that might benefit from having a file system read ahead or high buffer cache hit rates might actually see performance degradation.
而且,对于那些受益于文件系统预读功能或者较高缓冲区缓存命中率的应用程序,可能会出现性能的降低。
If your system has a low buffer pool hit ratio, you can increase the buffer pool size further to achieve better application performance result.
如果您的系统具有较低的缓冲池命中率,您就可以通过增加缓冲池大小来进一步地取得更好的应用程序性能结果。
When you configure new buffer pools, make sure that you understand how it impacts the available memory of your system.
当您配置新的缓冲池时,一定要理解它对系统可用内存的影响。
The journal is a special file that logs the changes destined for the file system in a circular buffer. At periodic intervals, the journal is committed to the file system.
所谓日志就是一种特殊的文件,它会在一个循环的缓冲区内记录文件系统的修改,然后将其定期提交到文件系统。
Without file system caching, this overhead is mitigated by the fact that XML columns are buffered in the DB2 buffer pool and CLOB columns are not.
在没有文件系统缓存的情况下,xml列在db2缓冲池进行缓冲而clob列则不是,从而可降低开销。
Since a DB2 buffer pool is a part of the main memory of the system, the DB2 database manager allocates it for caching tables and index data when it reads or writes to and from media disks.
因为db2缓冲池是系统主内存的一部分,DB 2数据库管理器在它读取或写入磁盘介质时将它分配给缓存表和索引数据。
To calculate the maximum buffer size, DB2 considers all other storage utilization, the operating system, and any other applications.
要计算最大的缓冲区大小,DB 2、操作系统以及其它任何应用程序都必须考虑其它所有存储器的利用率。
Without file system caching, Q1 performs similarly on XML and CLOB columns, with a slight disadvantage (10%) for the CLOB column which is not buffered in the buffer pool.
在没有文件系统缓存的情况下,XML和clob列的Q1执行效果类似,不在缓冲池进行缓冲的clob列略微落后(10%)。
For for a large OLTP database, set aside as much as memory as possible for the buffer pool while keeping the system stable.
对于大型OLTP数据库,在保持系统稳定的同时为缓冲池留出尽可能多的内存。
If your system is constrained on memory, you can reduce the size of buffer pools in the target database because the DB2 LOAD utility does not use buffer pools.
如果系统内存不充裕,那么可以减少目标数据库中缓冲池的大小,因为DB 2LOAD实用程序不使用缓冲池。
For example, the access path can change from one system to another if they have different buffer pool sizes, even if all the catalog statistics are identical.
例如,如果两个系统的缓存池大小不一样,即使目录统计一样,访问路径也可能不同。
Journaling file systems use a journal to buffer changes to the file system (which is also used in crash recovery) but can use different strategies for when and what is journaled.
日志文件系统是使用日志来缓冲文件系统的修改(同时也可以应用于紧急故障恢复)的,但可以根据记录的时间与内容采取不同的策略。
This is a useful approach, but note that this does not protect against buffer overflows overwriting other values (which they may still be able to use to attack a system).
这是一种有用的方法,不过要注意这种方法无法防止缓冲区溢出改写其他值(攻击者仍然能够利用这些值来攻击系统)。
Create regular tablespace TS page, size 16k, managed by system using (FNIS buffer pool BP).
创建常规表空间TS页面,大小16K,由系统管理(fnis缓冲池BP)。
Sendfile (2) is a technique that avoids buffer copy overhead, and it directly pushes bits from the file system onto the network.
Sendfile(2)是一种避免缓冲区复制开销的技术,并且它直接将数据位从文件系统转移到网络。
This command USES the klogctl system call to read the kernel ring buffer and emit it to standard output (stdout).
这个命令使用klogctl系统调用来读取内核环缓冲区,并将它转发到标准输出(stdout)。
Increasing the size of this buffer allows the system to map more virtual memory, which results in a lower miss rate for applications that use a lot of virtual memory like Oracle.
增加这个缓冲区的大小允许系统映射更多的虚拟内存,其结果是使得使用大量虚拟内存的应用程序(如Oracle)的缺页率更低。
You can list buffer pool information by querying the SYSCAT.BUFFERPOOLS system view, as shown in Listing 7.
通过查询syscat .BUFFER POOLS系统视图可以列出缓冲池信息,如清单7所示。
The database manager configuration parameter rqrioblk controls the size of the communication buffer between the federated system and the data sources.
数据库管理器参数rqrioblk控制着联邦系统与数据源之间的通信缓冲区的大小。
Access to the log buffer is provided at the core through the multi-purpose syslog system call.
多用途的syslog系统调用提供了内核的日志缓冲区访问方法。
Access to the log buffer is provided at the core through the multi-purpose syslog system call.
多用途的syslog系统调用提供了内核的日志缓冲区访问方法。
应用推荐