如果一项修改的目标是减少数据库的内存占用量，那么取消各种缓冲区肯定会有帮助，但是这会牺牲查询速度和应用程序性能。
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.
缓冲区被调优之后，就能够通过查询它来验证调优效果或捕捉备份中的配置，这十分有帮助。
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.
完整的查询项被追加到了sql缓冲区。
另外一个实用工具是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.
若在一个含有垃圾回收器功能的活动堆栈上发生崩溃，应查询代码中的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.
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.
在向查询使用者提供结果之前，会先将结果累计到输出缓冲区中。
Results will accumulate into an output buffer before they are available to the consumer of the query.
应用推荐