下面的查询清单1说明了哪些表空间使用哪些缓冲池。
The following query Listing 1 shows which table Spaces use which buffer pools.
大型缓冲池还会对查询优化产生影响，因为更多的工作可在内存中完成。
Large buffer pools also have an effect on query optimization, since more of the work can be done in memory.
要找出哪个缓冲池被分配给了表空间，请运行清单8中所示的查询。
To find out which buffer pool is assigned to table Spaces, run the query shown in Listing 8.
假设有一个针对非常大的表运行的查询，它使用同一个缓冲池并且需要读取比总的缓存区大小还多的页。
You might also have a query that runs against a very large table that USES the same buffer pool and involves reading more pages than the total buffer size.
一个缓冲池可满足的页面请求越多，将得到越高的查询性能。
The more page requests that can be satisfied by a buffer pool, the better query performance will be.
如果小型表拥有自己的缓冲池，那么它们就必须拥有自己的表空间，因此大型查询就不能覆盖它们的页。
If the small tables have their own buffer pool, thereby making it necessary for them to have their own table space, their pages cannot be overwritten by the large query.
缓冲区被调优之后，就能够通过查询它来验证调优效果或捕捉备份中的配置，这十分有帮助。
Once they have been tuned, it is helpful to be able to inquire on them to verify the tuning or to capture the configuration in a backup.
该查询只返回命中率低于90%的缓冲池。
The query returns only the buffer pools that have a lower hit ratio than 90%.
在结合IWA技术的情况下运行此项查询只需花费9分钟时间，我们可以减少Informix内存缓冲。
Running this query with IWA took nine minutes, and we were able to reduce the size of the Informix memory buffers.
若在一个含有垃圾回收器功能的活动堆栈上发生崩溃，应查询代码中的PInvokes函数，查是否因缓冲区太小而发生穿越行为。
If you get a crash and the top of the active stack contains a GC function, start looking for PInvokes in your code and see if you might be passing buffers that are too small.
服务使用XQuery根据对服务请求元数据查询的结果描述判定缓冲是否有效。
The service USES XQuery to determine if the cache is valid based on a query to the metadata description of the service request.
如果一项修改的目标是减少数据库的内存占用量，那么取消各种缓冲区肯定会有帮助，但是这会牺牲查询速度和应用程序性能。
If the goal of a change is to reduce the memory footprint of the database, eliminating various buffers will certainly help, at the expense of query speed and application performance.
查询在远程服务器上的编译，以及取足够的数据来填充union所有分支上的AT Q缓冲区，这两个过程是并行进行的。
The compilation of the query on the remote server and fetching of enough data to fill the ATQ buffer on all legs of the UNION will proceed in parallel.
问题查询：这些查询只返回超过重要性能计数器阈值的行，例如缓冲池命中率不到90%的行。
Problem queries: These queries return only rows that exceed thresholds for important performance counters, for example, rows with buffer pool hit ratio lower than 90%.
内存限制——64位所提供的额外内存可以支持更好的缓冲策略，使得应用程序可以避免开销很高的查询，等等。
Memory constrained -- The extra memory provided by 64-bit supports a better caching strategy, enabling the application to avoid expensive queries, and so on.
当您在大型审核日志表格中运行查询功能时，您可能会在您的数据库系统不得不向缓冲池读入数千页面以进行计算时而结束。
When you run queries for very large audit log tables, you can end up with a situation where your database system has to read thousands of pages into the bufferpool to compute the result.
完整的查询项被追加到了sql缓冲区。
通过查询syscat .BUFFER POOLS系统视图可以列出缓冲池信息，如清单7所示。
You can list buffer pool information by querying the SYSCAT.BUFFERPOOLS system view, as shown in Listing 7.
另外一个实用工具是qtune，用于公开队列缓冲区设置，使您能够查询和设置它们。
The other utility is qtune and its purpose is to expose the queue buffer Settings so that you can inquire on them and set them.
然后，联邦服务器上的SHIP逻辑发送'Fetch '请求，以便读取来自被发送到“ US ”数据源的查询的一块数据，并将数据放入ship缓冲区。
The SHIP logic on the federated server then sends' Fetch 'requests to read a block of data from the result of the query sent to the "US" data source and places the data into the SHIP buffer.
单独在Informix 上再次运行相同查询速度并没有快多少，因为无法将所有数据放入内存中，并且缓冲器一直在超负荷运转。
Running the same query a second time on Informix alone did not speed things up much because all the data would not fit in memory and the buffers were continually thrashing.
mytop还提供了一个有关关键字缓冲区和查询缓存效率的实时数据和历史数据，以及有关正在运行的查询的统计信息。
mytop also provides real-time and historical data about key-buffer and query-cache efficiency, and statistics about the queries being run.
在向查询使用者提供结果之前，会先将结果累计到输出缓冲区中。
Results will accumulate into an output buffer before they are available to the consumer of the query.
在查询串口是否有数据到来的时候这一段是很有用的，可以让程序在准备读取之前用来确定输入缓冲区里面的可读字节数。
This can be useful when polling a serial port for data, as your program can determine the number of bytes in the input buffer before attempting a read.
在查询串口是否有数据到来的时候这一段是很有用的，可以让程序在准备读取之前用来确定输入缓冲区里面的可读字节数。
This can be useful when polling a serial port for data, as your program can determine the number of bytes in the input buffer before attempting a read.
应用推荐