In our fourth evaluation, we analyzed the disk I/O for each of the workloads.
在第四个评估场景中,我们分析了不同工作负载下的磁盘输入/输出。
Most often, you want only a small subset of the data in the table, so a full table scan wastes a lot of disk I/O and therefore time.
通常来说,您可能只希望获得表中数据的一个子集,因此全表扫描会浪费大量的磁盘I/O,因此也就会浪费大量时间。
Part 3 of this series focuses on the application layer as you move on to file systems, using various commands to monitor and tune your file systems and disk I/O subsystems.
本系列文章的第 3部分将在您继续研究文件系统的同时,重点关注于应用程序层,并使用各种命令以监视和优化您的文件系统和磁盘I/O 子系统。
Unlike the tuning of other subsystems, tuning disk I/O should actually be started during the architectural phase of building your systems.
与其他子系统的优化工作不同,实际上在构建系统的体系结构设计阶段就应该开始进行磁盘I/O 优化。
The test site remains bottlenecked on the database server I/O and bound by performance characteristics of the database server disk.
测试网站仍然遭遇数据库服务器I/O瓶颈,并受数据库服务器磁盘性能的限制。
The hit ratios for data and index pages reflect the number of times a page request was handled by the buffer pool directly without requiring disk I/O.
数据和索引页面的击中率反映了缓冲池在不需要磁盘I/O的情况下直接处理一个页面请求的时间量。
Transactions requiring disk I/O, such as flushing dirty pages from the buffer pool or flushing logs from the log buffer, may wait.
要求磁盘I/O 的事务,例如刷新缓冲池中的脏页或者刷新日志缓冲区中的日志,可能需要等待。
This setting controls the size of the NSF buffer pool, a section of memory dedicated to buffering I/O transfers between the NIF indexing functions and disk storage.
这个设置控制NSF缓冲池的大小,后者是用于缓冲NIF索引函数与磁盘存储之间的I/O传输的一部分内存。
We are more proficient in analyzing the amount of the processor used and the amount of memory used, and we are now focusing more on the amount of disk I/O used (performance and configuration).
我们已经可以更加专业地分析处理器使用量和内存使用量,现在我们更多地关注磁盘I/O 使用量(性能和配置)。
New compression support for XML data and indexes reduces disk space requirements and can improve runtime performance of I/O-bound operations.
新的XML数据和索引压缩支持可以减少所需的磁盘空间,可以提高受I/O 限制的操作的运行时性能。
The reduction in disk I/O reduces execution time.
磁盘I/O 的减少也减少了执行时间。
The additional network hop and disk I/O is adding significant time to the transactions.
在执行过程中,网络跳转与磁盘I/O操作耗费了大多数时间。
This can cut the time required to process queries by as much as 20 percent because more data can be kept in memory, reducing the number of I/O operations to slower mechanical disk drives.
这导致处理查询所需的时间降低了 20%,因为可以在内存中保存更多数据,减少了对缓慢的机械磁盘驱动器的I/O操作次数。
The reason for this is to limit the amount of dirty pages in memory, which further reduces I/O overhead and disk fragmentation.
这么做可以限制内存中 “脏”页面的数量,从而进一步减少I/O开销和磁盘碎片。
There are many other areas of investigation, for example, hardware, disk I/O, configuration, topology, tuning parameters, OS, and patches, among others.
还需要调查其他很多方面,比如硬件、磁盘I/O、配置、拓扑、调优参数、OS和补丁等。
Some of the test types require less CPU and disk space, whereas some of the test types requires high CPU usage, I/O operations, and disk usage.
一些测试类型需要较少的CPU和磁盘空间,而另一些测试类型需要较高的 CPU使用率、I/O操作和磁盘使用率。
So, if hit ratios are low, a significant amount of disk I/O is taking place.
所以,如果击中率较低,表明正在发生大量的磁盘I/O。
Direct I/O bypasses the use of the file system buffers, and therefore is more efficient for reads and writes that go to disk.
而直接I/O 可以避免使用文件系统缓冲区,因而对于磁盘的读写更为高效。
Note that you can also remount existing filesystems and set the I/O pacing, which can be helpful if you want to alter the performance of a disk that is already actively providing service.
注意,还可以重新挂载现有的文件系统并设置I/O 处理速率调整,这有助于调整已经在提供服务的磁盘的性能。
MQ performance is commonly bound by disk I/O writes.
MQ性能常常受到磁盘I/O写入的限制。
The function of AIO is to perform disk I/O when SQL statement accessing or updating database data.
AIO的功能是在SQL语句访问或更新数据库数据时,执行磁盘I/O。
Therefore, OLTP transactions often spend a great deal of time waiting on disk I/O.
因此,OLTP事务通常会需要大量的磁盘I/O等待时间。
The closer the ratio is to 100 percent, the lower the frequency of disk I/O, and therefore the less overhead of reading data.
命中率越接近 100%,磁盘I/O的频率就越低,因而读取数据的开销就越少。
This reduces the disk I/O and significantly improves the performance and throughput.
这会减少磁盘I/O并显著提升性能和吞吐量。
The type blockio sets the disk to direct block I/O mode without page cache.
类型blockio 把这个磁盘设置为直接块I/O模式,没有页面缓存。
With these versions, Lotus developers carefully picked what are often the highest value targets for reducing TCO: disk space, storage costs, I/O operations, and the cost of operational maintenance.
通过这些版本,Lotus开发人员仔细地筛选出了最有利于降低TCO 的目标:磁盘空间、存储成本、I/O操作和操作维护成本。
The I/O might involve reading data from a disk, or a database, or a web service, or even from a user.
I/O可能涉及到从一个磁盘、一个web服务或甚至是一名用户读取数据。
The vmstat tool outputs thread/process information, memory/swap usage, page ins/outs, disk I/O, page faults, and CPU statistics.
vmstat工具输出线程/进程信息、内存/交换区使用率、换进/换出页面、磁盘I/O、页面错误和CPU统计信息。
The greater the value, the fewer spills to the disk, thus reducing I/O times on the map side.
这个值越大,溢出到磁盘就越少,因此会减少map 端的I/O时间。
Other RAS features include dynamic firmware maintenance and hot-swappable disk bays for servers and I/O drawers.
其他RAS特性包括动态固件维护以及用于服务器和I/O drawer 的可热交换磁盘托架。
应用推荐